Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't connect to the DB due to large SYS.AUD$

flying_penguinNov 29 2011 — edited Nov 29 2011

DB Version:11.2.0.2
Platform : Solaris 10

One of DB's SYS.AUD$ table grew to 4.5 million records and then when you try to connect from outside the host server , you'll get

ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM

But, you can connect with local authentication

sqlplus / as sysdba

We took an export of this table and truncated the table. This fixed the issue.

But questions remain .

The Disk Group where the SYSTEM tablespace is stored had 14 GB free space . So, why was I getting this error?

This post has been answered by Nicolas Gasparotto on Nov 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2011

Added on Nov 29 2011

#general-database-discussions

3 comments

2,193 views