Press "Enter" to skip to content

How to Connect Oracle Database in JDeveloper (12c)?

In this tutorial, you will learn how to connect Oracle Database in JDeveloper. JDeveloper version used for this example is 12c and following is the Oracle Database information to which we connect:

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
)

Connect to Oracle Database Using JDeveloper (12c) Example

  1. In JDeveloper, click on the menu File > Application.
  2. A New Gallery window will open.
  3. In New Gallery window, under categories click on the Connections node and then right-side connections options will display.
  4. Then on the right side, click on the Database Connection option and then click on the OK button to open Create Database Connection window as shown in below image.

Connect Oracle Database using Oracle JDeveloper

  1. Then specify the connection name in the Connection Name field. Specify username and password. Specify the hostname, JDBC Port (Oracle Database Port Number) and the SID for the connection. Then click on the Test Connection button to test. If it shows the Success message, then it means your Oracle Database connection is successful. Click on the OK button to finish.

The Oracle Database connection is now created using Oracle JDeveloper.

See also:

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *