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

22 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

Please enter relevant question and information.