Connecting to Oracle Database from SQL Developer

SQL Developer is a client program with which you can access Oracle Database. This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle Database. If SQL Developer is not installed on your system, see Oracle Database SQL Developer User's Guide for installation instructions.

Note: For the following procedure:

The first time you start SQL Developer on your system, you must provide the full path to java.exe in step 4.
For step 7, you need a user name and password.
For step 9, you need a host name and port.

To connect to Oracle Database from SQL Developer:

Access the menu from which you can select SQL Developer:
- On a Windows system: From the Start menu, select All Programs.
- On a Linux system:
  - On Gnome: Click Application.
  - On KDE: Click K.
Select Oracle - ORACLE_HOME.
Select Application Development.
Select SQL Developer.

If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java.exe (for example, C:\jdk1.5.0\bin\java.exe). Either type the full path after the prompt or browse to it, and then press the key Enter.

The Oracle SQL Developer window opens.
In the navigation frame of the window, click Connections.

The Connections pane appears.
In the Connections pane, click the icon New Connection.

The New/Select Database Connection window opens.
In the New/Select Database Connection window, type the appropriate values in the fields Connection Name, Username, and Password.

For security, the password characters that you type appear as asterisks.

Near the Password field is the check box Save Password. By default, it is deselected. Oracle recommends accepting the default.
In the New/Select Database Connection window, click the tab Oracle.

The Oracle pane appears.
In the Oracle pane:
- For Role, accept the default.
- For Connection Type, accept the default (Basic).
- In the fields Hostname and Port, type the appropriate values.
- Select the option SID.
- In the SID field, type the appropriate value.
In the New/Select Database Connection window, click the button Test.

The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success.
If the test succeeded, click the button Connect.

The New/Select Database Connection window closes. The Connections pane shows the connection whose name you entered in the Connection Name field in step 7.

You are in the SQL Developer environment.

To exit SQL Developer, select Exit from the File menu.

Note: Exiting SQL Developer ends the SQL Developer session, but does not shut down the Oracle Database instance. The next time you start SQL Developer, the connection you created using the preceding procedure still exists. SQL Developer prompts you for the password that you supplied in step 7 (unless you selected the check box Save Password).

Connecting to Oracle Database from SQL Developer

Related Topics