Monitor options for the Oracle agent in traditional database and container database

The Oracle agent provides two levels of monitoring: basic and detail. By default, the agent does a basic monitoring.

The basic monitoring mode has the following options:

The MonitorOption attribute of the Oracle resource determines whether the agent must perform basic monitoring in Process check or Health check mode.

Table: Basic monitoring options describes the basic monitoring options.

Table: Basic monitoring options

Option

Description

0

(Default)

Process check

The agent scans the process table for the ora_dbw0, ora_smon, ora_pmon, ora_lmon, and ora_lgwr processes to verify that Oracle is running.

In this mode, the agent also supports intelligent resource monitoring.

See How the Oracle and Netlsnr agents support intelligent resource monitoring.

1

Health check (supported on Oracle 11g and later)

The agent uses the Health Check APIs from Oracle to monitor the SGA and retrieve the information about the instance.

If you want to use the Oracle agent's intentional offline functionality, you must enable Health check monitoring.

See How the agent makes Oracle highly available.

The agent does not support intelligent resource monitoring in this mode.

See How the Oracle agent supports health check monitoring.

Review the following considerations if you want to configure basic monitoring:

In the detail monitoring mode, the agent performs a transaction on a test table in the database to ensure that Oracle database functions properly. The agent uses this test table for internal purposes. Veritas recommends that you do not perform any other transaction on the test table.

See Setting up detail monitoring for VCS agents for Oracle.

More Information

How the agent handles Oracle error codes during detail monitoring