Re: ORA-12535: TNS:operation timed out
Date: 2000/07/22
Message-ID: <_2we5.2683$2t3.516521_at_news.uswest.net>#1/1
I don't remember if this is the same as the problem I had before. I checked Metalink, and here's something that fixed me: http://support.oracle.com/metalink/plsql/ml2_documents.showDocument?p_databa se_id=FOR&p_id=92442.998
Otherwise, here's a snip of the important stuff:
<-----------------------snip------------------------------------------------------------>
From: Oracle, Rhoderick Butial 28-Jan-00 14:46 Subject: Re : New install connects via loopback but not from other clients
Hello,
Error: ORA-12535 / TNS-12535
Text: TNS:operation timed out
Cause: The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in listener.ora. This error arises from the tnslsnr. Action: Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if the timeout is unacceptably long, turn on tracing for further information.
Error: ORA-12203 / TNS-12203
Text: TNS:unable to connect to destination
Cause: Invalid TNS address supplied or destination is not listening. Action: Ensure that the listener is running at the remote node, or ensure that the ADDRESS parameters specified are correct.
Thank you,
Rod
Oracle Technical Support
<---------- end
snip --------------------------------------------------------------------->
HTH,
Verna
"Jeff" <jdcc_at_worldnet.att.net> wrote in message
news:397A7179.1007DB14_at_worldnet.att.net...
> 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
>
Received on Sat Jul 22 2000 - 00:00:00 CEST