Home » RDBMS Server » Networking and Gateways » ora-12535 Timeout Errors
ora-12535 Timeout Errors [message #66608] Wed, 28 August 2002 04:13 Go to next message
ian
Messages: 27
Registered: September 1999
Junior Member
I am trying to connect to our 9i database via our WAN.
I can use ping and tnsping to ping the server without any problems.

Connecting with sql*plus will produce the 12535 errors, I have set the connect_timeout to 0 and to large values with the same problem.

The server is behind a firewall with ports 80 and 1521 opened.

Do we need to open any other ports?

Any help is appreciated!

-- Ian
Re: ora-12535 Timeout Errors [message #66609 is a reply to message #66608] Wed, 28 August 2002 04:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1.  If you are running MTS (Multi Threaded Server),then
    try the same connection with (SERVER=DEDICATED) in
    the tnsnames.
2.  your server is NT  then ensure that the port being
    listened on is open as well as setting up a 
    SQL*Net/Net8 Proxy, such as Net8 Connection
    Manager, if none is provided by the Firewall
    vendor. The reason is that, even though the port 
    is open, the TCP layer will REDIRECT the port to 
    another port.
3.  If any of above is not helping you,
    pls enable the client sqlnet and listener tracing
    for further diagnosis.

Re: ora-12535 Timeout Errors [message #66612 is a reply to message #66608] Thu, 29 August 2002 03:23 Go to previous message
ian
Messages: 27
Registered: September 1999
Junior Member
For anyone who may be interested or has the same problem in the future this is how I fixed the timeout problems.

I instructed the MTS to only use port 1521, the port that had been opened in the firewall to allow sql*net traffic through.

This is the line that I added to the init.ora.

mts_dispatchers="(address=(protocol=tcp)(host=localhost)(port=1521))(dispatchers=1)"
Previous Topic: Re: Urgent! Getting ORA-12203 Error
Next Topic: Re: Problem connecting Win2K (oracle 9i) client to 8.0.5 database
Goto Forum:
  


Current Time: Wed Feb 28 02:58:27 CST 2024