ARTICLE

How to check status of Oracle Database Listener

Posted by Pamilla in Articles | DB Administration on March 28, 2011

Tags: Oracle, Oracle article, Oracle tutorial, SQL*PLUS, PL/SQL, Database, DBA, Oracle DBA, check status of Oracle Database Listener, Listener Oracle, Listener DBA

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.

Tweet
1502
0

Reader Level: Beginner

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:

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: