oracle bround,【案例】Oracle警告 WARNING:inbound connection timed out (ORA-3136)解决办法

天萃荷净

运维DBA反映，巡检alert日志文件中发现大量Oracle日志警告WARNING: inbound connection timed out (ORA-3136)

1、alert日志文件警告

alert文件中

Mon Jun 27 11:12:34 2011

WARNING: inbound connection timed out (ORA-3136)

sqlnet.log文件中

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.4.0 – Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 – Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 – Production

Time: 27-JUN-2011 11:12:34

Tracing not turned on.

Tns error struct:

ns main err code: 12535

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

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=211.155.227.20)(PORT=2104))

2、Oralce警告WARNING: inbound connection timed out (ORA-3136)原因

Whenever default timeouts are assigned to a parameter, there may be cases where this default does not work well with a particular application. However, some type of timeout on the connection establishment is necessary to combat Denial of Service attacks on the database. In this case, SQLNET.INBOUND_CONNECT__TIMEOUT andINBOUND_CONNECT_TIMEOUT_listenername were given default values of 60 seconds in Oracle 10.2. It is these timeout values that can cause the errors described in this note.

Also note that it is possilbe the reason the database is slow to authenticate, may be due to an overloaded Oracle database or node.

3、Oracle警告WARNING: inbound connection timed out (ORA-3136)解决思路

1). set INBOUND_CONNECT_TIMEOUT_listenername=0 in listener.ora

2). set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.

3). stop and start both listener and database.

4). Now try to connect to DB and observe the behaviour

4、Oracle警告(ORA-3136)的解决办法

4.1)修改INBOUND_CONNECT_TIMEOUT_listenername

4.1.1)lsnrctl命令修改

LSNRCTL> set inbound_connect_timeout 0

LSNRCTL>save_config

4.1.2)vi修改

修改listener.ora文件，加入: INBOUND_CONNECT_TIMEOUT_listenername=0

4.2)修改SQLNET.INBOUND_CONNECT__TIMEOUT

修改sqlnet.ora文件，加入: SQLNET.INBOUND_CONNECT__TIMEOUT=0

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle警告 WARNING:inbound connection timed out (ORA-3136)解决办法