Connecting to Oracle AI Database from SQL Developer

SQL Developer is a client program with which you can access Oracle AI Database.

You are encouraged to use the currently available release of SQL Developer, which you can download from:

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/ This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle AI Database. If SQL Developer is not installed on your system, then see Oracle SQL Developer User’s Guide for installation instructions.

Note:

To connect to Oracle AI Database from SQL Developer:

  1. Start SQL Developer.

    For instructions, see Oracle SQL Developer User’s Guide.

    If this is the first time you have started SQL Developer on your system, you are prompted to enter the path to the Java Development Kit (JDK) installation (for example, C:\Program Files\Java\jdk1.8.0_65). Either type the path after the prompt or browse to it, and then press the key Enter.

  2. In the Connections frame, click the icon New Connection.

  3. In the New/Select Database Connection window:

    1. Type the appropriate values in the fields Connection Name, Username, and Password.

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

      Near the Password field is the check box Save Password. By default, it is deselected. Typically, you leave this check box deselected.

    2. If the Oracle pane is not visible, click the Oracle tab.

    3. In the Oracle pane, accept the default values.

      (The default values are: Connection Type, Basic; Role, default, Hostname, localhost; Port, 1521; SID option, selected; SID field, xe.)

    4. Click the Test button.

      The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success.

    5. If the test succeeded, click the Connect button.

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

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 AI 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 3. (unless you selected the check box Save Password).

See Also: