Home » RDBMS Server » Networking and Gateways » ORA-12535: TNS:operation timed out (Oracle Rdbms, 11.1.0.7, Linux x86_64)
ORA-12535: TNS:operation timed out [message #442651] Tue, 09 February 2010 14:07
pndeshpande
Messages: 1
Registered: February 2010
Location: St.Louis
Junior Member
We have an OLTP db server with oracle 11g installed on Linux 64bit OS.

Client : Dotnet application running on win2003 server
oracle client version on webServer 9.2.0.4

Work load on system is

Avg Executions Per Sec 1273.35
Avg Executions Per Txn 42.1
Avg Response Time Per Txn (secs) .13
Avg User Transaction Per Sec 30.4

we are experiencing "ORA-12535: TNS:operation timed out" while users access the application from webserver.per day around 200 errors.

To get rid of the above error we set SQLNET.INBOUND_CONNECT_TIMEOUT=0 in server side sqlnet.ora and
in Listener.ora inbound_connect_timeout=120 but of no use.Only one listener is configured on server.

The similar set up with lesser workload working fine without any errors.

Please let me know your thoughts....
--Pandey
Previous Topic: Reading XML File from Mailbox
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Goto Forum:
  


Current Time: Thu Sep 18 17:29:30 CDT 2014

Total time taken to generate the page: 0.09978 seconds