Configure Oracle Database for Monitoring

Before you start monitoring your Oracle Database with Netwrix Auditor, arrange your environment. Depending on your current database version and edition, Oracle provides different types of auditing:

• Unified Auditing—Recommended for Oracle Database 12c, 18c, 19c. Unified Auditing 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—Available for Oracle Database Enterprise Edition only. Allows auditing of actions associated with columns in application tables along with conditions necessary for an audit record to be generated. It helps focus on security-relevant columns and rows and ignore areas that are less important. See Configure Fine Grained Auditing for more information.

• Trail Audit—For Oracle Database 11g. In Trail Auditing mode, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, schema objects, network and multitier activities. See Configure Oracle Database 11g for Auditing for more information.

  IMPORTANT! Starting with version 9.95, Netwrix Auditor provides limited support of Oracle Database 11g and trail auditing mode accordingly. See Data Collection from Oracle Database for more information.

  When selecting auditing mode, consider that starting with version 9.95, Netwrix Auditor's user interface does not display any warnings and / or errors regarding to trail audit mode operation.

• If you are going to use Oracle Wallet to connect to your database, see the following section: Create and Configure Oracle Wallet for configuration details.

If you are unsure of your audit settings, refer to the following section:

• Verify Your Oracle Database Audit Settings

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