Re: ORA-3136 Inbound Connection Time out

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 - 08:40:05 CST