RE: Multiple addreses in tns

Wolfgang Breitling Thu, 10 Jul 2003 08:36:55 -0700

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

RE: Multiple addreses in tns

Reply via email to