Shulou(Shulou.com)06/01 Report--

Environment description:

Redhat6.4 64 bit + oracle 11.2.0.4 RAC

Problem description: two days ago, I received a temporary notice that there was something wrong with the database and asked me to contact someone. After connecting to the database, it is found that the cluster service is normal, and the database is also in OPEN status, and it can also be accessed locally. I was immediately relieved, and then contacted the business side to find out that the application connected to the database reported unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM. The error message through sqlplus user/passowrd@service_name is as follows:

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

The error message above is obvious.

Solution:

1. Add data files to the tablespace

Alter tablespace system add datafile'+ DATA' size 500m

2. Delete the data in the aud$ table

Select bytes/1024/1024 from dba_segments where segment_name='AUD$'

Truncate table aud$

3. Change the tablespace used by the aud$ table

Alter table aud$ move tablespace tablespace_name

4. Modify audit_trail parameters

Alter system set audit_trail='none' scope=spfile

Invalid value for parameter audit_trail, must be from among extended, xml, db_extended, false, true, none, os, db

This is the first way to add data files to the tablespace. We will deal with the data in aud$ later.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.