sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle报错ORA-28056产生原因和MOS官方解决办法

时间:2016-10-29 20:24   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:运维DBA发现Oracle数据库报错误 :ORA-28056: Writing audit records to Windows Event Log failed,结合MOS官方解决办法。

APPLIES TO:

Oracle Server – Personal Edition – Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Jul-2012***

SYMPTOMS

Connect as sysdba fails with:

ORA-28056: Writing audit records tOracleoracleplus.neto Windows Event Log failed.
CAUSE

The Event Viewer log is full and not able to log any more events.

This is addressed in unpublished
Bug 6823281 – ORA-28056 WRITING AUDIT RECORDS TO WINDOWS EVENT LOG FAILED
which was closed as not a bug.

SOLUTION

Try doing the following using Windows Event Viewer:

1. To open Event Viewer, click Start, click Control Panel, click Performance and Maintenance, click Administrative Tools, and then double-click Event Viewer.

You must be logged on as an administrator or a member of the Administrators group to free an event log.

2. Then use any of the next options:

When a log is full, it stops recording new events. Clearing the log is one way to free the log and start recording new events.
You can also free a log and start recording new events by overwriting old events. To overwrite events, on the Action menu, click Properties, and then click Overwrite events as needed. This ensures that all new events are written to the log, even when the log is full.
You can also start logging new events by increasing the maximum log size. To increase the log size, on the Action menu, click Properties, and then increase the Maximum log size.
REFERENCES

@BUG:6823281– ORA-28056: WRITING AUDIT RECORDS TO WINDOWS EVENT LOG FAILED

本文固定链接: http://www.htz.pw/2014/08/06/ora-28056-writing-audit-records-to-windows-event-log-failed.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-28056产生原因和MOS官方解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1106.html

Oracle研究中心

关键词:

ORA-28056

Oralce报错ORA-28056解决笔记

ORA-28056: Writing audit records to .... failed