Where does my client get the idea that it is supposed to be talking to node2 instead of node2.e.blrf.com? Peter Schauss -----Original Message----- From: Khedr, Waleed [mailto:Waleed.Khedr@xxxxxxx] Sent: Wednesday, June 02, 2004 12:10 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Multi threaded server configuration puzzle 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@xxxxxxx] 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). 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------