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

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

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Blog
  • 1 min read

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: