Use this Knowledge Script to monitor the connectivity and login capability of Oracle databases on UNIX and Linux systems. This script attempts to connect to the database you select. If the connection attempt is successful, this script reports the status of the database and of its login capability. If the connection attempt is unsuccessful, an event is raised.
The account you use to run this script must have SELECT permissions for the following tables:
V_$INSTANCE
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 connection and login status? |
Select Yes to collect data for charts and reports. If you enable data collection, the script returns the status of the database and of its login capability. The default is unselected. |
Raise event if unable to connect? |
Select Yes to raise an event if an attempt to connect to the Oracle database is unsuccessful. The default is Yes. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |
Raise event with database and login status? |
Select Yes to raise an event providing information on the database and login status. The default is unselected. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta event indicator). |
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). |