Re: Can't connect - need help

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