Failed to connect to database instance: ORA-02002: error writing to audit_t
65484Aug 27 2009 — edited Aug 28 2009I have a 4 node cluster and getting this alert very ferquently...
checking audit_trail gives this error
SQL> select count(*) from dba_audit_trail
2 ;
select count(*) from dba_audit_trail
*
ERROR at line 1:
ORA-01115: IO error reading block from file 1 (block # 108673)
ORA-01110: data file 1: '+DG_PROD/ngprod/datafile/system.258.665846277'
ORA-15081: failed to submit an I/O operation to a disk
Documentation on error says.........
ORA-02002: error while writing to audit trail
Cause: The auditing facility is unable to write to the AUDIT_TRAIL table. If this error occurs, SQL statements that are currently being audited may also fail. This error will occur if the SYSTEM tablespace runs out of disk space.
Action: Add space to the SYSTEM tablespace or delete rows from the AUDIT_TRAIL table. If these operations fail or do not eliminate the problem, shut down and restart Oracle with auditing disabled. This is done by setting the initialization parameter AUDIT_TRAIL to FALSE.
How should I check the system tablespaces ...I'm getting the error....and moreover they are autoextendible....Any idea about the issue