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

Add a CA DLP CMS Entry to Tnsnames.ora

(Oracle CA DLP CMSs only)

An Oracle CA DLP CMS must use a 32-bit ODBC System DNS to connect to your BusinessObjects CMS. To allow the CA DLP CMS to connect using 32-bit Oracle client software, the tnsnames.ora file must include an entry for the CA DLP 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 DLP database. For example:

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