Oracle 28056错误处理
来源:互联网 发布:安卓编程入门教程pdf 编辑:程序博客网 时间:2024/05/16 17:54
ORA-28056错误处理过程:
D:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on 星期四 10月 8 20:03:50 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> conn /as sysdba
ERROR:
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1627319533: Message 1627319533 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) ??????????????????
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1627319533: Message 1627319533 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) ??????????????????
解决过程:
打开windows 事件查看器,将应用程序日志清理一下,重新连接数据库,连接成功。启动数据库,启动正常。
解决这个问题的时候经过了多次的尝试都失败了,开始想到可能是系统日志的问题了,但没想到是日志满了,最后突然想到这个问题,试了一下,成功了。
论坛上有个哥们给了个很好的回复,以下是他的回复:
回复 #1 jiayuping 的帖子
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.
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 28056错误处理
- oracle错误处理
- ORACLE 异常错误处理
- oracle异常错误处理
- oracle 异常错误处理
- ORACLE 异常错误处理
- ORACLE 异常错误处理
- ORACLE 异常错误处理
- Oracle异常错误处理
- oracle 错误处理
- Oracle错误处理机制
- oracle 异常错误处理
- ORACLE视图错误处理
- oracle存储过程错误处理
- 处理oracle没有监听器错误
- 处理oracle没有监听器错误
- Oracle-PL/SQL错误处理
- oracle ora-00054错误处理
- XML的解析器整理
- socket常用选项
- Android应用基本概念
- C# int与string相互转换
- js 关于 累加 和 变成数组 join的效率
- Oracle 28056错误处理
- spring 学习笔记五
- 关闭浏览器session就消失了吗
- 敏捷开发一千零一问系列之一:序言及解决问题的心法(无我)
- WebBrowser.ExecWB的完整实例,打印页面、页面设置、打印预览、另存为、属性等
- 代码中类和方法等字体变黑文件失去关联symbol not found 解决办法
- VC++6.0无法打开文件(转)
- String.valueOf() 方法的使用
- linux系统调用和库函数调用的区别