How to Configure an Oracle 11g Connection

Available in the Enterprise edition only.
The steps for configuring a connection to an Oracle 11g server are the following:
  1. Open the Preferences dialog and go to Data Sources.
  2. In the Connections panel, click the New button.

    The dialog for configuring a database connection will be displayed.

    The Connection Configuration Dialog

  3. Enter a unique name for the connection.
  4. Select an Oracle 11g data source in the Data Source combo box.
  5. Fill-in the connection details.
    1. Fill-in the URL of the Oracle server.
    2. Fill-in the user name for the connection to the Oracle server.
    3. Fill-in the password for the connection to the Oracle server.
  6. Click the OK button to finish the configuration of the database connection.