Re: ORA-12535: TNS:operation timed out???

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: 2000/07/25
Message-ID: <397DA181.9FE294F0@lucent.com>#1/1

Jeff wrote:
>
> I'm trying to connect to an instance over the internet with SQL*Plus and
> receive ORA-12535: TNS:operation timed out. I can connect w/SQL*Plus
> from within my company but not from home. The network administrator has
> opened a hole in the firewall and I can ping the db server w/o problem.
>
> I am using the standard port 1521. Someone suggested that oracle
> listens on one port and perhaps responds back to the client using
> another port. Is there a setting in TNSNAMES.ORA to force the db server
> to respond to the client back on port 1521?
>
> Any suggestions greatly appreciated.
>
> Jeff

What is your TTL setting? It sounds like you might be timing out because your TTL is set too small. It should be at least 128 when you are working over the internet. Received on Tue Jul 25 2000 - 00:00:00 CDT