Oracle Listener General Commands

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s