How can we configure the database connection in Workload Automation DE (dSeries) for failover in an Oracle RAC Cluster Environment?
The Workload Automation DE product 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 Workload Automation DE (dSeries) 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:
You can modify the database connection jdbc.URL parameter using setdbparm utility located in CAWA installation Utilities directory.