Yeah. Do truncate the AUD$ table, set the AUDIT_TRAIL=FALSE and then
issue AUDIT NONE owner.table_name for all the tables that have auditing
enabled. What's probably filling up the AUD$ is DML audit trails from
ill-advised AUDIT ALL commands!
Sybrand Bakker wrote:
>
> Should be.
> That dangerous DBA has set up auditing, and the AUD$ table, which probably
> has useless info, is causing problems.
> Disable auditing by changing the audit_trail parameter to false in
> init<sid>.ora.
> Bounce the database, probably by (NT) just stopping the service or (Unix)
> kill the SMON process. You will force a crash, but Oracle should recover
> from that as this is a 'power dip' only.
> Then bring it up again.
> You should be able to login now, and delete from sys.aud$ immediately.
> If you don't do that the problem will repeat itself.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Bob <meyer_b_at_my-deja.com> wrote in message
> news:7t0fcm$ht0$1_at_nnrp1.deja.com...
> > I could really use some sage advice on this one. I'm not really a DBA,
> > but I'm being asked to help solve a problem on a system that doesn't
> > really have any DBA. The person who set up their databases knew just
> > enough to be dangerous, I'm afraid, and now she's gone anyway.
> >
> > The application programmer trying to log in with a user-id that has DBA
> > priveleges. When he does, he gets the following error messages:
> >
> > Enter user-name: xxxxxxxx
> > Enter password:
> > ERROR:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM
> > ORA-02002: error while writing to audit trail
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM
> >
> > OK, this tells me the System tablespace is full, I think. I can read
> > the documentation, and it appears I need to add a new datafile to that
> > tablespace. But to do that, I need to log in as a DBA, right? And I
> > can't log in as a DBA without getting the error message. Sounds like
> > Catch-22.
> >
> > I get the same error messages trying to log into SVRMGR, too.
> >
> > Is there any solution to this paradox?
> >
> > Thanks much,
> >
> > --
> > Bob M.
> >
> > Step outside. The graphics are AMAZING!
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Sep 30 1999 - 21:22:14 CDT
