You might also review the information in these whitepapers--I found them to be very helpful in a similar situation to yours:
http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_FastStartFailoverBestPractices.pdf http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdfThere are a lot of similar papers at http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm
Dan Yechiel Adar wrote:
Hello Steve You can achieve this using two address lists. my-database = (address_list = rac with failover and load balancing) (address_list= DG)Sql net will try the first address list and if it can not connect to any of the addresses it will use the second address list.See oracle net services reference 10.2, chapter 6. Adar Yechiel Rechovot, Israel steve montgomerie wrote:Good morning,I'm guessing / hoping it's possible to configure tnsnames to connect to the VIP's on the cluster with a failover entry for the standby sites. Does anyone have a working example of how this might be done? I have failover working on the cluster fine it's just the DG part that is throwing me for a loop. Ideally I'd like to switchover to the standby with no changes to the application server tnsnames files.
-- //www.freelists.org/webpage/oracle-l