3.10 ClusterInstanceDown

Use this Knowledge Script to be notified when an Oracle instance in a cluster fails or becomes inactive.

Run this Knowledge Script for Oracle RAC monitoring only. This Knowledge Script uses the srvctl command functionality to fetch the statuses of all the cluster instances.

The account you use to run this script must have SELECT permissions for the following tables:

  • V_$VERSION
  • GV_$INSTANCE (for Oracle RAC monitoring only)

3.10.1 Resource Objects

Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and determines if the instance running on that host is active or inactive.

3.10.2 Default Schedule

The default schedule for this script is Every 10 minutes.

3.10.3 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

Oracle Username

For RAC cluster monitoring, enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username.

NOTE:This parameter must not be blank if you are deploying RAC cluster monitoring. If you are deploying non-RAC cluster monitoring, this parameter is ignored.

The default is blank.

Collect data for instance status?

Select Yes to collect data for charts and reports. If you enable data collection, the script returns the status of each instance:

  • 100--instance is running

  • 0--instance is down

The default is unselected.

RAC Instance Exclude Filter

Select Yes to exclude RAC instances. The default is unselected.

RAC Instance to be excluded for status check [comma separated]

Enter the names of the RAC instances you want to exclude.

Raise event if instance is down or if unable to check status?

 

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event detecting that an instance is down. The default is 10 (red event indicator).

Fully qualified path for srvctl, if srvctl is not located in ORACLE_HOME/bin

Enter the fully qualified path for srvctl, if srvctl is not located in ORACLE_HOME/bin

Event severity for internal failure

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).