Multi threaded server configuration puzzle

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Wed, 2 Jun 2004 08:20:51 -0700
Message-ID: <A17F427EF83B5D4881E6B304F8781C5E47549B@xcgny001.northgrum.com>

Oracle 8.1.7.4, AIX 5.2

I am trying to configure the multithreaded server. Connections work correctly from other AIX boxes, but from a PC based client I get:

TNS-12545: Connect failed because target host or object does not exist

If I add (SERVER=dedicated) to the the tnsnames.ora file on the client, I get a connection, but, of course, not the shared connection I was trying for.

The trace file is shown below ( I have changed some of the network information for security reasons).

The problem seems to be the lines:

nttbnd2addr: looking up IP addr for host: node2 nttbnd2addr: *** hostname lookup failure! ***

Note that several lines above this point, I got:

nttbnd2addr: looking up IP addr for host: node2.e.blrf.com

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

which seems to indicate sqlnet made the initial connection.

The node where the connection works has an ip addresses in the form <node>.e.blrf.com and thus presumably understands that node2 translates to node2.e.blrf.com. I verified that I can ping node2 from the node where the connection works. To ping that node from the PC where the connection does not work, I have to give the complete address (node2.e.blrf.com).

How do I fix this?

Thanks,
Peter Schauss

==================Begin trace file==============================================

TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is D:\Documents and Settings\schaupe\Desktop\cli.trc New trace level is 4
TRACE CONFIGURATION INFORMATION ENDS ---
PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source D:\oracle\ora81\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source D:\Documents and Settings\schaupe\Desktop\sqlnet.ora Parameter source was not loaded

-> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   trace_level_client = user
  NAMES.DIRECTORY_PATH = (TNSNAMES)
  SQLNET.AUTHENTICATION_SERVICES = (NTS)   NAMES.DEFAULT_DOMAIN = dssd.blrf.com
--- PARAMETER SOURCE INFORMATION ENDS ---

LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "D:\Documents and Settings\schaupe\Desktop\sqlnet.log" Log stream validation not requested
LOG CONFIGURATION INFORMATION ENDS ---

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 nncpmlf_make_local_addrfile: construction of local names file failed nncpmsf_make_sys_addrfile: system names file is D:\oracle\ora81\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=node2.e.blrf.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mdev1.node2.e.blrf.com)(SERVER=shared)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=DLNY1SCHAUPE1)(USER=schaupe))))
nscall: connecting...

nttbnd2addr: port resolved to 1521
nttbnd2addr: looking up IP addr for host: node2.e.blrf.com

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 684.
nttcon: set TCP_NODELAY on 684
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: sending 256 bytes connect data

nsdo: 256 bytes to NS buffer
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 33108
nttbnd2addr: looking up IP addr for host: node2
nttbnd2addr:  *** hostname lookup failure! ***
nserror: nsres: id=0, op=77, ns=12545, ns2=12560; nt[0]=515, nt[1]=1001, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12545
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 515

nioqper: nt (2) err code: 1001
nioqper: nt OS err code: 0
niqme: reporting NS-12545 error as ORA-12545 niomapnserror: returning error 12545

niotns: Couldn't connect, returning 12545
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jun 02 2004 - 10:17:22 CDT