Hi,
Oracle 12c R1
I've got an application that functions best with Oracle RAC in an active-passive configuration because of the use of ordered sequences. What is the best configuration to setup that will allow as seamless a failover as possible if a failure occurs at the primary site while directing traffic to only one of the nodes?
1) Is it possible to just direct application traffic to the "active" node using the SCAN listener,
2) Do we need to go all the way to disable CLUSTER_DATABASE=false and how do we configure the SCAN listener then?
Thanks