Re: ORA-12535: TNS:operation timed out errors for over a year now...

On 8 Jul 2006 17:04:49 -0700, "Charles Hooper" <hooperc2000@xxxxxxxxx>
wrote:

* There is a VPN connection or some type of WAN link between the server
and the client. The VPN or WAN link connection go down temporarily,
and the client tries to connect to the database (or display a report).
After a 40 second delay, or whatever the timeout is, the client reports
ORA-12535: TNS:operation timed out.

* Something on the server is preventing the listener from responding.
It could be another database on the server is having a bad day -
listener tries to hand off a connection to the database that is having
a bad day, and never returns from the handoff. If this happens, you
will likely see many entries in the alert logs for the databases, and
possibly several trace files.


Sqlnet uses *two* ports, one to get in touch, one for the actual
communications.
The second port is determined *randomly*.
If that port isn't opened in the firewall (and why should it), you get
12535.
Listeners don't have a 'bad day'.

There are three workarounds
- set up connection manager on the database server
- set up mts on the database server to a fixed port
- set use_shared_sockets = true

--
Sybrand Bakker, Senior Oracle DBA
.

Relevant Pages

  • Re: Confusion about database updates
    ... all connecting to the same database server. ... >> The problem occurs when connection to the database server is lost. ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: ORA-12535: TNS:operation timed out errors for over a year now...
    ... 'attach database'. ... At a middle tier - a server sitting between the client and the Oracle ... There is a VPN connection or some type of WAN link between the server ...
    (comp.databases.oracle.server)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... The client runs a VP from Philly to NYC. ... Would you consider using an ADP talking across an fast broadbank link to ... local database, but ideally we would like to centralise. ... the front end over a VPN connection. ...
    (microsoft.public.access.adp.sqlserver)
  • Help ! -> Distributed BL and Database Access
    ... I have one server located in a remote part of the country ... method the data within the object will be comitted to the database. ... reference to the database connection and then send it to the client (by ... value - to move the work off onto the client). ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... MS just came out with a patch for ADP a few months ago ... I'm using a fairly complex database using and ADP ... the front end over a VPN connection. ... The client will either have an ADSL or SDSL broadband connection to ...
    (microsoft.public.access.adp.sqlserver)