Unable to extend table SYS.AUD$ by 128 in tablespace.SYSTEM
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
The following errors occur in the OPAC www_server, pc_server, or oclc_server logs:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace.SYSTEM
ORA-02002: error while writing audit trail
and the servers do not work.
Cause:
Oracle system auditing is turned on (This is the default in Oracle 11-up).
Resolution:
There are two possible solutions:
1. Add a datafile to the SYSTEM tablespace (via util o/13/3); or
2. Truncate the SYS.AUD$ table (and, optionally, disable auditing). Aleph doesn't need these audit records, so SYS.AUD$ can be truncated:
> su - oracle11 [this may be plain "oracle" on your server]
Password:
Execute oracle cshrc
...
oracle11@abcu(aleph20)~>sqlplus / as sysdba
sys@ALEPH20> truncate table AUD$;
**If you get a "Resource Busy" message, run $alephe_root/aleph_shutdown and restart Oracle.** Then proceed with the above steps.
If aleph_shutdown was run, run $alephe_root/aleph_startup.
The system should now be functional again.
(2b) Later, optionally, disable auditing. See KB 16384-29953 {"How to turn off (Oracle) system auditing in Aleph 20"}.
Category: System Management (500)
Subject: Oracle (500)
- Article last edited: 11/20/2013