8 Listener

Alias

Alternative name for the listener. On the Metric Detail page, you can see the value of this metric only when you select one of the Real Time refresh options. The alias also appears on the Listener home page.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

Security

Shows whether or not a password is required to run specific commands with the Listener Control Utility.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

SID List

Lists the System Identifiers (SIDs) for the services monitored by the listener

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

List of SIDs for the listener is stored in the listener.ora configuration file

SNMP Status

Indicates whether or not the listener can respond to queries from an SNMP-based network management system

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

Start Date

Represents the day and time when the listener was last started. On the Metric Detail page, you can see the value of this metric only when you select one of the Real Time refresh options. This metric also appears on the Enterprise Manager Listener home page.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

TNS Address

Displays the protocol, host, and port information for the listener. On the Metric Detail page, you can see the value of this metric only when you select one of the Real Time refresh options. The TNS address also appears on the Listener home page.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

TNS address of the Listener is defined in the listener.ora configuration file

Trace Level

Represents the level of tracing currently enabled for the listener. Tracing can be used to troubleshoot problems with the listener by saving additional information to the trace file. For more information about the trace levels you can set for the listener, see the information about the Listener Control Utility in the Oracle Database Net Services Reference Guide 10g Release 2 (10.2).

On the Metric Detail page, you can see the value of this metric only when you select one of the Real Time refresh options.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

Version

Version of the listener software. On the Metric Detail page, you can see the value of this metric only when you select one of the Real Time refresh options. This metric also appears on the Enterprise Manager Listener home page.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the STATUS command of the Listener Control Utility

Connections Established

Number of connections established since the listener was last started

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the SERVICES command of the Listener Control Utility

User Action

If you are noticing experiencing performance issues with the database or other services supported by the listener, review the historical values of this metric to determine whether or not the performance problems are caused by excessive load on the listener or host.

Connections Established (per min)

Average number of connections per minute that were established with the listener

Data Source

Derived from the Listener Control Utility

Metric Summary

The following table shows how often the metric's value is collected.

User Action

If you are noticing experiencing performance issues with the database or other services supported by the listener, review the historical values of this metric to determine whether or not the performance problems are caused by excessive load on the listener or host.

Connections Refused

Number of connections to the listener that were refused. A connection can be refused for a variety of reasons, including situations where the database or other listener service is down, or if the connection timed out.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the SERVICES command of the Listener Control Utility

User Action

If Enterprise Manager reports a high number of refused connections, check the availability and performance of the database or other services supported by the listener.

Connections Refused (per min)

Average number of connections that were refused per minute

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

Derived from the Listener Control Utility

User Action

If Enterprise Manager reports a high number of refused connections, check the availability and performance of the database or other services supported by the listener.

Response Time (msec)

This metric represents the time (in milliseconds) that it takes for the Listener to respond to a network request (ping).

By default, this metric has a critical threshold of 100 and a warning threshold of 80. A critical alert is generated when the metric value exceeds the critical threshold value 1 time. A warning alert is generated when the metric value exceeds the warning threshold value 1 time. You can edit the value for a threshold as required.

By default, Enterprise Manager tests the value of this metric every 24 hours.

When an alert is generated, the alert text is:

Listener response to a TNS ping is %value% msecs

Data Source

The value of this metric is derived using the TNSPING command. For more information about the TNSPING command, see the Oracle Database Net Services Administrator's Guide 10g Release 2 (10.2).

User Action

If the Listener response time consistently exceeds the threshold, users are likely experiencing performance issues while accessing the database or other services on this host. Use the Enterprise Manager Central Console to review other performance indicators, such as the overall health of your database and the response time of your hosts and Web Applications.

Status

This metric returns a value of "1" if the Listener is up and running; it returns a 0 if the Listener is unavailable.

By default, this metric has a critical threshold of 0. A critical alert is generated when the metric value equals the critical threshold value 1 time. You can edit the value for a threshold as required.

By default, Enterprise Manager tests the value of this metric every 24 hours.

When an alert is generated, the alert text is:

The listener is down: %oraerr%.

Data Source

This metric is derived from the STATUS command in the Listener Control Utility. For more information, see the Oracle Database Net Services Administrator's Guide 10g Release 2 (10.2).

User Action

When the listener is down, users cannot access the database or other services on this host. Review the troubleshooting information in Oracle Database Net Services Administrator's Guide 10g Release 2 (10.2).

TnsPing

The TNSPING utility determines whether or not a service (for example, an Oracle database or any other service) on an Oracle Net network can be successfully reached. If you can connect successfully from a client to a server (or a server to another server) using the TNSPING utility, it displays an estimate of the round trip time (in milliseconds) to reach the Oracle Net service.

If it fails, it displays a message describing the error that occurred. This enables you to see the network error that is occurring without the overhead of a database connection.

Metric Summary

The following table shows how often the metric's value is collected.

Data Source

This metric is derived from the tnsping <TNS address> command in the Listener Control Utility. For more information, see the Oracle Database Net Services Administrator's Guide 10g Release 2 (10.2).

User Action

When the listener is down, users cannot access the database or other services on this host. Review the troubleshooting information in Oracle Database Net Services Administrator's Guide 10g Release 2 (10.2).