In this post , we explain how to solve database new connections failure due to oracle audit trail filling hosted on a Linux OS.
Oracle Error
When trying to connect to database , below SQL errors are generated.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
Solution
Login as oracle or any SQL privilege user.su - oracle
export ORACLE_SID=ORAINST
export ORACLE_HOME=/usr/oracle/product/11.2.0/dbhome_1
(Note - ORACLE_HOME=/usr/oracle/product/11.2.0/dbhome_1 , / at last not to be used )
sqlplus /nolog
connect /as sysdba
truncate table SYS.AUD$;
Once the above audit table is cleared , new DB connections should be possible. Consult your DBA administrator and get a scheduler to clear such logs periodically.
Hope this helps to some geeks.