Re: Can't connect - need help

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 - 13:58:00 CST