Unable to Set up Unified Auditing under 12.1.0.1

Contents

  1. 1 Overview
  2. 2 References
  3. 3 Status
  4. 4 Diagnosis
    1. 4.1 Documentation is wrong
    2. 4.2 DLL is found
    3. 4.3 Alternative Procedure
  5. 5 Solution Found
  6. 6 My Oracle Support

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.