Multi threaded server configuration puzzle

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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: