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

If you get "ORA-28056: Writing audit records to Windows Event Log failed" error while connecting with Oracle Database 11g which was installed on Windows Server 2003, you can try following method to resolve the issue.

Open command prompt and try to connect with SYS privileges.

Go to START > RUN > type CMD and press Enter

C:\>sqlplus /nolog

SQL*Plus: Release Production on Fri Jan 23 13:40:09 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> conn / as sysdba

ORA-28056: Writing audit records to Windows Event Log failed
OSD-197314968: Message 197314968 not found;  product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) The event log file is full.
ORA-01075: you are currently logged on

Cause of Problem:

The problem was occurred because Event Viewer log was full and not been able to log anymore events.

Solution of the Problem:

You need to free the event viewer log.

How to free event viewer log?


First login to your Server machine as an Administrator.


Now Click on START > Go to Control Panel > Performance and Maintenance > Administrative Tools and Click on Event Viewer.


As the Event Log is full and unable to record new events, clear the logs by just right clicking on the Application/System/Security on the left side and select Clear All Events. It will ask you to save the events, if you want to save then click on Yes otherwise choose No option.

ORA-28056 Writing audit records to Windows Event Log failed-01


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

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

ORA-28056 Writing audit records to Windows Event Log failed-01

You can share your feedbacks in comment section.

Subscribe to get free tech advice, tips and in-depth articles.

Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.

Leave a Reply

Your email address will not be published. Required fields are marked *