ORA-12545 - *****Hostname Lookup Failed*** with Oracle 9i from SQL*Plus Worksheet only - previous fixes tried

From: ben <ben_at_walkwithgiants.co.uk>
Date: 2 Oct 2001 08:44:39 -0700
Message-ID: <7cd5e0dc.0110020744.2c3dd1ba_at_posting.google.com>

All

I have recently installed Oracle 9i on W2000. Carried out all the standard setup and everthing is working except that I cannot connect using SQL*Plus Worksheet on the install machine. I can connect to this new install using OCI/ODBC and SQLPlus from same machine, and I can also connect using SQL*Plus Worksheet from client machines (from exisiting 8i client installs)

When tracing SQLNet get trace as outlined at end of post and message in SQL*Plus of "ORA-12545: Connect failed because target host or object does not exist"

sqlnet.ora and tsnames.ora are correct and I have checked network WINS/DNS settings and can resolve machine name using ping both as name and IP

Any advice on how to resolve this or similar issues welcome, have reviewed previous similar posts on this error/subject however have not been able to resolve with any fixes suggested

Thanks

Ben Heavey

NET Trace:

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is C:\oracle\NetTrace\oranettrace.txt.trc New trace level is 4
• TRACE CONFIGURATION INFORMATION ENDS ---
• PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source C:\oracle\ora90\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source C:\oracle\ora90\bin\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-

  TRACE_DIRECTORY_SERVER = C:\oracle\NetTrace
  TRACE_DIRECTORY_CLIENT = C:\oracle\NetTrace
  TRACE_LEVEL_CLIENT = USER
  TRACE_FILE_SERVER = OraServerTrace.txt

  SQLNET.AUTHENTICATION_SERVICES = (NTS)   TRACE_FILE_CLIENT = OraNetTrace.txt
  TRACE_LEVEL_SERVER = USER
--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "C:\oracle\ora90\bin\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

niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=train01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=train9i.ncorp)(CID=(PROGRAM=C:\oracle\ora90\bin\sqlplus.exe)(HOST=TRAIN01)(USER=heavey)))) nscall: connecting...
nttgetport: port resolved to 1521
nttbnd2addr: looking up IP addr for host: train01 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

Received on Tue Oct 02 2001 - 17:44:39 CEST