Home » RDBMS Server » Networking and Gateways » ORA-12535: TNS:operation timed out (oracle 12c - Windows server 2012)
ORA-12535: TNS:operation timed out [message #630286] Wed, 24 December 2014 02:27 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Need an advice.

The Error Log messages regarding "ORA-12535: TNS:operation timed out" related to the parameter "SQLNET.RECV_TIMEOUT", is getting written in ALERT LOG FILE.

Is it right? Why it is not writing in SQLNET.LOG file instead.

Do we need to change any parameter for it.

Regards
Muktha
Re: ORA-12535: TNS:operation timed out [message #630289 is a reply to message #630286] Wed, 24 December 2014 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If no one complains then it does not matter.

By the way, this is a FAQ.

Re: ORA-12535: TNS:operation timed out [message #630290 is a reply to message #630289] Wed, 24 December 2014 03:49 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Actually we need it. I felt this wasn't a Bug.
Felt something to be changed.

Thanks and Regards
Muktha
Re: ORA-12535: TNS:operation timed out [message #630294 is a reply to message #630290] Wed, 24 December 2014 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Actually you didn't search, you need it.

Re: ORA-12535: TNS:operation timed out [message #630307 is a reply to message #630294] Wed, 24 December 2014 05:18 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Not like that, I am searching simultaneously. Able to get the location of SQLNET.LOG file, after that only came to know it is not writing in that.

Regards
Muktha
Re: ORA-12535: TNS:operation timed out [message #630317 is a reply to message #630307] Wed, 24 December 2014 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just here, BlackSwan already answered this question at least 10 or 20 times.
And I will ask you one question she'd post (but in better English): "what did change since last time it worked?".

Re: ORA-12535: TNS:operation timed out [message #630328 is a reply to message #630286] Wed, 24 December 2014 08:18 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> "ORA-12535: TNS:operation timed out"

the most likely cause of timeout is a FireWall on or between client and DB.
Previous Topic: Oracle and SQLServer DB Link
Next Topic: Unable to connect to database through client
Goto Forum:
  


Current Time: Thu Mar 28 20:18:21 CDT 2024