TNS:name lookup failure

[SPN]

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]

[sambavan]

What is the service name of your instance. In the tnsnames.ora file, you might want to consider specifying the service_name instead of the SID_NAME. Can you make a client connection to the server using sqlplus

       sqlplus username/password@rf1.world

Regarding the hostname recognetion. consult with your system adminstrator(s) about the DNS looks up configureation and etc.

How did you come to a conclusion that the sqlnet is slow?

To make the regular connection try

     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) 
                        ) 
                  )
              ) 
 
              (SID_DESC= 
                 (GLOBAL_DBNAME = ... )
                 (ORACLE_HOME = ...)
                 (SID_NAME=NEWFLT)  
               )  
          ) 


tnsname.ora

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



   RF2.WORLD = 
    (DESCRIPTION = 
        (ADDRESS_LIST = 
           (ADDRESS = (PROTOCOL = TCP)(HOST = ... )(PORT = 1526)) 
         ) 
         (CONNECT_DATA = (SERVICE_NAME = NEWFLT)) 
     ) 

Also Could you post the sqlnet.ora file also.