RE: DataGuard Failover and Thin Clients

        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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas A. La Porte Sent: Thursday, January 14, 2010 2:16 PM To: oracle-l_at_freelists.org
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_at_anim.dreamworks.com>

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_at_slac.stanford.edu--
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l