JDBC connector string for Oracle RAC Cluster.

Document ID : KB000052211
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How to configure the database connection in CA (dSeries) Workload Automation for failover in an Oracle RAC Cluster Environment?

Solution:

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:

jdbc:oracle:thin:@(DESCRIPTION=(load_balance=on)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST= node1-name)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= node2-name)(PORT=1521)))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME= service-name)))
     
where;
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.