Re: ORA-3136 Inbound Connection Time out

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 23 Feb 2011 09:17:07 -0700

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

Other related posts: