Use this Knowledge Script to monitor the following Oracle RAC parameters:
Database Instances: Notifies the user when an Oracle RAC database instance is not running.
Database Services: Monitors the status of the given database services. Notifies the user when any of the services are not running.
Nodeapps and Automatic Storage Management Instances on cluster nodes: Monitors the status of nodeApps and ASM instances of cluster nodes
This Knowledge Script is supported on Oracle 11gR2 and Oracle 12c.
Oracle RAC Database folders. When you drop a script on an Oracle RAC Database folder, a job executes on that database and monitors the status of the instances of that database and its services. It also monitors the status of nodeApps and the ASM instances of all the nodes in the cluster.
The default interval for this script is Every 10 minutes.
Set the following parameters as needed:
Description |
How to Set It |
---|---|
General Settings |
|
Cluster(s) to exclude |
Enter the cluster names to exclude with a comma (,) between each cluster name, to exclude the cluster from all jobs. |
NODES Exclusion list |
Enter a list of Nodes to exclude from RAC, separating each Node name with a comma (,). Use the format clusterName:Nodename , clusterName:NodeName , … |
Instances Exclusion list |
Enter a list of RAC database instances to exclude from RAC, separating each database instance name with a comma (,). Use the format clusterName:DBInstanceName , clusterName:DBinstanceName , |
RAC Services list to be monitored |
Enter a list of RAC database services to monitor. Use the format clusterName:DBName:s1,s2,s3 ; clusterName:DBName:s4,s5,s6 ; .. (separated by semicolon(;) where s1,s2,s3,… are the names of the services to be monitored.) |
Event severity when job fails |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |
Enable debugging? |
Select Yes to enable debugging. The default is unselected. |
Raise event when AppManager fails to get metrics? |
Select Yes to raise an event when AppManager fails to get the metrics. The default is Yes. |
Event Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |
Event Settings |
|
Raise event if database instance is down? |
Select Yes to raise an event when the database instance is down. The default is Yes. |
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 severity level is 10 (red event indicator). |
Raise event if services are not running? |
Select Yes to raise an event if the RAC database services are not running. The default is unselected. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
Raise event if NodeApps are down? |
Select Yes to raise an event if the Nodeapps are down. The default is Yes. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
Raise event if ASM instance is down? |
Select Yes to raise an event if the ASM instance is detected down. The default is Yes. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
Data Collection |
|
Collect data for Status of instances |
Select Yes to collect data for charts and reports. If you enable data collection, the script returns the status of each database instance:
The default is Yes. |
Collect data for RAC Services |
Select Yes to collect data for charts and reports. If you enable data collection, the script returns the status of each database service entered in the RAC service list parameter. The default is unselected. |
Collect data for Nodeapps |
Select Yes to collect data for Nodeapps. When you enable data collection, the script returns the following values for all the nodeApps:
The default is Yes. |
Collect data for ASM instances |
Select Yes to collect data for ASM instances. When you enable data collection, the script returns the following values:
The default is Yes. |