Administer Operator Categories and Custom Operator Groups › Configuring Operator Categories › Configure Databases: Default Oracle Properties

Configure Databases: Default Oracle Properties

You can configure the Databases category of operators for Oracle.

Follow these steps:

1. Click the Configuration tab, select Domain, and click Lock.
2. Click the Modules tab, right-click Databases, and select Edit.
3. On the Default Oracle Properties tab, select one of the following values as the default Oracle JDBC driver type. Use a JDBC version that matches the Java Development Kit (JDK) version.

   thin

   The Thin Driver type is used on the client side with no Oracle installation. The Thin driver connects to the Oracle database with Java sockets.

   oci

   The OCI Driver type is used on the client side with Oracle installed. The OCI drivers use the Oracle Call Interface (OCI) to interact with the Oracle database.

   kprb

   The KPRB Driver type is used to write Java database stored procedures and triggers.

4. Accept the default driver entry (oracle.jdbc.OracleDriver), or change the driver entry.
5. Enter the location of the Oracle server and login credentials:
   1. Enter the server host where the Oracle database is running.
   2. Enter the default port for the Oracle database.
   3. Enter the default user name for the Oracle database user.
   4. Enter the password that is associated with the specified user name.
6. Enter the Oracle Service ID.
7. Enter the source of the contents of tnsnames.ora in the Oracle directory.

   The Oracle TNS Names file translates a local database alias to information that enables the connectivity to the database. This information includes the IP address, the port, and the database Service ID.

8. Accept the default maximum number of rows to retrieve (10), or select another value up to 512.
9. Enter the default data encryption method. Consider entering one of the following values, where RCA_128 and RCA_256 are for domestic editions only:
   • RC4_40
   • RC4_56
   • RC4_128
   • RC4_256
   • DES40C
   • DES56C
   • 3DES112
   • 3DES168
   • SSL
   • AES128
   • AES256
   • AES192
10. Enter the default from the checksums that Oracle supports. See your Oracle documentation.
11. Click Save and Close.
12. Click Save.
13. Select Domain and click Unlock.

More information:

Category Configuration and Operator Inheritance

About Databases

Configuring Operator Categories