You can add it to the PC hosts file in \windows\system32\drivers\etc
Also you can modify the DNS suffix for network settings to default to that domain.
Waleed
-- --Original Message-- --
From: Schauss, Peter [mailto:peter.schauss@(protected)]
Sent: Wednesday, June 02, 2004 11:21 AM
To: Oracle-L (E-mail)
Subject: 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).
--- 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 (See ORA-12545.ora-code.com)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
