OraFAQ Forum: Networking and Gateways » ORA-12535: TNS:operation timed out

Home » RDBMS Server » Networking and Gateways » ORA-12535: TNS:operation timed out (oracle 12c - Windows server 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12535: TNS:operation timed out [message #630286]

Wed, 24 December 2014 02:27

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

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630289 is a reply to message #630286]

Wed, 24 December 2014 03:29

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If no one complains then it does not matter.

By the way, this is a FAQ.

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630290 is a reply to message #630289]

Wed, 24 December 2014 03:49

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

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630294 is a reply to message #630290]

Wed, 24 December 2014 04:25

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Actually you didn't search, you need it.

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630307 is a reply to message #630294]

Wed, 24 December 2014 05:18

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

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630317 is a reply to message #630307]

Wed, 24 December 2014 06:56

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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?".

Report message to a moderator

Re: ORA-12535: TNS:operation timed out [message #630328 is a reply to message #630286]

Wed, 24 December 2014 08:18

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.

Report message to a moderator

Previous Topic:	Oracle and SQLServer DB Link
Next Topic:	Unable to connect to database through client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 23:06:51 CST 2025