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