RE: inbound connection timed out (ORA-3136) RAC

Regardless of RAC or no RAC this error is quite common in 10gr2 databases 
specially if it is remote database server. I have also seen this behavior on 
Linux server when server is quite busy for various reasons. 
SQLNET.INBOUND_CONNECT_TIMEOUT  settings is now 10 seconds by default instead 
of 60 seconds in previous versions (if I remember correctly).

 

Regards

Rafiq

 

 


Date: Fri, 4 Jun 2010 14:54:55 -0700
From: kjped1313@xxxxxxxxx
Subject: Re: inbound connection timed out (ORA-3136) RAC
To: lawrence.wolfson@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx






I would never be one to point fingers-  I'm a DBA and do not understand the 
network infrastructure as well as the Network admin, but as a DBA, I do have to 
deal with the errors and the database is always guilty until proven innocent.  
We will and do get these errors unless I put in the following parameters into 
my sqlnet.ora file:
SQLNET.EXPIRE_TIME =10
INBOUND_CONNECT_TIMEOUT_LISTENER=0
SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300

Cycle the listener and these errors disappear.  Now-do I think there is most 
likely something amiss that I require this in my sqlnet file?  Yes, most 
definitely..  Do I have the time or skills to figure it out?  Very 
questionable... :)
 
Kellyn Pedersen

Sr. Database Administrator

I-Behavior Inc.

http://www.linkedin.com/in/kellynpedersen

www.dbakevlar.blogspot.com

 

"Go away before I replace you with a very small and efficient shell script..."







From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
To: oracle list <oracle-l@xxxxxxxxxxxxx>
Sent: Fri, June 4, 2010 1:50:33 PM
Subject: inbound connection timed out (ORA-3136) RAC

WARNING: inbound connection timed out (ORA-3136)

We set the INBOUND CONNECTION TIMEOUT=0 in RAC AIX environments, but
still get these messages.
Oracle 10.2 & 11.1

Anyone know why this would be happening?

  TIA
  Larry

***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************

--
http://www.freelists.org/webpage/oracle-l



                                          
_________________________________________________________________
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2

Other related posts: