Search This Blog

Friday, July 17, 2009

ORA-3136 WARNING : Inbound Connection Timed Out in alert log


In our one of the production database is saw the following error

ORA-3136 WARNING : Inbound Connection Timed Out in alert log

Solution:
SQLNET.INBOUND_CONNECT_TIMEOUT=60

Add the above line in the SQLNET.ORA in SERVER.

INBOUND_CONNECT_TIMEOUT_LISTENER = 110
Add the above line in the LISTENER.ORA in SERVER.


Reference metalink note: 793259.1 & 465043.1

2 comments:

Anonymous said...

Nice blog you got here. It would be great to read something more concerning that topic. The only thing it would also be great to see on this blog is a few photos of some devices.
Alex Watcerson
Block phone

Muhammad Abdul Halim said...

Salam, Brother Taj
we also finding this message in out
Production Database.
Our Database version is- 10.2.0.4

Someone of my Friends says that this
message is show for

Cause: ORA-3135/ORA-3136 error occurred due to insufficient shared
pool size.

Solution: Increase shared pool size.

is it right ?

and if I implement your solution is there any other problem in our prod Database ?


Regards
Muhammad Abdul Halim