lsnrctl使用详解
(2009-09-11 11:16:48)
标签:
unixlsnrctl命令it |
分类: 技术博论 |
停止指定监听:lsnrctl stop
启动指定监听:lsnrctl start
杀掉指定监听进程:kill -9 进程ID
监听状态:lsnrctl status
[tmdata2:smis:/home/smis]lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 11-SEP-2009 09:45:59
Copyright (c) 1991, 2005, Oracle.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tmdata2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias(别名)
Version
Start
Date
Uptime(启动日期)
Trace
Level(跟踪级别)
Security
SNMP
Listener Parameter File
Listener Log
File
Listening Endpoints Summary...
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Service "orcl" has 1 instance(s).
Service "orclXDB" has 1 instance(s).
Service "orcl_XPT" has 1 instance(s).
The command completed successfully
[tmdata2:smis:/home/smis]services lsnr_hndw
sh: services: Execute permission denied.
lsnrctl services
version
reload
change_config
trace
quit
exit
set*
password
rawmode
displaymode
trc_file
trc_directory
trc_level
OFF
USER
ADMIN
SUPPORT
Oracle Corporation
log_file
指定一个监听器将把日志信息写到哪里。这个参数在默认的情况下是ON,并默认为%oracle_home%\network\log\listener.log
log_directory
log_status
current_listener
inbound_connect_timeout
定义监听器在一个会话得到启动时将等待的有效响应时间。默认设置为10秒。
startup_waittime
定义监听器在响应lsnrctl命令行工具中的一条status命令之前将等待多长时间。
save_config_on_stop
指定在一个lsnrctl会话期内所发生的修改在退出时是否应该被保存起来。
show*
rawmode
显示关于status和service的较详细信息(当他们设置成on时)值为ON或OFF
displaymode
把lsnrctl工具的显示模式设置成raw、compact、normal或verbose
服务显示模式为NORMAL
rules
trc_file
指定监听器跟踪信息的位置。默认设置是$ORACLE_HOME\network\trace\listener.trc
正在连接到
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=3521)))
listener2 参数 \trc_file\ 被设为 listener2.trc
命令执行成功
trc_directory
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521))
)
lsnr_hndw parameter "trc_directory" set to
/oracle/app/oracle/product/920/networ
k/trace/
The command completed successfully
trc_level
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521))
)
lsnr_hndw parameter "trc_level" set to off
The command completed successfully
log_file
指定一个监听器将把日志信息写到哪里。这个参数在默认的情况下是ON,并默认为%oracle_home%\network\log\listener.log
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521))
)
lsnr_hndw parameter "log_file" set to lsnr_hndw.log
The command completed successfully
log_directory
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521))
)
lsnr_hndw parameter "log_directory" set to
/oracle/app/oracle/product/920/networ
k/log/
The command completed successfully
log_status
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521))
)
lsnr_hndw parameter "log_status" set to ON
The command completed successfully
current_listener
目前的监听器为 listener2
inbound_connect_timeout
定义监听器在一个会话得到启动时将等待的有效响应时间。默认设置为10秒。
$ oerr ora 12525
12525, 00000, "TNS:listener has not received client's request in
time allowed"
// *Cause: The listener disconnected the client because the client
failed to
// provide the necessary connect information within the allowed
time interval.
// This may be a result of network/system delays; or this may
indicate that a
// malicious client is trying to cause a Denial of Service attack
on the
// listener.
// *Action: If the error occurred because of a slow
network/system,
// reconfigure INBOUND_CONNECT_TIMEOUT to a larger value. If a
malicious
// client is suspected, use the address in listener.log to identify
the
// source and restrict access. Turn on tracing for more
information.
// *Comment: The logged address in listener.log may not be reliable
as it
// can be forged at the lower networking layers (e.g. in the case
of TCP/IP).
startup_waittime
定义监听器在响应lsnrctl命令行工具中的一条status命令之前将等待多长时间。
正在连接到
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=3521)))
listener2 参数 \startup_waittime\ 被设为 0
命令执行成功
snmp_visible
save_config_on_stop
指定在一个lsnrctl会话期内所发生的修改在退出时是否应该被保存起来。
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.76.1.41)(PORT=3521)
)
lsnr_hndw parameter "save_config_on_stop" set to OFF
The command completed successfully