2011年8月16日 星期二

有一段时间因为太忙而没有使用Oracle做实验，今天空闲想做几个备份恢复实验，打开数据库，提示错误信息如下：

C:Documents and SettingsBD>
C:Documents and SettingsBD>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 8月 16 14:19:52 2011

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

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

请输入用户名: system
输入口令:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
进程 ID: 0
会话 ID: 0 序列号: 0

解决办法：

网上查看相关错误信息，解决办法是清理事件查看器(运行->输入”eventvwr”)里的应用程序下的记录，然后就可以正常登陆。

Support的解决办法：

Try doing the following using Windows 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.

选中“应用程序”=》右击=>选择“清除所有事件”

然后重新连接到数据库

C:Documents and SettingsBD>
C:Documents and SettingsBD>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 8月 16 14:35:56 2011

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

已连接到空闲例程。

SQL> startup
ORACLE 例程已经启动。

Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 331350480 bytes
Database Buffers 197132288 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
数据库已经打开。
SQL>

问题解决。