Re: tnsnames.ora for connecting to replicated database.

From: Steve Hunt <rilsh_nospam_at_ibm.net>
Date: 17 Sep 1998 13:50:35 GMT
Message-ID: <01bde242$5fb41c00$f7c66420@ecnzrat2>

I think the SQL*Net client is supposed to randomly select one or the other if TNSNAMES.ora is setup with the DESCRIPTION_LIST key. If the TNSNAMES.ora is changed to that shown below then the client will connect to the first available instance. So if the first instance were available then all clients would connect to it rather than balancing the load on the other replicated instance.

repdb.world =
 (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
          (Host = tiger) (Port = 1521))
        (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP)
          (Host = lion) (Port = 1521))

    )
    (CONNECT_DATA = (SID = ORCL))
 )  

Winnie Liu <oracle_dba_at_zdnetmail.com> wrote in article <6tq6gf$bv6_at_sjx-ixn2.ix.netcom.com>...
> The name "repdb" actually point to two hosts? (lion and tiger?) how can
> oracle resolve that?
>
> Winnie
>
Received on Thu Sep 17 1998 - 08:50:35 CDT