当前位置：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研究中心
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
