Multi threaded server configuration puzzle
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Jun 2004 08:20:51 -0700
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
