it's valid.
if there is no response on the first port, Oracle tries the next etc
etc etc. It's a means of failover or allowing for continuity of
connections while doing maintenance on a listener or server
- Bob Metelsky <[EMAIL PROTECTED]> wrote:
> 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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
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).
Received on Thu Jul 10 2003 - 08:46:03 CDT