haorainsptlsub (Checks the status of an Oracle instance)

HA Monitor Kit for Oracle Description and User's Guide

haorainsptlsub (Checks the status of an Oracle instance)

Format

haorainsptlsub instance-identifier { -slowdown | -status }

Executable user

Superuser, Oracle user

Description

Executes SQL statements to check an Oracle instance for slowdown. This is a subcommand called from haorainsptl (checks the status of an Oracle instance).

Option

instance-identifier
Specify the instance identifier of the Oracle instance whose status you want to check and that has been defined in ORACLE_SID of the Oracle instance control definition file.
-slowdown
Execute SQL for slowdown monitoring.
-status
Execute SQL for checking the status.

Return value

Value	Meaning
0	Normal termination (The status of the Oracle instance was checked successfully.)
Other than 0	Abnormal termination