RE: ORA-3136 Inbound Connection Time out

Thanks Mike.  

I also see some recommendation in ADDM report to increase SGA. Right now our SGA size of 20G.  

However I also see on internet to avoid use of SGA Target and/or Auto memory management for having such situations.  

Regards
Rafiq  

Subject: Re: ORA-3136 Inbound Connection Time out From: MBoligan_at_quattrowireless.com
Date: Wed, 23 Feb 2011 15:37:10 -0500
CC: oracle-l_at_freelists.org
To: rafiq9857_at_hotmail.com

I saw something similar to this using 10.2.0.4 and AMM in a RAC setting. I was getting these periodically, and noticed that our ETL process was running slow. I traced our ETL process and determined I needed to increase the SGA, as we had new processes running on the database (I was not thinking this was related at all). After increasing the sga, I have not seen the problem again. I am not certain this is what stopped the inbound connection timeout messages, but nothing else changed on the system. If this is what solved the issue. It may be worth looking at the SGA sizing tables in AWR.

Mike

On Feb 23, 2011, at 1:50 PM, Mohammad Rafiq wrote:

Tim,  

Quite good presentation and problem analysis.  

We are going through similar issue on node2 but it is not sequence related. Database version 10.2.0.4 on Suse10.  

sqlplus / as sysdba session also hangs during that duration between 5-15 minutes. It normally happens during nightly data load when node1 is quite busy. We don't see that much load on node2. We were suspecting auto stats job which we disabled but no success. It happens some nights with different timing in the night.  

We have opened an SR and provided system dump (using sqlplus -prelim) and strace files generated during hanging time. Now waiting for their analysis.  

Regards
Rafiq        

Date: Wed, 23 Feb 2011 09:17:07 -0700
From: tim_at_evdbt.com
To: oracle-l_at_freelists.org
Subject: Re: ORA-3136 Inbound Connection Time out

I just did a presentation at RMOUG on the topic of ORA-3135/3136. Please let me know if it helps...

On 2/23/2011 7:24 AM, KRISHNA MOORTHY wrote: Hi

We are getting frequently the following error in alert log files of production server.It was running fine for last 3 months.There is no changes in listener configuration.

WARNING: inbound connection timed out (ORA-3136)

In Sqlnet.log file the following error is getting displayed.

TNS-12535: TNS:operation timed out

   nt main err code: 0
   nt secondary err code: 0
   nt secondary err code: 0
   nt OS err code: 0
   nt OS err code: 0
   ns secondary err code: 12606
   nt main err code: 0
   nt secondary err code: 0
   nt OS err code: 0
   TNS-12535: TNS:operation timed out
   ns secondary err code: 12606
   nt main err code: 0
   nt secondary err code: 0
   nt OS err code: 0
   TNS-12535: TNS:operation timed out
   ns secondary err code: 12606
   nt main err code: 0
   nt secondary err code: 0
   nt OS err code: 0

When i searched on the net,they are telling that it might be an network issue.But when i asked the network team , they said there is no firewall /port block issues.Please help me to resolve the issues.

Regards
Krishna
9585354917-- http://www.freelists.org/webpage/oracle-l                                                

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