RE: Multiple addreses in tns

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 10 Jul 2003 08:36:55 -0700
Message-ID: <F001.005C443E.20030710082925@fatcity.com>

Works for me. I just did a the test on Oracle 8.1.7. Here is the trace file. Note the "nsopen: unable to open transport" after trying to find host fleming. Then it goes on to try host altair which succeeds. One thing though. The host must not exist or be unreachable. If the host is reachable but the listener for the requested port is down then the connection fails without trying a second address with a different port. You can not fail over to a different port on the same server.

nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbni: Unable to get data from navigation file tnsnav.ora nnftmlf_make_local_addrfile: construction of local names file failed nnftmlf_make_system_addrfile: system names file is c:\oracle\network\admin\tnsnames.ora

niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=fleming)(Port=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=altair)(PORT=1526))(ADDRESS=(PROTOCOL=NMP)(SERVER=altair)(PIPE=ORAPIPE)))(SDU=16384)(TDU=16384)(CONNECT_DATA=(SID=stats)(CID=(PROGRAM=C:\ora81\bin\SQLPLUSW.EXE)(HOST=ALTAIR)(USER=Administrator)))) nscall: connecting...
nttbnd2addr: port resolved to 1526
nttbnd2addr: looking up IP addr for host: fleming

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 352.

ntt2err: soc 352 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nttbnd2addr: port resolved to 1526
nttbnd2addr: looking up IP addr for host: altair

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 356.
nttcon: set TCP_NODELAY on 356
nsopen: transport is open

nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61 nsopen: global context check-in (to slot 0) complete

nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRD packet

nscall: redirected
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete nscall: connecting...
nttbnd2addr: port resolved to 1151
nttbnd2addr: using host IP address: 172.20.230.237

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 364.
nttcon: set TCP_NODELAY on 364
nsopen: transport is open

nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61 nsopen: global context check-in (to slot 0) complete

nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTAC packet
nscon: doing connect handshake...

At 06:54 AM 7/10/2003 -0800, you wrote:
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)
    )
  )
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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 - 10:36:55 CDT