Let's Join and share our day to day activities, Views, Knowledge, Questions and achievements in Oracle Database (8i / 9i / 10g or 11g)

Jan 20, 2015

Oracle Listener (LSNRCTL)

>> Display Oracle Listener Status

$ lsnrctl status

>> Start Oracle Listener
$ lsnrctl start

>> Stop Oracle Listener

$ lsnrctl stop

>> Restart Oracle Listener

$ lsnrctl reload

>> Available Listener Commands 

$ lsnrctl help
  • 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.

>> Help menu for specific listener command
$ lsnrctl help show

No comments:

Post a Comment