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.
set database connectionstring "jdbc:oracle:thin:@(DESCRIPTION = <descriptors>
ADDRESSdescriptor for each computer in the Oracle RAC cluster. Each
ADDRESSdescriptor must contain a
HOSTdescriptor that specifies the full name of the computer.
SERVICE_NAME descriptor that specifies the alias used for connecting to the database. (The Oracle database administrator can provide this information.)
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:
racdb-vip.oral.bmc.com specifies the name of the cluster alias.
set database userid <id> set database password ******
<id>is the user name that the database requires to authenticate your connection and ******** is the password assigned to that user ID.
set database driverclass oracle.jdbc.driver.OracleDriver