Re: ORA-3136 Inbound Connection Time out

Thanks Tim for all your responses. In ASH report we could not find anything sequence related.
 
We do see some wait on CPU in AWR/ASH report  although there is not that much load during hanging time.
 
This issue started around 5-6 weeks back otherwise the system was fine for last 2 years.
 
Regards
Rafiq
 

---

Date: Wed, 23 Feb 2011 13:40:55 -0700
From: tim@xxxxxxxxx
To: rafiq9857@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-3136 Inbound Connection Time out

Don't discount sequences (or any other possible cause) so quickly until you review the ASH information during the 5-10 minutes leading up to the appearance of the error messages, and just follow the information you find.  It will likely lead you directly to the cause.

The case study in the presentation was somewhat convoluted -- I could never have diagnosed it with session-level information and the information in ASH, although far from perfect, is very useful.



On 2/23/2011 11:50 AM, 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@xxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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

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

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