Connector Guides › Connectors Guide › Database Connectors › Oracle Connector › Oracle Configuration

Oracle Configuration

The Oracle connector must be managed with the Java Connector Server installation process. For more information on this installation process, click here.

To administer Oracle machines with CA Identity Manager, the Oracle connector must be installed on each Provisioning server.

The Oracle GUI plug-in must be installed on the machine where the Provisioning Manager is installed. No additional Oracle agent, client, or driver installation is required.

Communication between the Provisioning Server and the Oracle server relies on a JDBC connection. A URL specifies connection details to each server, as illustrated in the following example:

jdbc:oracle:thin:@hostname:port:servicename

Where the field definitions are:

• hostname

  The hostname or IP address of the Oracle Server

• port

  The numeric port number of the Oracle service. The default value for this is 1521.

• servicename

  Oracle Service Name to connect to.

For example, the following URL would connect to an Oracle instance named ORACLE running on the default port on server oracle_server_host:

jdbc:oracle:thin:@oracle_server_host:1521:ORACLE

For more information, see the Oracle JDBC site:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm