Ora-01653: unable to extend table SYS. AUD $ by 8192 in tablespac System

Source: Internet
Author: User

Ora-01653: unable to extend table SYS. AUD $ by 8192 in tablespac system [Reproduced].

the following error was reported when logging on to the database with sqlplus user/[email protected]:
ORA-00604: Error occurred at recursive SQL Level 1
ORA-01653: unable to extend table sys. AUD $ by 8192 in tablespace System
ORA-02002: Error while writing to audit trail
ORA-00604: Error occurred at recursive SQL Level 1
ORA-01653: unable to extend table sys. AUD $ by 8192 in tablespace System
ORA-00604: Error occurred at recursiv E SQL Level 1 error refers to internal SQL statement execution failure
ORA-01653: unable to extend table sys. AUD $ by 8192 in tablespace system indicates that the tablespace is full
log on to the database with sqlplus/As sysdba
first, use the following SQL statement to view the usage of the tablespace
select tablespace_name, (Bytes/1024/1024) m from dba_data_files;
the tablespace is full in two ways.
(1) Change the system tablespace data file system. DBF allocate space
alter database datafile '/u04/oradata/truth/system01.dbf' resize 5524 m;
(2) add another data file for the system tablespace
(3) Move the table in the system tablespace to the non-system tablespace
check whether there are other non-system tables in the system tablespace,
If yes, you can move it to a non-system tablespace.
alter table move tablespace tablespace_name

Oracle 11g installed the database by default and enabled the audit function, resulting in the continuous accumulation of SYS. AUD $ tables and related index data in Oracle;
If the tablespace is full, the ORA-1654: unable to extend index sys... error is reported in the Alert Log.
If you do not need the audit function, we recommend that you disable audit.
Processing Process:
1. log on to the database server as an oracle user and execute:
Sqlplus/As sysdba
2. Cancel audit and set the initialization parameter audit_trail to none.
Alter system set audit_trail = none scope = spfile;
3. Restart the database.
Shutdown immediate;
Sqlplus/As sysdba
Startup;
4. Delete audit data. oracle users log on to the database server:
Sqlplus/As sysdba
Truncate table SYS. AUD $;

Ora-01653: unable to extend table SYS. AUD $ by 8192 in tablespac System

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.