ORA-00604   01653   02002 aud$ system

環(huán)境描述：

redhat6.4 64位+oracle 11.2.0.4 RAC

問(wèn)題描述：前兩天臨時(shí)接到通知，說(shuō)數(shù)據(jù)庫(kù)出問(wèn)題，讓我和誰(shuí)誰(shuí)聯(lián)系。后面連接上數(shù)據(jù)庫(kù)發(fā)現(xiàn)集群服務(wù)是正常的，數(shù)據(jù)庫(kù)也是OPEN狀態(tài),本地也能正常訪問(wèn)，頓時(shí)松了一口氣，接著跟業(yè)務(wù)方聯(lián)系了解一下，發(fā)現(xiàn)是應(yīng)用程序連接數(shù)據(jù)庫(kù)報(bào)unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM，通過(guò)sqlplus user/passowrd@service_name錯(cuò)誤信息如下：

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

上面的錯(cuò)誤信息很明顯了

解決方式：

    1、給表空間增加數(shù)據(jù)文件

    alter tablespace system add datafile '+DATA' size 500M

    2、刪除aud$表中的數(shù)據(jù)

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

    truncate table aud$

    3、 更改aud$表所用表空間

    alter table aud$ move tablespace tablespace_name

    4、修改audit_trail參數(shù)    

    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

此次是采用第一種方式，給表空間增加數(shù)據(jù)文件。后面再來(lái)處理aud$中的數(shù)據(jù)