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 Enable OS Level

user11972345Jul 5 2015 — edited Jul 7 2015

Dear All,

Kindly advise what could be issue in Audit Trail.

I enable Audit Trail OS level as mentioned below and restart database several time.

SQL> show parameter audit

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

audit_file_dest                      string         F:\ORACLE\ADMIN\INSISDB\ADUMP

audit_sys_operations            boolean     TRUE

audit_trail                             string        OS

After that i created a table and a user audit_test.

than i drop user audit_test;

but no Audit log  is generating and mentioned above folder (audit_file_dest) is Empty.

may i know what steps i missed.

OS: Windows 2008

DB: 11g R2

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2015
Added on Jul 5 2015
11 comments
3,741 views