troubleshooting Question

Oracle 9i Audit Trail is True, but sys.aud$ table is not capturing data

Avatar of ghanrahan
ghanrahan asked on
Oracle Database
3 Comments1 Solution3904 ViewsLast Modified:
Hi, I  have enabled auditing in an Oracle 9i instance, but the sys.aud$ table is still showing zero rows.  I have set the value of audit_trail = TRUE.  This has worked fine for me in other Oracle 9i instances, but not here.  I am able to describe the sys.aud$ table now that auditing is enabled, but if I do a count it returns zero rows.  Sys.aud$ is completely empty and there has been lots of traffic on the database.  There have been many logins as well.  Any assistance you can provide will be appreciated.


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros