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).
Resolved
Step 1: If Necessary, Enable Unified Auditing says to do the following:
On inspection, there is NO such directory (%ORACLE_HOME%/rdbms/bin).
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
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>
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>
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.