A script-enabled browser is required for this page to function properly.

Create / Edit Service Test - TNS Ping Page

Use this page to define a TNS Ping service test. Use this test to determine the responsiveness of a database via the TNS (Transparent Network Substrate) protocol.

Parameter

Description

Connect String

The string specifying how to connect to the database.

Example: (DESCRIPTION=(ADDRESS_LIST=(PROTOCOL=TCP) (HOST=localhost)(PORT=12345)))(CONNECT_DATA=(SID=db)))
Host, Port and SID Enter the Host Name or IP Address, Port number or System Identifier (SID). If you do not specify a connect string, then the Host, Port and SID are mandatory.
Number of Pings The number of times used to ping the database.

Metrics Collected

Metric

Description

Status Indicates whether the database responds to the pings.
Average Response Time

Indicates the average amount of time to receive a response for each ping. This number may be 0 if the database responds within 10 milliseconds.

User Action
Check that the network is not congested and that the database is not under heavy load. If you have an Enterprise Manager target instance for the database, you should consult the homepage for the database.
Pings Dropped

Indicates the percentage of pings that did not receive a response.

User Action

Check that the network is not congested and that the database is not under heavy load. If you have an Enterprise Manager target instance for the database, you should consult the homepage for the database.

Related Topics

About Services

Types of Service Tests

Creating a Service

Enterprise Manager Information Roadmap