HI,

We have recently installed Oracle817 on VMS. When I try to connect to the database using sqlplus or oracle forms, I get 'ORA-12545:TNS:name lookup failure' error. Entries in tnsnames.ora and listener.ora are ok. ping and tnsping work fine. However, if I include an entry for this server with the IP address in the /etc/hosts file on the local client machine, it works fine. But there are no entries in this hosts file for other servers (we have 3 servers) which work fine. I would appreciate your help.

These are the listener.ora and tnsnames.ora file entries:

listener.ora
========
LISTENER=
(ADDRESS_LIST=
(ADDRESS=(COMMUNITY=TCP.WORLD)(PROTOCOL=tcp)(HOST= ... )(PORT=1526))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=NEWFLT)
(PROGRAM = ORACLE$DISK:[ORACLE8.ORACLE817.network.admin]orasrv_netv2_NEWFLT.com)
(prespawn_max=20)
(prespawn_list=
(prespawn_desc=
(protocol=tcp)
(pool_size=15)
(TIMEOUT = 5)
)
)
)
)

tnsnames.ora
=========
RF1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = ... )(PORT = 1526))
)
(CONNECT_DATA = (SID = NEWFLT))
)

==

Since the sql connection was slow, I have included prespawn settings in the listener.ora file.

SPN


NOTE: Edited out the IP address for security reasons.
Sam


[Edited by sambavan on 12-25-2001 at 09:37 PM]