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:
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.
The default schedule for this script is Every 10 minutes.
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:
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). |