tnsnames.ora for connecting to replicated database.

From: Steve Hunt <rilsh_nospam_at_ibm.net>
Date: 16 Sep 1998 19:38:26 GMT
Message-ID: <01bde1a9$cdd3bbd0$dac66420@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 Wed Sep 16 1998 - 14:38:26 CDT