ORA-00257 archiver error Connect internal only, until freed

Issue: ORA-00257 archiver error Connect internal only, until freed

This could be caused by due to archiver background process unable to write logs in archivelog destination because of archive destination is full. Until free make free size on archive destination database will not allow any transactions.

Using rman tool we can free the archive destination is the best way.

connect to the target machine
rman target /

rman>crosscheck archivelog all;
rman> delete noprompt obsolete;
rman> delete noprompt expired archivelog all; or
rman> delete archivelog all before 'sysdate-1'; or
rman> delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-1';

It will delete all the obsolate archivelogs from the archivelog location before present day.

Writing audit records to Windows Event log failed ORA-28056

Issue: Writing audit records to Windows Event log failed ORA-28056


I have faced this error while installation of Oracle 11.2.0.3 in Window Server 2008.

To Solve this issue

Click start>control panel>administrative tools> Double click on Event Viewer.

Clear all the event logs. Then continue the installation process.

This issue might get oracle startup time also,

SQL> conn /as sysdba;

ERROR: ORA-28056: Writing audit records to Windows Event Log failed
ORA-01031: insufficient privileges

At that time also follow the above steps.