RE: DataGuard Failover and Thin Clients

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <Thomas.LaPorte@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Jan 2010 14:23:50 -0500

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


Other related posts: