SQL*NET time out and (ORA-3136)!!
510293Aug 6 2007 — edited Sep 12 2007Hi, all.
I have got the following message in the alert log file.
Our database is a 2-node RAC database on windows 2003 Enterprise Edition SP1.
Database version is 10.2.0.2.0.
There is no configuration of SQLNET.INBOUND_CONNECT_TIMEOUT
in sqlnet.ora.
------------------------------------------------------------------------------------------------------------
--> from alert.log
Mon Aug 06 08:43:32 2007
WARNING: inbound connection timed out (ORA-3136)
------------------------------------------------------------------------------------------------------------
--> from sqlnet.log
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Time: 06-8月 -2007 08:43:32
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: 操作はタイム・アウトしました。
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.115)(PORT=1242))
------------------------------------------------------------------------------------------------------------
I have about 10 ORA-3136 warinings in alert log file.
The above sqlnet.log is one of the corresponding sqlnet.log
As you see belows, the port number is changing.
For client connection, however, we are using default port number , 1521.
--------------------------------------------------------------------------------------------------------
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.115)(PORT=1242))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.115)(PORT=3371))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.115)(PORT=3377))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.115)(PORT=3380))
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.110)(PORT=4733))
--------------------------------------------------------------------------------------------------------
Is there anyone who could explain about the port number in sqlnet.log?
Is that really from client connection request??
One more question!!.
"SQLNET.INBOUND_CONNECT_TIMEOUT=0" will resolve the above problem?
Thanks and Regards.