Re: HELP! out of space in System tablespace

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 - 15:38:06 CDT