Reports Integration Guide › Deployment › CA Business Intelligence › CA Business Intelligence Requirements › Add a CA Data Protection CMS Entry to Tnsnames.ora

Add a CA Data Protection CMS Entry to Tnsnames.ora

(Oracle CA Data Protection CMSs only)

An Oracle CA Data Protection CMS must use a 32-bit ODBC System DNS to connect to your BusinessObjects CMS. To allow the CA Data Protection CMS to connect using 32-bit Oracle client software, the tnsnames.ora file must include an entry for the CA Data Protection CMS database. You must also specify the location of tnsnames.ora in the registry.

To specify the location of Tnsnames.ora

1. On your BusinessObjects server, create a TNS_ADMIN registry value in the following registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient11g_home1
   

   Where 'KEY_OraClient11g_home1' is the registry key for your Oracle 32-bit client software installation.

2. Set the key data to be the full path to the \Network\Admin folder. For example:

   C:\app\ora11gclient\product\11.2.0\client_1\Network\Admin
   

   Where 'C:\app\ora11gclient\product\11.2.0\client_1' is the ORACLE_HOME folder for your Oracle 32-bit client software installation.

To edit Tnsnames.ora

1. Create and edit a tnsnames.ora file In the \Network\Admin folder.
2. Add an entry to tnsnames.ora that specifies the CA Data Protection database. For example:

   ORCLPL11 =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = DB_SRVR. unipraxis.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = ORCLPL11)
       )
     )