Audit Trail records still being logged to Windows Application Event Log
872269Jun 29 2011 — edited Jul 12 2011Oracle11gR2 (11.2.0.2.0) on Windows XPSP3
Previously, Oracle was configured with AUDIT_TRAIL parameter set to OS. Audit Trail records were logged to the Event Log -- this worked fine.
But, I want to log to the AUD$ table. I changed the AUDIT_TRAIL parameter to DB in the pfile; recreated the spfile; shutdown and restarted.
SQL> select name, value from v$parameter where upper(name) like '%AUD%';
NAME VALUE
------------------------------------------ -------------------------------------
audit_sys_operations TRUE
audit_file_dest C:\ORACLe\ADMIN\MYSID\ADUMP
audit_trail DB
SQL> select count(*) from AUD$;
COUNT(*)
----------------
0
SQL> select count(*) from FGA_LOG$;
COUNT(*)
----------------
0
But, events are still being logged to the Windows Application Event Log and NOT to the audit tables. All the documentation I can find says that this should be working.
What am i missing?