How to check the Oracle Listener Information

Check the listener running on Operating System.

lsnrctl status

-- Check in services.msc in window for listener

Check the listener status with following command.

For status the Listener run following command from command prompt:

lsnrctl status

How to stop the listener

For start the Listener run following command from command prompt:

lsrnctl stop <listener_name>

How to start the listener

For start the Listener run following command from command prompt:

lsnrctl start

How to reload the listener changes or configuration without restart listener

If you made any changes in listener.ora file. For effect the changes you need to reload the Listener configuration.

lsnrctl reload

Check the Service status in the Listener

lsnrctl status command tell the listener configuration or status :
Ready – Means listener is register dynamically
unknown – lsnrctl having entries in listener.ora file
Blocked – database is open in restricted mode or DR (dataguard) is configured

Rename the listener log file in Oracle

lsrnctl> set log_status off
-- Rename it with OS command like mv or rename
lsrnctl> set log_status on

Disable the listener log

lsnrctl
lsrnctl> set log_status off

Enable the listener log

lsnrctl
lsnrctl> set log_satus on

Check the listener log status is on or off

lsrnctl> show log_status

OR

lsrnctl> status