tnsping takes long time on 9i instance

Hello Gurus,

I found tnsping takes aroung 360ms on W2K,9i
where as the same db instance shows 60ms on NT,Oracle7.x
Because of this sqlplus is very slow on my Win2k box
Any pointers?

Do a normal ping and if it also takes that long then its an issue with your network. Make sure its running on FULL and not HALF-DUPLEX

-Sam

using ping i will get the response with in 10ms

Can you please give us the following informations:

Code:

---


    1. What is the Oracle Server Version & OS version
 
    2. What is the client version and the OS

    3. Your tnsnames.ora file after masking your host name/ip address information

    4. Your listener.ora file with the same condition as above

    5. Your sqlnet.ora file

    6. Also please list the Protocols used on your client & the server

---

Sam

Hi,

I am using Oracle 9.2 database. I have created three instances manually using scripts.
Here is my configs.(mentioning only for one instance)

1. Listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX)(PORT = 1521))
)
)
)

2. tnsnames.ora
ACC=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ACC)
)
)
3. sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

Firt time tnsping takes >800ms
second time onwards this takes 80-100ms, why??

Are you identifying the host by ip address or by name? If the latter, then it's possible that the delay is caused by the DNS being slow to resolve the name.

Am using IP address not the name

Do you have more NICs on this box? Or any virtual ones, like vmware?

Ya, I have 4 NIC's in my box. But this same configuration is available in my NT,Oracle 7.x box but here connections are very fast?

Try temporary disabling other 3 NICs to check if that's the problem.

Did disabled otther NIC's but it couldn't help me. Another interesting thing I noticed here is that eventhough tnsping takes > 800ms at first time then the subsequent tnsping takes only <100 ms, Why??