TNS:name lookup failure

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]

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

Code:

---


      sqlplus username/[email protected]

---

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

Code:

---


    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.