RE: Multiple addreses in tns

Add FAILOVER=ON and it will check the next address if the previous one has failed. Alternatively, use SOURCE_ROUTE=ON and it will check every single one of them if the previous one fails.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]

-----Original Message-----
Sent: Thursday, July 10, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L

Is having multiple addresses valid for a tns entry?

A client provided this to me and initailly looked invalid

alias =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
    )
    (CONNECT_DATA = (SID = name)(SERVER = DEDICATED))   )

>From initial testing, if the first server is not avaliable the entire connect fails. Personally Ive never seen this and from checking my reference, this does NOT seem to be valid

Any input would be most welcome

Thanks!
bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).