Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't connect - need help

Re: Can't connect - need help

From: Randy Harris <randy.harris_at_nospam.net>
Date: Fri, 15 Nov 2002 22:57:16 GMT
Message-ID: <gZeB9.458$4j5.424962@newssvr28.news.prodigy.com>


Sybrand, thanks so much. I was unable to connect to the database to resize the SYSTEM tablespace. Shutting off the audit_trail, as you suggested, did the trick. I have since truncated the table and resized SYSTEM.

You really helped me out.
Randy Harris

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:96katu4rtda1dhumimkc7kpqjgcep2jsdf_at_4ax.com...
> On Fri, 15 Nov 2002 19:55:20 GMT, "Randy Harris"
> <randy.harris_at_nospam.net> wrote:
>
> >All of a sudden I can't get connected to the database with sqlplus (or
> >anything else). I am getting this error message:
> >
> >ORA-00604: error occurred at recursive SQL level 1
> >ORA-01653: unable to extend table SYS.AUD$ by 41 in tablespace SYSTEM
> >
> >What should I do?
>
>
> You have enabled auditing (audit_trail in init.ora = db) ad you can't
> extend the table SYS.AUD$ anymore because you don't have sufficient
> contiguous space.
> As an interim measure you can either
> - resize the tablespace (on 7.3.3 and higher: Alter database datafile
> <datafile of the SYSTEM tablespace [select file_name from
> dba_data_files where tablespace_name = 'SYSTEM') <newsize>
> Maybe you should do that anyway
> - disable audit (either audit_trail = none and bounce the database or
> NOAUDIT CONNECT | session (whatever you enabled)
>
> Depending on your auditing requirements ,you should move SYS.AUD$ to a
> a different tablespace and/or clean it up or truncate it.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Nov 15 2002 - 16:57:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US