Configuring an Oracle RAC database server

For BMC 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))))"
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.