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.
---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.