10. Database Tier - Access to Middle Tier

In order to ensure connectivity between the database server and the Middle Tier this check performs a PLSQL-ping from the database server to the Middle Tier server and triggers if ping fails.

Multiple Instances: No

Interval: Every 5 minutes (288 times per day)

Status

Expression

Critical

If (PLSQLAP Ping == 0)

Impact	This state will have an impact on e.g. Reporting and outgoing messages from Connect.
Suggestion	Reconfigure the instance with IFS Installer.

If not status Critical.

Unknown

Missing application response.

Metric & Service	Command line example
PLSQLAP Ping	java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=PLSQLAP_PING -oeq=1 -ceq=0