Re: ORA-3136 Inbound Connection Time out
Date: Wed, 23 Feb 2011 07:16:44 -0800 (PST)
Message-ID: <72740.61695.qm_at_web38201.mail.mud.yahoo.com>
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_at_nordea.com> wrote:
From: Pawel Smolarz <pawel.smolarz_at_nordea.com>
Subject: Re: ORA-3136 Inbound Connection Time out
To: krish33moorthy_at_gmail.com
Cc: "oracle Freelists" <Oracle-L_at_freelists.org>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 23 2011 - 09:16:44 CST