RE: DataGuard Failover and Thin Clients

      For example, if you want to connect to the database on host
      myhost as user scott with password tiger that has a TNSNAMES
      entry of MyHostString, then write the following:

      OracleDataSource ods = new OracleDataSource();
      ods.setTNSEntryName("MyTNSAlias");
      ods.setUser("scott");
      ods.setPassword("tiger");
      ods.setDriverType("oci");
      Connection conn = ods.getConnection();


      The oracle.net.tns_admin system property must be set to the
      location of the tnsnames.ora file so that the JDBC Thin driver
      can locate the tnsnames.ora file. For example:

      System.setProperty("oracle.net.tns_admin", "c:\\Temp");
      String url = "jdbc:oracle:thin:_at_tns_entry";

On Thu, 14 Jan 2010, Job Miller wrote:

>
> jdbc clients can use a JDBC url that looks just like the
>definition used in a tnsnames alias definition.
>
> However, a thin JDBC client doesn't use the "alias", it uses the full string:
>
> jdbc:oracle:thin:_at_(DESCRIPTION=
> (LOAD_BALANCE=on)
> (ADDRESS_LIST=
> (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
> (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))
> (CONNECT_DATA=(SERVICE_NAME=service_name)))
>
>
> --- On Thu, 1/14/10, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
>
>> From: Goulet, Richard <Richard.Goulet_at_parexel.com>
>> Subject: RE: DataGuard Failover and Thin Clients
>> To: Thomas.LaPorte_at_dreamworks.com, oracle-l_at_freelists.org
>> Date: Thursday, January 14, 2010, 2:23 PM
>> 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_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
>>
>>
>>
>

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