Configure Oracle Unified Auditing (SQL)

Prev Next

Oracle 12c introduced Unified Auditing. Previously, separate audit trails were kept for individual components. The Unified Audit trail combines all auditing into a single audit trail. By default, Oracle 12c is in “Mixed Mode” and all log data is written to both the traditional locations and the new location. Once Unified Auditing is explicitly enabled, all audit data are stored in the new location exclusively.

Note

The minimum privileges for Oracle Unified Audit and Common Audit trail are CONNECT and AUDIT_VIEWER role.

  1. Verify whether Unified Auditing is enabled.

    SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';
  2. If this query returns the following, Unified Auditing has not been enabled.

    PARAMETER VALUE
    ------------------ ----------
    Unified Auditing FALSE
  3. To enable Unified Auditing in Oracle 12c, first shut down your Oracle databases and listeners that are associated to the Oracle Home.

  4. Next, relink the Oracle executable to support Unified Auditing by doing the following:

    Unix/Linux:

    cd $ORACLE_HOME/rdbms/lib
    make –f ins_rdbms.mk uniaud_on ioracle

    Windows:

    cd %ORACLE_HOME%\bin
    mv orauniadu12.dll.dbl orauniaud12.dll
  5. Start your Oracle databases and listeners associated to the Oracle Home.

  6. Both ORA_SECURECONFIG and ORA_LOGON_FAILURES policies are enabled by default and can be configured as needed.

  7. Enable auditing for the appropriate tables.