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. |
| Standard Auditing (trail auditing mode) | Oracle Database 11g |
See Configure Oracle Database 11g for Auditing for more information. Use initialization parameters and the
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. |
- If you are going to use Oracle Wallet to connect to your database, see the Create and Configure Oracle Wallet section for configuration details.
NOTE: Oracle Wallet is not supported for Oracle 11g.
- If you are unsure of your audit settings, refer to the Verify Your Oracle Database Audit Settings
Also, remember to do the following:
- Configure Data Collecting Account, as described in Grant 'Create Session' and 'Select' Privileges to Access Oracle Database
- Configure required protocols and ports, as described in Protocols and Ports Required for Monitoring Oracle Database