Re: ORA-3136 Inbound Connection Time out

It is hard to diagnose this without more information.  Is it one query or many 
queries this is happening to, check your trace files.  It this happening all 
the time or just at the busest times of the day - this could be a network issue.
 
Some things to check out.....
 
Is is just one query getting timed out?  Maybe it needs to be tuned, might be 
taking a bad query plan?
 
You might want to do a trace route to see if for some reason you are taking a 
bad hop along the network.
 
If the app has recently changed, maybe you are bringing more data to and from 
the database and you might need to a few queries.
 
Did you take on more clients and traffic increase?  Maybe you need to adjust a 
setting on your app server or connections.  
 
Check your wait events on your database see what your wait events are when you 
have this happen.  
 
Check your settings in your sqlnet.ora and your listener.ora, they may need to 
be adjusted.
 


--- On Wed, 2/23/11, Pawel Smolarz <pawel.smolarz@xxxxxxxxxx> wrote:


From: Pawel Smolarz <pawel.smolarz@xxxxxxxxxx>
Subject: Re: ORA-3136 Inbound Connection Time out
To: krish33moorthy@xxxxxxxxx
Cc: "oracle Freelists" <Oracle-L@xxxxxxxxxxxxx>
Date: Wednesday, February 23, 2011, 8:40 AM


Hi,

You can increase default value 60sec for SQLNET.INBOUND_CONNECT_TIMEOUT 

in sqlnet.ora file on server 
Regards,
Pawel







Dnia 2011-02-23, śro o godzinie 19:54 +0530, KRISHNA MOORTHY pisze: 
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



Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 
0000021828, 
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, 
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, 
o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, 
NIP: 586-000-78-20, REGON: 190024711



      

Other related posts: