DataGuard Failover and Thin Clients

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Thu, 14 Jan 2010 10:11:42 -0800
Message-ID: <8E96E32C-CC6E-4454-8C17-2E2E914046EB_at_slac.stanford.edu>

For thick clients the tnsnames.ora file includes two or more hosts for a given service_name, I believe clients treat this as an ordered list and try each one until a connection is established. Thin clients do not use tnsnames. One suggestion is to use LDAP.but I'm not sure how universal that is nor exactly how to set it up.

Another thought is to have the machines switch names and ip addresses right after a switchover. These machines have four NIC's each. Oracle would be a service on one of them. This type of thing is often done via clusterware. Can Oracle's clusterware do this? This is not a RAC environment, but a physical standby one.

I realize there are going to be consequences of doing this, any which are unsurmountable. I'm not in favor of this. It seems over-engineered, but that may be due to ignorance.

Ian MacGregor
SLAC National Accelerator Laboratory
ian_at_slac.stanford.edu--
http://www.freelists.org/webpage/oracle-l Received on Thu Jan 14 2010 - 12:11:42 CST