Re: TNSPing Timeout Expired Error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 Nov 2005 07:12:23 +0100
Message-ID: <9fd8n1hss90nb06db7m3nfihc0hfmu957j@4ax.com>

On 10 Nov 2005 17:41:01 -0800, graigcrawford_at_yahoo.com wrote:

>I am attempting to connect to a remote Oracle database using the 9i
>client. I can successfully ping the server on which the database
>resides but TNSPING produces a tijmeout expired error. The TNSNAMES
>file contains the correct entries and I can connect to the database
>using the exact same client configuration from another office - which
>is on a completely different LAN. Does anyone have some
>troubleshooting advice? Could it be the firewall blocking port 1522?
>Anything else we should try? Any advice would be appreciated.

'a timeout expired error' is deliberately vague. Don't assume anyone is looking over your shoulder and can guess the exact error. If you get 12535 during an ordinary sqlplus connection attempt: now that is firewall.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Nov 11 2005 - 00:12:23 CST