Tom, Just read that page and I think you might be confusing the jdbc thin client with the Oracle thin client. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas A. La Porte Sent: Thursday, January 14, 2010 2:16 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: DataGuard Failover and Thin Clients Ian, What version of the thin client are you using? I just discovered recently that the thin client supports using TNSNames aliases as of 10.2.x. http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.htm#BE ICDECB I haven't had our developers make any changes to utilize this yet, but it looks like it would be an option for you that would eliminate some added complexities. -- Tom Thomas A. La Porte, DreamWorks Animation <mailto:tlaporte@xxxxxxxxxxxxxxxxxxx> On Thu, 14 Jan 2010, MacGregor, Ian A. wrote: > 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@xxxxxxxxxxxxxxxxxxx > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l