Re: HELP! out of space in System tablespace

A copy of this was sent to Bob <meyer_b_at_my-deja.com> (if that email address didn't require changing) On Thu, 30 Sep 1999 19:58:23 GMT, you wrote:

>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.
>

if you connect internal or as sys -- you won't be audited. That way -- you can either

• add space to the SYSTEM tablespace or...
• truncate the sys.aud$ table (if you don't care about the auditing information that is in there)

>I get the same error messages trying to log into SVRMGR, too.
>
>Is there any solution to this paradox?
>
>Thanks much,

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 30 1999 - 15:36:15 CDT