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
|