Unable to Set up Unified Auditing under 12.1.0.1

Overview

While following the examples given in Oracle® Database 2 Day + Security Guide 12c Release 1 (12.1), I was unable to enable Unified Auditing in my personal edition database (EXAMPLES).

References

Status

Resolved

Diagnosis

Documentation is wrong

Step 1: If Necessary, Enable Unified Auditing says to do the following:

    • Windows: Rename the %ORACLE_HOME%/rdbms/bin/orauniaud12.dll.option file to %ORACLE_HOME%/bin/orauniaud12.dll.

On inspection, there is NO such directory (%ORACLE_HOME%/rdbms/bin).

DLL is found

The DLL is found at a different location (%ORACLE_HOME%/BIN) and with a different name:

D:\app\oracle\product\12.1.0\dbhome_1\BIN>dir *orauniaud12* Volume in drive D has no label. Volume Serial Number is 3AC7-D1ED Directory of D:\app\oracle\product\12.1.0\dbhome_1\BIN 2013-06-28 04:41 6,144 orauniaud12.dll.dbl 1 File(s) 6,144 bytes 0 Dir(s) 851,712,364,544 bytes free

Alternative Procedure

As an alternative procedure, I did the following, after shutting down the database instance using SQL*Plus:

D:\app\oracle\product\12.1.0\dbhome_1\BIN>ren orauniaud12.dll.dbl orauniaud12.dll D:\app\oracle\product\12.1.0\dbhome_1>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sat Mar 1 14:05:54 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 5094195200 bytes Fixed Size 2806432 bytes Variable Size 1107299680 bytes Database Buffers 3976200192 bytes Redo Buffers 7888896 bytes Database mounted. Database opened. SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; VALUE ---------------------------------------------------------------- FALSE SQL>

Solution Found

I stumbled upon the solution purely by chance. The only thing I did differently was to use net stop and net start to manage the database instance. This should not really affect the results.

D:\app\oracle\product\12.1.0\dbhome_1\BIN>net stop oracleserviceexamples The OracleServiceEXAMPLES service is stopping..... The OracleServiceEXAMPLES service was stopped successfully. D:\app\oracle\product\12.1.0\dbhome_1\BIN>net start oracleserviceexamples The OracleServiceEXAMPLES service is starting........................... The OracleServiceEXAMPLES service was started successfully. D:\app\oracle\product\12.1.0\dbhome_1\BIN>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sat Mar 1 16:22:38 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Personal Oracle Database 12c Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics, Real Application Testing and Unified Auditing options SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; VALUE ---------------------------------------------------------------- TRUE SQL>

My Oracle Support

The MOS note, (How To Enable The New Unified Auditing In 12c ? (Doc ID 1567006.1)) mentions the correct name of the DLL, but uses SQL*Plus to restart the database.