Oracle 11g启动报ORA-28056、OS 1502错误
来源:互联网 发布:mysql免安装版 编辑:程序博客网 时间:2024/05/21 09:14
C:\>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 13 22:49:08 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-28056: Writing audit records to Windows Event Log failedOSD-159172279: Message 159172279 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????ORA-28056: Writing audit records to Windows Event Log failedOSD-159172279: Message 159172279 not found; product=RDBMS; facility=SOSDO/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.
- Oracle 11g启动报ORA-28056、OS 1502错误
- Oracle 11g启动数据库报错ora-00845
- ORACLE 11G导入数据报ORA-12154错误解析
- Oracle 10g启动后报ORA-16038错误的解决方法
- oracle adg 启动报ORA-03113错误
- oracle 11g不能启动dbca,报如下错误
- 解决连接oracle 11g报ORA-01034和ORA-27101的错误
- 解决连接Oracle 11g报ORA-01034和ORA-27101的错误
- Oracle 10g 报ORA-12514错误 测试可行
- Oracle 11g参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101,ORA-00824]
- oracle 11g ORA-00845错误解决
- oracle 11g ora-03113错误
- Oracle 11g ORA-12560错误
- OWB错误集锦——OWB 11g创建Oracle模块编辑Location报ORA-00933
- Oracle 11g RAC操作DBCA期间报ORA-04031错误
- 64位 linux 中 oracle 11g dbca 报 ora-27102 out of memory 错误
- 关于oracle 11g导出数据时 报 ORA 1455错误的处理
- 11g oracle 用户密码过期问题 一开始报 ora-12560 tns协议适配器错误
- mysql文件导入总结
- 栈操作包括入栈,出栈,清空栈,销毁栈等
- 关闭Zend Framework模板自动分发
- C#学习笔记----第三周(数组、递归、对象)(1)
- 十道海量数据处理面试题与十个方法大总结
- Oracle 11g启动报ORA-28056、OS 1502错误
- QT里的函数void Q_INIT_RESOURCE ( name )
- Android原创游戏之“诈金花”(一)
- 教你如何迅速秒杀掉:99%的海量数据处理面试题
- 消除使用activityGroup时, 子Activity的上黑边框
- [学习笔记] R1的配置,R2的配置,R3的配置
- 可变大小区(Variable-Size Extents)
- 字符串移动(字符串为*号和26个字母的任意组合,把*号都移动到最左侧,把字母移到最右侧并保持相对顺序不变),要求时间和空间复杂度最小
- 完全二叉树,n到m的属于n的子树上的节点