I have a scenario where I need to configure two oracle 11g DB instances in SiteMinder policy servers as failover DB instances. These DB instances are configured in RAC mode and primary having write access and secondary in read mode.
I know below are two ways with which these two DB instances can be configured as failover instances at SiteMinder end:
1.By creating 2 DSN and use the Policy Server AdminUI to configure the Failover https://support.ca.com/cadocs/0/CA%20SiteMinder%2012%2052%20SP1-ENU/Bookshelf_Files/HTML/idocs/346795.html
2. User the ODBC Driver FailOver capabilities to manage failover and especially the alternate servers option.
Both options are valid, the first one is the one that is managed by the policy server and the second by the DataDirect/Progress driver that we ship with the product.
Can you help me in understanding which option is more feasible and should be followed for configurations and why?