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錯誤，確認日誌已滿的事宜：

解決方法：

將 應用日誌 清空即可解決問題。

官方解釋：

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.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12974804/viewspace-756320/，如需轉載，請註明出處，否則將追究法律責任。