Re: ORA-3136 Inbound Connection Time out

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 23 Feb 2011 09:17:07 -0700
Message-ID: <4D653303.1000309_at_evdbt.com>

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 Received on Wed Feb 23 2011 - 10:17:07 CST