Re: Slow tnsping!

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 7 Aug 2002 07:38:59 +0200
Message-ID: <aiqbpk$e0v$1@ctb-nnrp2.saix.net>

"Fred" <res0jhe3_at_verizon.cm> wrote

> I need some direction regarding slow database response or actually no
> response. On one of our servers we have test and development environments.
I
> get interrmittent/long tnsping rates. However, the OS ping command works
> fine. Could anyone help with some direction here for troubleshooting?
> Basically how to begin troubleshooting these tns issues...

There are no TNS issues. Unless you made some for yourself. :-)

I have seen tnspings taking forever as the TNSNAMES.ORA file is configured with hostnames. OraNet needs to use DNS to resolve hostname to IP, whereas the clever sysadmin is using the actual IP address when testing connectivity via the o/s ping command. Thus tnsping seems to be a problem and not ping.

--
Billy

Received on Wed Aug 07 2002 - 00:38:59 CDT