Thanks Rachael
Getting some more feedback on this
"
What this appears to be is a cluster configuration with a middle ware
capability ( like Oracle FailSafe) to fail a database over from one node
to its backup. This would be the reason each IP is configured with two
ports.
"
That sounds reasonable.... Although my docs souw mulitple ADDRESS_LIST =
eg for parrallel or cluster server.
However if I performd the simple test below, as is it- fails, if I place
valid first, it connects. Which raised my concern of Oracle not going to
"the next address"
??
locdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = invalid)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = valid)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = locdb)
)
)
> 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).
>
--
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).
