修改listener的inbound_connect_timeout参数的方法

修改listener的inbound_connect_timeout参数的方法
SET INBOUND_CONNECT_TIMEOUT

Purpose

Use theSETINBUND_CONNECT_TIMEOUTcommand to specify the time, in seconds, for the client to complete its connect request to the listener after the network connection had been established.

If the listener does not receive the client request in the time specified, then it terminates the connection. In addition, the listener logs the IP address of the client and anORA-12525:TNS: listener has not received client's request in time allowederror message to thelistener.logfile.

See Also:
Oracle Database Net Services Administrator's Guidefor information about specifying the time-out for client connections

Syntax

From the Listener Control utility:

LSNRCTL> SET INCOUND_CONNECT_TIMEOUT

Arguments

{time}: Specify the time, in seconds. Default setting is 60 seconds.

Example

LSNRCTL> SET INBOUND_CONNECT_TIMEOUT 2
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=sales-server)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 2
The command completed successfully.

方法一:
$ 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