RE: Multiple addreses in tns

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 10 Jul 2003 07:09:40 -0700
Message-ID: <F001.005C441F.20030710065429@fatcity.com>

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).

Received on Thu Jul 10 2003 - 09:09:40 CDT