oracle提示 o/s-error,Oracle 11g启动报ORA-28056、OS 1502错误

C:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 13 22:49:08 2012

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

ERROR:

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

OSD-159172279: Message 159172279 not found;  product=RDBMS; facility=SOSD

O/S-Error: (OS 1502) ??????????????????

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

OSD-159172279: Message 159172279 not found;  product=RDBMS; facility=SOSD

O/S-Error: (OS 1502) ??????????????????

今天在启动测试服务器时，没有太多的留意直接通过业务程序登录，但怎么也无法登录。我在登录服务器尝试SQLPLUS时，系统提示以上的错误信息。

只见提示反馈信息是“Writing audit records to windows event log failed"，直觉反映应该是应用日志写满了。

通过系统命令检查OS 1502错误，确认日志已满的事宜：

C:\>net helpmsg 1502

事件日志文件已满。

解决方法：

将 应用日志 清空即可解决问题。

官方解释：

Subject: Connect As Sysdba Fails With ORA-28056

Doc ID: 784068.1 Type:  PROBLEM

Modified Date:  20-MAR-2009 Status:  MODERATED

Applies to:

Oracle Server - Personal Edition - Version: 11.1.0.6 to 11.1.0.7

This problem can occur on any platform.

Symptoms

connect as sysdba fails with:

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

Cause

Event Viewer log is full and not able to log anymore events.

Justified by 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 Event Viewer:

.

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.

.

1) 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.

.

2) 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.

.

3) 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.