Re: tnsnames.ora file

From: Daniel <nospam_at_nospam.com>
Date: Thu, 12 Nov 1998 11:17:31 -0000
Message-ID: <72ef7d$d13$1@inet16.us.oracle.com>

Hi Doug,

And now for the rest...

(DESCRIPTION =
This defines a single description and is used within the (DESCRIPTION_LIST =
entry. Sqlnet will then randomise which description is used. This could be used when you want to load balance across multiple listeners or multiple nodes.

(ADDRESS =
This defines a single address and is used within the (ADDRESS_LIST =
entry. Sqlnet will try to connect to the first address within the address list and if this fails will then try the next address and so on. This could be used if you have multiple ports the listener is listening on or indeed for multiple protocols, ie; try tcp/ip first and then spx.

Example;

orcl.world =
(DESCRIPTION_LIST=
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (HOST = HOST1)


          (PORT = 1521)


        )
        (ADDRESS =


          (COMMUNITY = spx.world)


          (PROTOCOL = SPX)


          (SERVICE = HOST1_LSNR)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (HOST = HOST1)


          (PORT = 1526)


        )
        (ADDRESS =


          (COMMUNITY = spx.world)


          (PROTOCOL = SPX)


          (SERVICE = HOST1_LSNR)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
)

Hope this helps.

Regards,

Daniel... Received on Thu Nov 12 1998 - 05:17:31 CST