1. Cloud Control Host Lifecycle Management Guide
  2. Monitoring and Managing Hosts
  3. Additional Setup for Real-time Monitoring
  4. Preparing To Monitor the Oracle Database
  5. Setting Auditing User Privileges

Setting Auditing User Privileges

When you create a Real-time Monitoring Compliance Standard Rule to monitor an Oracle instance target, the agent will read the audit trail to perform its monitoring.

Real-time monitoring for Oracle entity types requires the audit trail to be stored in the database as opposed to a file. To verify if a setting is correct, follow these steps:

  1. In Cloud Control, go to the target home page for the Oracle Database target for which you want to enable Real-time Monitoring.
  2. From the Administration menu, select Initialization Parameters.
  3. Log in to the database as a sys user, connecting as SYSDBA.
  4. Find the parameter audit_trail and ensure it is set to DB. If not, this parameter needs to be changed in the Oracle Database.
  5. This change will require a restart of the database.