RE: ORA-3136 Inbound Connection Time out
- From: Mohammad Rafiq <rafiq9857@xxxxxxxxxxx>
- To: Tim Gorman <tim@xxxxxxxxx>
- Date: Wed, 23 Feb 2011 16:10:15 -0500
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
Other related posts:
