[root@ProdDB01 ~]# lsnrctl help
LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:21:53
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
dbsnmp_start dbsnmp_stop dbsnmp_status
change_password quit exit
set* show*
[root@ProdDB01 ~]#
[root@ProdDB01 ~]# lsnrctl help show
LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:22:54
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
The following operations are available after show
An asterisk (*) denotes a modifier or extended command:
rawmode displaymode trc_file
trc_directory trc_level log_file
log_directory log_status current_listener
connect_timeout startup_waittime snmp_visible
use_plugandplay save_config_on_stop
[root@ProdDB01 ~]#
1. View Available Listener Commands
lsnrctl help command will display all available listener commands. In Oracle 11g following are the available listener commands.
- start – Start the Oracle listener
- stop – Stop the Oracle listener
- status – Display the current status of the Oracle listener
- services – Retrieve the listener services information
- version – Display the oracle listener version information
- reload – This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
- save_config – This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER”
- trace – Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
- spawn – Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
- change_password – Set the new password to the oracle listener (or) change the existing listener password.
- show – Display log files and other relevant listener information.
Reference:
