How to configure the database connection in CA (dSeries) Workload Automation for failover in an Oracle RAC Cluster Environment?
CAWA R11.1 can be configured to work with Oracle RAC, but RAC failover feature is not supported. If a database failover to another node in an Oracle RAC database configuration, the CA (dSeries) Workload Automation Server is forced to shut down. The Server has to be manually re-started to established connection to the new Oracle RAC database instance. To configure CA (dSeries) Workload Automation database for failover in an Oracle RAC cluster environment, the required JDBC connection string is given below:
For example, in a 2 node Oracle RAC database instances:
(HOST= node1-name)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= node2-name)(PORT=1521)))
node1-name is the Node name of node1
node2-name is the Node name of node2
service-name is the Service name of the database
You can modify the database connection jdbc.URL parameter using setdbparm utility located in CAWA installation Utilities directory.