Installation Guide › Installing Client Applications › Install Oracle Client Components

Install Oracle Client Components

When an Oracle server hosts CA RCM databases, you install Oracle Client components on computers that run CA RCM client applications. 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 RCM client applications.
2. Run the Oracle Client installer. 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 RCM 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.