Sunday 23 February 2014

ORA-09817: Write to audit file failed. ORA-09945: Unable to initialize the audit trail file

SQL> startup

 ---it show this error
 ORA-09817: Write to audit file failed.
 Linux-x86_64 Error: 28: No space left on device
 ORA-09945: Unable to initialize the audit trail file


Why :=
 ============

 its because of full the Mount point where Oracle is installed .
 your audit_trail_dest or audit trail destination is full for generation of audit file.

 you can do :-
 ==============


 1) check the space of mount point. like below.....
 $ df -k

 2) move the audit_file_dest parameter to another mount point
 using below command:
 alter system set audit_file_dest='new mount point /u02 /u03'
 scope=spfile;

 then restart the database but you need to make sure that there enough space on server before restart.

 or

 3) delete some unnecessary trace file or something from that fulled mount point.
 then try to start the oracle database.

 it is advisable, backup the files before they are delete since they might be useful in future.