Installation Guide › Installing Additional Components › Install Oracle Client Components

Install Oracle Client Components

When an Oracle server hosts CA GovernanceMinder databases, you install Oracle Client components on computers that run CA GovernanceMinder Client Tools. These components support client interaction with databases on the Oracle server.

To install Oracle Client components

1. Download an Oracle Client installation package that is compatible with the target Oracle server from the Oracle website to the computer that hosts CA GovernanceMinder Client Tools.
2. Run the Oracle Client installer and install the following components:
   • Oracle Database Utilities
   • SQL*Plus
   • Oracle Windows Interfaces components:

     Oracle Objects for OLE

     Oracle Provider for OLE DB

3. Unzip the Oracle Client installer.
4. Create a tnsnames.ora file that defines the connection to the main CA GovernanceMinder database on the Oracle server.

   For example, the following code defines a TCP link to the rcm_sdb database on the XE database server.

   XE =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = ORAC01.com)(PORT = 1521))
   (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME =rcm_sdb))
   )
   

5. Copy the tnsnames.ora file to the following directory:

   Oracle_home\network\admin
   

   Note: Oracle_home is the root directory for the Oracle Client package.