9.5.3 Determining the Current Status of a Listener

To show the current status of a listener, use either the STATUS command of the Listener Control utility or Oracle Enterprise Manager Cloud Control. The status output provides basic status information about a listener, a summary of listener configuration settings, the listening protocol addresses, and a summary of services registered with the listener.

Parent topic: Administering the Listener

9.5.3.1 Showing Status Using Listener Control

Run the STATUS command to view status of the listener.

At the command line, enter the following command: 

lsnrctl STATUS [listener_name]

In the preceding command, listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default listener name LISTENER.

Example 9-5 shows example output of the STATUS command.

Example 9-5 Listener Control Utility's STATUS Command Output

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.4.0.0.0
Start Date                15-March-2024 20:22:00
Uptime                    65 days 10 hr. 5 min. 22 sec
Trace Level               support
Security                  OFF
Listener Parameter File   /oracle/admin/listener.ora
Listener Log File         /oracle/network/log/listener.log
Listener Trace File       /oracle/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=sales-server)(PORT=2484)))
 
Services Summary...
Service "sales.us.example.com" has 1 instance(s).
  Instance "sales", status READY, has 3 handler(s) for this service...
Service "hr.us.example.com" has 1 instance(s).
  Instance "hr", status READY, has 2 handler(s) for this service...
The command completed successfully

The STATUS command output includes the sections described in the following table:

Table 9-1 Listener Control Utility STATUS Command

Output Section Description

STATUS of the LISTENER

Status of the listener, including the following:

  • Alias of the listener

  • Version of listener

  • Start time and up time

  • Trace level

  • listener.ora file being used

  • Logging and tracing configuration settings

Listening Endpoints Summary

The protocol addresses the listener is configured to listen on.

Services Summary

A summary of the services registered with the listener and the service handlers allocated to each service.

Service

The registered service.

Instance

The name of the instance associated with the service.

The status field indicates if the instance can accept connections.

  • READY means that the instance can accept connections.

  • BLOCKED means that the instance cannot accept connections.

  • READY/SECONDARY means that this is a secondary instance in an Oracle Real Application Clusters primary/secondary configuration, and is ready to accept connections.

  • RESTRICTED means the instance is in restricted mode. The listener blocks all connections to this instance.

  • UNKNOWN means that the instance is registered statically in the listener.ora file rather than dynamically with service registration. Therefore, the status is not known.

Parent topic: Determining the Current Status of a Listener

9.5.3.2 Showing Status Using Oracle Enterprise Manager Cloud Control

The following procedure describes how to show the status of a listener using Oracle Enterprise Manager Cloud Control:

  1. Access the Net Services Administration page in Oracle Enterprise Manager Cloud Control.

    See Also:

    "Using Oracle Enterprise Manager Cloud Control to Configure Oracle Net Services"

  2. Select Listeners from the Administer list, and then select the Oracle home that contains the location of the configuration files.

  3. Click Go. You may be prompted to log in to the database server.

    The Listeners page appears.

  4. Select a listener.

  5. From the Actions list, select Show Listener Control Status.

  6. Click Go.

    The Listener Control Status page appears.

  7. After viewing the content, click the listener link at the top of the page.

Parent topic: Determining the Current Status of a Listener