(ORA-3136)?inbound connection timed out 错误诊断?

最近查看oracle日志，发现提示

(ORA-3136) inbound connection timed out 错误诊断 

Metalink上给出的解决方案如下:

1. set INBOUND_CONNECT_TIMEOUT_ =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

 

修改listener的inbound_connect_timeout参数的方法

 

方法一:

$ lsnrctl

 

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production on 29-OCT-2007 10:00:57

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> help

The following operations are available

An asterisk (*) denotes a modifier or extended command:

 

start               stop                status              

services            version             reload              

save_config         trace               spawn               

change_password     quit                exit                

set*                show*               

 

LSNRCTL> show

The following operations are available after show

An asterisk (*) denotes a modifier or extended command:

 

rawmode                     displaymode                 

rules                       trc_file                    

trc_directory               trc_level                   

log_file                    log_directory               

log_status                  current_listener            

inbound_connect_timeout     startup_waittime            

snmp_visible                save_config_on_stop         

dynamic_registration        

 

LSNRCTL> show inbound_connect_timeout

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "inbound_connect_timeout" set to 60

The command completed successfully

 

LSNRCTL> set inbound_connect_timeout 0

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "inbound_connect_timeout" set to 0

The command completed successfully

 

LSNRCTL> show inbound_connect_timeout

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "inbound_connect_timeout" set to 0

The command completed successfully

 

LSNRCTL> set save_config_on_stop on   #表示修改参数永久生效，否则只是临时生效，下次重启监听又还原为原来的值了

 

LSNRCTL> exit

 

 

方法二：

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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29893219/viewspace-1851594/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29893219/viewspace-1851594/