Establishing a Connection

Connecting to Oracle OCI

Oracle OCI supports the following connection types:

After you have added the appropriate libraries to your PATH (as described in Before You Connect), set these properties:

User: The user Id provided for authentication with the Oracle database.
Password: The password provided for authentication with the Oracle database.
Port: The port used to connect to the server hosting the Oracle database.
ServiceName: The service name of the Oracle database. You can obtain this value by querying global_name (select * from global_name) using the Oracle SQL*PLUS command line.
Server: The host name or IP address of the server hosting the Oracle database.

To authenticate via OracleTNS, set these properties:

User: The user Id provided for authentication with the Oracle database.
Password: The password provided for authentication with the Oracle database.
DataSource: The connect descriptor (TNS connect string) or a connection name identifies the database you need to connect to. You can find these values in your tnsnames.ora file.

For example,

DataSource='(DESCRIPTION=(ADDRESS=(protocol_address_information))(CONNECT_DATA= (SERVICE_NAME=service_name)))'

To authenticate via the LDAP server, set these properties.

User: The user Id of a user account associated with the Oracle database.
Password: The password associated with the specified user account.
LDAPUri: The LDAP URI associated with the LDAP server you want to connect to.
LDAPUser: The name of the user account on the specified LDAP server that you want to use to connect to Oracle OCI data.
- Optional if your system administrator allows anonymous LDAP logins.
LDAPPassword: The password associated with the specified LDAP user.
- Optional if your system administrator allows anonymous LDAP logins.

Your connection string should look similar to this:

LDAPUri=ldap://myldap.com:389/SERVICE_EXMPL,cn=OracleContext,dc=example,dc=com; User=ORACLEUSER; Password=OracleUserPassword;