环境:win2003server+oracle9i 错误描述:ora-01092:oracle instance terminated. Disconnection forcedalert.log中的内容:
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Mar 15 16:42:57 2010
alter database open
Mon Mar 15 16:42:57 2010
Beginning crash recovery of 1 threads
Mon Mar 15 16:42:57 2010
Started first pass scan
Mon Mar 15 16:42:58 2010
Completed first pass scan
3 redo blocks read, 0 data blocks need recovery
Mon Mar 15 16:42:58 2010
Started recovery at
Thread 1: logseq 11, block 2, scn 0.60873276
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO02.LOG
Mon Mar 15 16:42:58 2010
Ended recovery at
Thread 1: logseq 11, block 5, scn 0.60893279
0 data blocks read, 0 data blocks written, 3 redo blocks read
Crash recovery completed successfully
Mon Mar 15 16:42:58 2010
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 3 seq# 12 mem# 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Successful open of redo thread 1.
Mon Mar 15 16:42:58 2010
SMON: enabling cache recovery
Mon Mar 15 16:42:58 2010
Errors in file d:\oracle\admin\oracle9i\udump\oracle9i_ora_2268.trc:
ORA-00600: internal error code, arguments: [4194], [34], [14], [], [], [], [], []Mon Mar 15 16:42:58 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Mon Mar 15 16:42:59 2010
Errors in file d:\oracle\admin\oracle9i\udump\oracle9i_ora_2268.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [34], [14], [], [], [], [], []Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 2268
ORA-1092 signalled during: alter database open ...
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Mar 15 16:42:57 2010
alter database open
Mon Mar 15 16:42:57 2010
Beginning crash recovery of 1 threads
Mon Mar 15 16:42:57 2010
Started first pass scan
Mon Mar 15 16:42:58 2010
Completed first pass scan
3 redo blocks read, 0 data blocks need recovery
Mon Mar 15 16:42:58 2010
Started recovery at
Thread 1: logseq 11, block 2, scn 0.60873276
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO02.LOG
Mon Mar 15 16:42:58 2010
Ended recovery at
Thread 1: logseq 11, block 5, scn 0.60893279
0 data blocks read, 0 data blocks written, 3 redo blocks read
Crash recovery completed successfully
Mon Mar 15 16:42:58 2010
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 3 seq# 12 mem# 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Successful open of redo thread 1.
Mon Mar 15 16:42:58 2010
SMON: enabling cache recovery
Mon Mar 15 16:42:58 2010
Errors in file d:\oracle\admin\oracle9i\udump\oracle9i_ora_2268.trc:
ORA-00600: internal error code, arguments: [4194], [34], [14], [], [], [], [], []Mon Mar 15 16:42:58 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORA92\ORACLE9I\REDO03.LOG
Mon Mar 15 16:42:59 2010
Errors in file d:\oracle\admin\oracle9i\udump\oracle9i_ora_2268.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [34], [14], [], [], [], [], []Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 2268
ORA-1092 signalled during: alter database open ...
解决方案 »
- 怎样禁用某一个角色
- ASP+ORACLE 移植问题,Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
- 在线等。菜鸟求救 ORACLE 正确的SQL语句!!!
- 建视图
- 存储过程问题,如何定义两个游标
- 第一次用Oracle,用PLSQL-Dev连接服务器时提示:监视器无法连接描述符中的SID.如何解决?
- 哪里可以下载ORACLE9i
- 在哪下载oracle.jdbc.driver.OracleDriver驱动程序
- 忘记Oracle的密码了,怎么办?
- 在触发器中使用 execute immediate sql_str 出错啦,帮我看看吧!
- 写一个程序,比较ORACLE和SQL SERVER 2005中的表结构
- java调用oracle复杂类型!!非常复杂~
http://forum.eviloctal.com/thread-19675-1-1.html
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716