Re: tnsnames.ora for connecting to replicated database.

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Wed, 16 Sep 1998 22:30:17 -0700
Message-ID: <6tq6gf$bv6@sjx-ixn2.ix.netcom.com>

The name "repdb" actually point to two hosts? (lion and tiger?) how can oracle resolve that?

Winnie

Steve Hunt wrote in message <01bde1a9$cdd3bbd0$dac66420_at_ecnzrat2>...
>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 Thu Sep 17 1998 - 00:30:17 CDT