Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit Trail records still being logged to Windows Application Event Log

872269Jun 29 2011 — edited Jul 12 2011
Oracle11gR2 (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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2011
Added on Jun 29 2011
1 comment
222 views