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.
|