this error is showing when i am trying to start oracle database. solution is below.
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
Linux-x86_64 Error: 28: No space left on device
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
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 9877432 9500268 0 100% /
none 3932160 1736 3930424 1% /dev/shm
/dev/sdf 30963708 9434056 19956788 33% /u02
/dev/sdb 433455904 203020 411234580 1% /u03
2) 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.
you see here
5 comments:
Clear some space on DB.
i have no space at mount point. i tried to make the space by deleting the trace files and audit files from the mount point still not able to login can you suggest which other files we can delete to make the space at mount point
I have no space at mount point.i have tried to make the space by deleting the trace and audit files from the mount loaction.can you please suggest other thing to delete from the mount point to make the space.
I have no space at mount point.i have tried to make the space by deleting the trace and audit files from the mount loaction.can you please suggest other thing to delete from the mount point to make the space.
I have no space at mount point.i have tried to make the space by deleting the trace and audit files from the mount loaction.can you please suggest other thing to delete from the mount point to make the space.
Post a Comment