SIGN UP MEMBER LOGIN:
   
ARTICLE

How to check status of Oracle Database Listener

Posted by Pamilla Articles | DB Administration March 28, 2011
The lsnrctl is a listener control and this is use for control database listeners. We will set Oracle_sid envirment variable to the desired sid. The status command provides status information about the listener, including start date, uptime, and trace level.
Reader Level:

We will use lsnrctl command for the check status of Oracle Database Listener. The lsnrctl is a listener control and this is use for control database listeners. We can see the current status of the Oracle listener through the status command. The listener.ora file is the configuration file for the network listener.

Synatx:

LSNRCTL> Status LISTENER_NAME

Example: First of all, we will set our oracle_sid envirment variable to the desired SID. We will use lsnrctl command of the listener. The lsnrctl help command will display all available listener command.

C:\> Set oracle_sid=OMFDATA

C:\> lsnrctl

LSNRCTL> Help

Output:

Listener1.gif

We will check the current status with the status command of our listener. The status command provides status information about the listener, including start date, uptime, and trace level.

LSNRCTL> status LISTENER1

Output:

Listener2.gif

Login to add your contents and source code to this article
This Feature is Sponsored By
post comment
COMMENT USING