ORA-09817: Write to audit file failed solution

Connect to ORacleError:ORA-09817: Write to audit file failed.

 

[Oracle @ qs-dmm-rh1 dave] $ sqlplus sys/oracle as sysdba;

SQL * Plus: Release 10.2.0.4.0-Production on Thu Mar 17 16:35:02 2011

Copyright (c) 1982,200 7, Oracle.All Rights Reserved.

 

ERROR:

ORA-09817: Write to audit file failed.

--This error is basically because the disk space is full.

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

 

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

 

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus

[Oracle @ qs-dmm-rh1 dave] $ oerr ora 9817

09817,000 00, "Write to audit file failed ."

// * Cause:ORACLE was unable to write an entry to the file used as

//Audit trail.

// * Action: Check the UNIX error number for a possible operating system error.

//If there is no error, contact Oracle Support Services.

[Oracle @ qs-dmm-rh1 dave] $ df-lh

FilesystemSizeUsed Avail Use % Mounted on

/Dev/sda313G12G136 K 100%/

/Dev/sda199 M12 M83 M12%/boot

Tmpfs506 M0506 M0%/dev/shm

[Oracle @ qs-dmm-rh1 dave] $

 

 

After deleting some files:

 

[Oracle @ qs-dmm-rh1 u01] $ df-lh

FilesystemSizeUsed Avail Use % Mounted on

/Dev/sda313G9.1 GB2.8 GB77%/

/Dev/sda199 M12 M83 M12%/boot

Tmpfs506 M0506 M0%/dev/shm

 

The connection is normal again:

 

[Oracle @ qs-dmm-rh1 u01] $ sqlplus/as sysdba;

SQL * Plus: Release 10.2.0.4.0-Production on Thu Mar 17 17:06:43 2011

 

Copyright (c) 1982,200 7, Oracle.All Rights Reserved.

 

Connected:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> select open_mode from v $ database;

 

OPEN_MODE

----------

MOUNTED