Tuesday, April 9, 2013

How to register Oracle Database XE with Oracle JDeveloper and Edit, unblock the users

For working with oracle database server via Oracle JDeveloper for database designing, database development, database connectivity with your project for database driven desktop and web applications development,  database registration is required with JDeveloper IDE. Oracle Jdeveloper is giving better tooling support for database designing, edit, creation and deletion. To register oracle database 11g XE with  JDeveloper, follow the below instruction


For this Tutorial, Oracle JDeveloper and Oracle database should be already installed. If these are not already installed, read my below blog for installation

How to install JDeveloper 11g IDE, ADF Run time and Web Logic Server

How to install Oracle Database XE 11g R2


Run the oracle JDeveloper and from file menu click at View -> Database -> Database Navigator   as showing in snapshot below


How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

For database new connection, Right click at IDE Connecter and select the New connection option

How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

A Popup window will open for creation the database connection,
give the connection name  for example Oracle_xe
Give the user name and password for your database  like SYSTEM

Give the SID for your database. For Oracle Database XE, the default SID is XE. For same computer Host name will be localhost and if database is installed at any other computer then give the IP of that computer.

Click at Test button. If given information are OK then test result will success otherwise it will give error.

Click at OK to complete the connection setup

How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

Now you can work with your database. If you have log in with administrator password you can create, delete, edit the database and users and much more.

How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

To Edit and unblock the user follow the below as showing in snapshot. Double click the other users option to open the sub tree, now all added database users are listed.


How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

For example to edit the HR user. Right click on it and click at edit user
How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

A pop up window will open for database users creation and edit. Here you will find all options for users password creation / edition, Lock / unlock user, Roles etc.
How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

Here in role type, you can assigned roles to users like admin role, DBA Role, creation, deletion, views etc.

How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE

In result tab, your all modification detail will be shown in SQL statements. By clicking at apply button, all modification will be applied to database with new roles,

How to register Oracle Database 11g XE with Oracle JDeveloper and Edit, unblock the database users. oracle jdeveloper tutorials, oracle database XE tutorial, database management tutorial, oracle XE, database XE, how to edit and unblock database user in oracle database xe, oracle database XE connectivity with Jdeveloper, database administration, database software, java web action, database development software tool, oracle database server, Oracle database 11g XE


Congratulation, you have been successfully registered the Oracle database 11g XE with Oracle JDeveloper studio. Now you are able to work with databases from Jdeveloper IDE.


Related Topics:


How to Connect Oracle Database XE with NetBeans IDE using JDBC Thin driver

35 comments:

  1. Hi , very good article, thanks for providing in-depth information on Oracle ADF Technology. Please continue sharing.

    ReplyDelete
  2. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing

    dot net training in chennai

    php training in chennai

    java training in chennai

    ReplyDelete
  3. for preparing bank exam and group exam , we are providing an online test model questions papers

    Group Exam Questions and Answers
    Bank Exam Questions and Answers

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Core java is vital for java so as to being utilized in any java generation without this no one can jump on any decorate java era. in which as enhance java is specialization in a few place, which incorporates networking, the internet, com or database dealing with.
    for more additional information please visit site
    Oracle Fusion procurement Training
    Oracle Fusion Cloud procurement Training

    ReplyDelete

  6. your site is genuine to view sir
    thank you for your valluable information sir
    regards
    http://www.erptree.com/course/oracle-fusion-procurement-online-training-in-kolkata/

    ReplyDelete
  7. Web Design Sydney: I really appreciate this post and I like this very much. I am waiting for new post here and Please keep it up in future. .Logo Design Sydney,Logo Design in Coimbatore

    ReplyDelete
  8. cute blog with colourful images, really I appreciate your works. All the articles are very interesting to read Motorcycle Ear Plugs , Musicians Earplugs Custom Ear Plugs

    ReplyDelete
  9. Hello, I discovered your weblog in the new directory of blogs. I dont know how your website emerged. Your weblog looks good. Enjoy a nice day. hosting reviews

    ReplyDelete
  10. Hadoop Training Institute in Noida, The Hadoop

    certification has considerable advantages in addition to the great demand for trained professionals. A certified Hadoop professional gets the

    advantage in terms of payment package compared to other professionals working in the field without certification. When it comes to IJP, Hadoop

    certification is compatible to advance the ladder and accelerate your career. big data hadoop training in Noida, big data hadoop Training institutes

    in Noida, sector 2, oracle big data training,Oracle Training

    in Noida
    , big data boot camp, nosql database training, big data appliance training, exalytics training, exadata course, big data introduction,

    oracle course, oracle training, big data training in Noida, ibm big data hadoop training institutes noida
    Hadoop Training Institute in Noida

    CONTAC CIITN:

    B-12, Sector - 2, Noida, U.P
    State - Uttar Pradesh U.P
    Country - India
    Pin Code - 201301

    Phone - +917290926565
    Mon - Sun: 10am - 6pm

    ReplyDelete
  11. You have discussed an interesting topic that every designer to know. Very well explained with examples. Spark interact is recruiting for 2018 check out the great new positions and apply online now Visit web design sydney and upload your resume.

    ReplyDelete
  12. Spark Interact web design sydney with 12+ years experience in Web development & WordPress. With High quality Website Design & Affordable prices

    ReplyDelete
  13. It 's excellent posting and useful for developers
    Oracle SOA Online Training

    ReplyDelete

Please enter relevant question and information.