Configure Oracle Database for Monitoring

Before you start monitoring your Oracle Database with Netwrix Auditor, you should configure it to provide audit trails. Depending on your current database version and edition, Oracle supports different auditing types:

Auditing type Oracle version Details
Unified Auditing Oracle Database 19c, 18c, 12c

Consolidates all auditing into a single repository and view. This provides a two-fold simplification: audit data can now be found in a single location and all audit data is in a single format.

See Configure Oracle Database 12c, 18c, 19c for Auditing for more information.

Fine Grained Auditing

Oracle Database 19c, 18c, 12c, 11g

Available for Enterprise Edition only.

Supports auditing of actions associated with columns in application tables — along with conditions necessary for an audit record to be generated.

Helps to focus on security-relevant columns and rows, ignoring areas that are less important.

See Configure Fine Grained Auditing for more information.

Standard Auditing (trail auditing mode) Oracle Database 11g

See Configure Oracle Database 11g for Auditing for more information.

Use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit:

  • SQL statements
  • privileges
  • schema objects
  • network and multitier activities

See Oracle documentation for more information.

NOTE: Starting with version 9.96, Netwrix Auditor provides limited support of Oracle Database 11g and trail auditing mode, in particular: Netwrix Auditor client UI does not display any warnings and / or errors related to Standard Auditing mode operation.

NOTE: Oracle Wallet is not supported for Oracle 11g.

Also, remember to do the following:

  1. Configure Data Collecting Account, as described in Grant 'Create Session' and 'Select' Privileges to Access Oracle Database
  2. Configure required protocols and ports, as described in Protocols and Ports Required for Monitoring Oracle Database