Re: HELP! out of space in System tablespace

I read in a manual that you should never turn on auditing unless you have enough room in your tablespace because you can run into this endless loop. Or set up the audit not not grow more then x and make sure x will not fill up your tablespace. The database is trying to audit your signon but can not because the tablespace is full. You can not dump the data or add to the tablespace because you can not sign on.

You might try to do an export and then import the data into a new database.

Have you tried signing on as internal in svrmgr to see if you can get somewhere?

Bob wrote in message <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 Oct 07 1999 - 04:05:28 CDT