Oracle Listener Information
1. Check the listener running on Operating System.
-- On Linux
ps -ef|grep tns
-- On windows
Open the services.msc and check the name with OracleTNS
For default Listener name: OracleTNSListener
2. Check the listener status with following command.
For status the Listener run following command from command prompt:
lsnrctl status
Note: If listener name is default LISTENER then no need to specify
3. Stop the listener
For start the Listener run following command from command prompt:
lsnrclt stop
Note: If listener name is default LISTENER then no need to specify
4. Start the listener
For start the Listener run following command from command prompt:
lsnrctl start
Note: If listener name is default LISTENER then no need to specify
Reload the listener
If you made any changes in listener.ora file. For effect the changes you need to reload the Listener configuration.
lsnrctl reload
Note: If listener name is default LISTENER then no need to specify
Check the Listener Status
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
Stop or Disable the listener log
set log_status off
rename listener.log listener.old
set log_status on