C.5 Configuring the Connection for Crystal Enterprise Server

For Crystal Enterprise Server to use the Oracle RAC database, you must edit the tnsnames.ora file.

NOTE:The steps in the standard installation for Crystal Enterprise Server must be followed before performing this step. For more information on installing Crystal Enterprise Server, see Section 8.0, Crystal Reports for Linux.

To edit the tnsnames.ora file:

  1. Log in to the server with Crystal Enterprise Server installed and locate the tnsnames.ora file.

  2. Modify the ESECURITYDB service to show the TNS information for all of the nodes. The IP address must be the virtual IP address.

    A sample file for a system with three nodes is shown below:

    ESECURITYDB =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.3)(PORT = 1521))
   (LOAD_BALANCE = yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = REPORT.novell.com)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
)