If the ORACLE_HOME variable is set.

Run the following command to verify that the $ORACLE_HOME variable is correctly set.

# echo $ORACLE_HOME

Set the ORACLE_HOME environment variable if it is not already set. For example, run the following command to set the ORACLE_HOME variable:

# export ORACLE_HOME=/u01/oraHome

where /u01/oraHome is the Oracle home directory path.

If the SID for the Oracle instance is set.

Run the following command to verify that the $ORACLE_SID variable is correctly set.

# echo $ORACLE_SID

If required, run the # export ORACLE_SID=db command to set the $ORACLE_SID variable.

If the library path is set.

Run the following command to verify that the $LD_LIBRARY_PATH variable is correctly set.

# echo $LD_LIBRARY_PATH

If required, run the # export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH command to set the $LD_LIBRARY_PATH variable.

If the Oracle instance is online.

Run the following command to verify that the Oracle health check binary reports the status correctly:

# ./oraapi_<Arch>_<Oracle_FullVersion>

where <Arch>_<Oracle_FullVersion> is the system architecture and the Oracle full version.

For example, # ./oraapi_64_121010, where oraapi_64_121010 is a binary built for Oracle version 12 on a 64-bit system.

The system displays the following message:

Instance is online

Run # echo $?

If the system displays 110 the instance is online and active.

If the Oracle instance is offline.

Run the following command to verify that the Oracle health check binary reports the status correctly:

# ./oraapi_<Arch>_<Oracle_FullVersion>

where <Arch>_<Oracle_FullVersion> is the system architecture and the Oracle full version.

For example, # ./oraapi_64_121010, where oraapi_64_121010 is a binary built for Oracle version 12 on a 64-bit system.

The system displays the following message:

Failure: Instance Shutdown         class: SOFT

Proper Shutdown

Run # echo $?

If the system displays 100 the instance is offline.

If the Oracle instance is abnormally terminated.

If any of the important Oracle process is killed (for example, ora_pmon_<sid>, ora_smon_<sid>), the Oracle instance is abnormally terminated. In such a case run the Oracle health check binary, and the system displays following message:

For example, run # ./oraapi_64_121010

Failure: Abnormal Termination
class: SOFT
Abnormal termination

Run # echo $?

If the system displays 98 the termination of Oracle processes. The VCS resource fails over as Oracle termination was abnormal and not intentional.