Enabling Unified Auditing in Oracle 12c

To enable Unified Auditing in Oracle 12c, you must shut down the Oracle database, stop the Oracle listener service and then restart the Oracle database and Oracle Listener service.

Before you begin

You must have the AUDIT_SYSTEM system privilege or the AUDIT_ADMIN role to complete the following steps.

Procedure

  1. Shut down the Oracle database by connecting to the database with SQLplus, and then type the following command:

    shutdown immediate

  2. Stop the Oracle listener service by typing the following command:

    lsnrctl stop

  3. If applicable, stop the Enterprise Manager by typing the following commands:

    cd /u01/app/oracle/product/middleware/oms

    export OMS_HOME=/u01/app/oracle/product/middleware/oms

    $OMS_HOME/bin/emctl stop oms

  4. Relink Oracle DB with the uniaud option by typing the following commands:

    cd $ORACLE_HOME/rdbms/lib

    make -f ins_rdbms.mk uniaud_on ioracle

  5. Restart the Oracle database by connecting to the database with SQLplus, and then type the following command:

    startup

  6. Restart the Oracle listener service by typing the following command:

    lsnrctl start

  7. If applicable, restart the Enterprise Manager by typing the following commands:

    cd /u01/app/oracle/product/middleware/oms

    export OMS_HOME=/u01/app/oracle/product/middleware/oms

    $OMS_HOME/bin/emctl start oms

  8. To verify that unified auditing is enabled, connect to the Oracle database with SQLplus, and then type the following command:

    select * from v$option where PARAMETER = 'Unified Auditing';

    Verify that the command returns one row with VALUE equal to "TRUE".