ORA-28056: Writing audit records to Windows Event Log failed Error

Today I  examine to connect with Oracle Database 11g and got ORA-28056 error. Oracle Database was installed on my Windows Server 2003.

I just  derive the following command and got this error.

START > RUN > CMD

C:\>sqlplus /nolog

SQL*Plus:  report 11.2.0.2.0 Production on Fri Jan 26 13:09:30 2014

Copyright (c) 1982 All rights reserved, 2010, Oracle.  .

SQL> conn / as sysdba

ERROR:

ORA-28056: Writing audit records to Windows circumstance Log failed

OSD-197314968: Message 197314968 no result found;  product = RDBMS; facility = SOSD

O/S-Error: (OS 1502) The event that you log file is full.

ORA-01075: you are currently logged on

Starting of Problem:

The  trouble was occurred because Event Viewer log was full and didn't able to log anymore events.
resolution of the Problem:

You need to clear the event viewer log.

How to clear event viewer log?

Step-1:

First logged in to your computer as an Administrator.

Step-2:

Now Click START button  > Control Panel > Performance and Maintenance > Administrative Tools and     clink on Event Viewer.

Step-3:

As the Event Log is full and unable to  track new events, free the logs by just right clinking on the Application/System/Security on the left side and select Clear All Events. Now it will ask you to save the events, if you surely want to save then clink on Yes otherwise choose No.

Note:

You can also choose overwrite option under stuff of Application/System/Security, if need. It will automatically overwrite all old events to new events. You don’t require to clear the logs again and again.

There is also one more option by which you can expand the size of logs as shown in below snapshot.

This period of instruction will resolve your problem. Share this to your friends to  upgrade their knowledge too.