Re: tnsnames.ora for connecting to replicated database.

From: Arviind Rajan <rajanarv_at_pilot.msu.edu>
Date: Wed, 16 Sep 1998 15:42:53 -0400
Message-ID: <360014BC.10CC7552@pilot.msu.edu>

I have had a problem with name resolution before on Oracle 8 on NT4. If it is not able to find the database instance by name, try using the IP directly. That might work.

Hope this helps.

Steve Hunt wrote:

> I am trying to setup TNSNAMES.ora so clients can connect to either instance
> of a replicated database. Can connect to either using differenct service
> names in TNSNAMES.ora, but to make it transparent I want to use a single
> service name.
>
> The documentation suggests the following format but, tnsping returns error
> TNS-3505: Failed to resolve name.
>
> repdb = (DESCRIPTION_LIST=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
> (Host = lion) (Port = 1521))
> (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
> (Host = lion) (Port = 1526))
> )
> )
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
> (Host = tiger) (Port = 1521))
> (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
> (Host = tiger) (Port = 1526))
> )
> )
> (CONNECT_DATA = (SID = ORCL)(GLOBAL_NAME=repdb.world))
> )
>
> Have tried with SQL*Net Client 2.3.2.1.6.A and 2.3.4.0.0 no luck. I have
> not changed any other configuration files - do I need to?
>
> thanks
Received on Wed Sep 16 1998 - 14:42:53 CDT