Adding an Oracle connection

To add an Oracle connection:

  1. Open the Manage Data Sources page.
  2. Click New and select Oracle.
  3. Specify a name for the data source. The name must be unique.
  4. Select the category.
  5. Specify the user name of the database owner.
  6. Specify the password for the database owner.
  7. Specify the name of the host computer on which the Oracle software is installed.
  8. Specify the Oracle system ID (SID) of the database instance.
  9. Specify the port number. The default is 1521.
  10. Specify the TNS name. A TNS is an alias for a connection string. The TNS name is required and must be specified in the tnsnames.ora file. The TNS name in the tnsnames.ora file includes the host name, system ID, and port number for each TNS name.
  11. Select the database for the data source. If necessary, click Refresh to update the list of available databases.
  12. Click Test Connection. If this is not successful, review and correct the connection information.
  13. Click Save.