ora-12535 Timeout Errors [message #66608] |
Wed, 28 August 2002 04:13 |
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 #66612 is a reply to message #66608] |
Thu, 29 August 2002 03:23 |
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)"
|
|
|