Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlplus / as sysdba ORA-09817: Write to audit file failed.

kazyskiyn0wJan 17 2014 — edited Jan 17 2014

Hi all,

I need a help of you ASAP.

I'm having the error "ORA-09817: Write to audit file failed" after sqlplus / as sysdba .

The datafile of AUDIT is not full, it has 32GB free space.

I had shutdown database and gzip the datafiles, controlfiles and redo logs to perform a backup.

This morning when I tried to start db I have this messagem.

Strange is that when I ps -ef | grep pmon, the instance is started but I had shutdown it yesterday.

oracle   27892     1  0 09:41 ?        00:00:00 ora_pmon_DEVQA

9:41 was the time I tried to startup database this morning.

I searched MOS notes but did not find anything.

Please help to find a solution.

Thanks,

Kaz

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2014
Added on Jan 17 2014
7 comments
2,576 views