CA WA DE with Oracle RAC and failover

Document ID : KB000118706
Last Modified Date : 30/10/2018
Show Technical Document Details
Introduction:
The CA WA DE can be configured to work Oracle RAC and SCAN.  The JDBC URL can include all the nodes of a RAC or the single access point of SCAN.
 
Background:
The Oracle SCAN allows a single access point for clients to connect to the database.  When adding or changing nodes, the clients do not have to update the JDBC URL.
Environment:
CA WA DE 
OS: Any
DB: Oracle
Instructions:
If SCAN is available, then point the JDBC to that name.
jdbc.URL=jdbc:oracle:thin:@[db-SCAN.example.com]:1919/dedb
When a node failover takes place, all the sessions may not automatically move to the new node.  The Oracle RAC may move SELECT statement sessions, but any UPDATE sessions will have to be resubmitted.  During the move, the UPDATE session will result in an exception on DE side.  This will result in DE failover (HA) or shutdown.  DE will then have to restarted and it will continue where it left.

 
Additional Information:
http://www.dba-oracle.com/art_oramag_rac_taf.htm
https://community.oracle.com/thread/2585275