Configuring an Oracle RAC database server

For TrueSight Server Automation to work in conjunction with an Oracle Real Application Cluster (RAC) database server, the Application Server must be configured to communicate with the database. The installation program can configure the Application Server. However, you can manually configure the Application Server to communicate with the database, as described in this procedure.

1. Start the Application Server Administration console, as described in Starting-the-Application-Server-Administration-console.
2. Specify a connection string for the RAC database. Use the following format:
   set database connectionstring "jdbc:oracle:thin:@(DESCRIPTION = <descriptors> )"
   The connection string must include:
   • An ADDRESS descriptor for each computer in the Oracle RAC cluster. Each ADDRESS descriptor must contain a HOST descriptor that specifies the full name of the computer.

   • A SERVICE_NAME descriptor that specifies the alias used for connecting to the database. (The Oracle database administrator can provide this information.)
      For example:

     set database connectionstring "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraracdb1-vip.ora1.bmc.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oraracdb2-vip.ora1.bmc.com)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraracserv) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 1000))))"

     If you have Single Client Access Name (SCAN) set up on Oracle 11g R2 or later, you can provide only the RAC cluster alias instead of listing the individual nodes, as shown in the following example:

     set database connectionstring "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racdb-vip.ora1.bmc.com)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraracserv) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 1000))))"

     racdb-vip.oral.bmc.com specifies the name of the cluster alias.

3. To specify the user ID and password for the database, enter the following two commands:
   set database userid <id> set database password ******
    where <id> is the user name that the database requires to authenticate your connection and ******** is the password assigned to that user ID.
4. To specify the driver class for the database, enter the following:
   set database driverclass oracle.jdbc.driver.OracleDriver
5. Restart the Application Server.