Home -> Usenet -> comp.databases.oracle -> Re: ORA-12545 - *****Hostname Lookup Failed*** with Oracle 9i from SQL*Plus Worksheet only - previous fixes tried

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

From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 11 Oct 2001 21:32:00 +0200
Message-ID: <3BC5F3B0.D2EAFAD8_at_home.nl> 







<BIG snip!>


This is the crux:


nttbnd2addr: looking up IP addr for host: train01
nttbnd2addr:  *** hostname lookup failure! ***



train01 is not known - why not use localhost?
or IPC - it outperforms TCP many times!


or BEQ...



Here's my 9i tnsnames entry for the local machine:
FBO.CS.NL =



  (DESCRIPTION =



    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 =


oracleFBO)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))


    (ADDRESS = (PROTOCOL = IPC)(KEY = FBO))


    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


    (CONNECT_DATA = (SID = FBO))





  )


-- 
Gtrz,

Frank van Bortel


Received on Thu Oct 11 2001 - 21:32:00 CEST












Original text of this message