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!

Enabling database auditing

537728Jan 9 2007 — edited Jan 9 2007
Hi, I am trying to activate auditing in an Oracle 9i database but it seems a bit complicated.
Right now Auditing is disabled (audit_trail = none)
If I am not wrong I must set this:

AUDIT_TRAIL = TRUE
(I want to collect the data in SYS.AUD$ table)

It seems that to enable this option I have to reset Oracle.
The question is, where do I exactly write this parameter?

Do I edit the spfile.ora with a text editor, I heard it is not a good idea?

SQL: show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/spfile@.ora


thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2007
Added on Jan 9 2007
9 comments
810 views