Use this Knowledge Script to monitor the status of a database. This script checks whether the Oracle RDBMS background processes are running and whether a local connection can be made.
Each Oracle instance has a default set of background processes that must be running. An event is raised if any of the processes that you specified for monitoring in the Background processes to monitor parameter are down, or if a connection cannot be made to the database instance.
The account you use to run this script must have SELECT permissions for the following table:
V_$VERSION
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
The default interval for this script is Every 10 minutes.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Oracle Username |
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. To use SYSDBA authentication, leave this parameter blank. The default is blank. |
|
Collect data for process and connection status? |
Select Yes to collect data for charts and reports. When you enable data collection, the script returns the following values:
This provides a way to report on the percentage of system uptime in any given period. The default is unselected. |
|
Background processes to monitor (comma-separated, no spaces) |
Enter the names of Oracle RDBMS background processes you want to monitor, separated by commas and no spaces. The default is: LGWR,PMON,SMON,RECO,DBWO,DBWR. |
|
Create/Delete blackout file for a database if it appears to be down/up? |
Select Yes if the script should create a file in the blackout directory so that no further jobs are run on this database. The SetMonitoringOptions script must be run to set the blackout directory before this file can be created. The default is unselected. |
|
Raise event if a process is down or unable to connect? |
Select Yes to raise an event if an Oracle database or background process 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 15 (yellow event indicator). |
|
Ignore agent’s blackout state and keep monitoring? |
Select Yes to collect data during the blackout window for scheduled maintenance that you set using the AppManager for UNIX AMAdminUNIX_ SchedMaint Knowledge Script. The default is unselected. |
|
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). |