数据库登录的时候报错:
ora-01034 oracle not available
ora-27101 shared memory realm does not exist
从网上找到的方法试了
sqlplus /nolog
connect / as sysdba
startup
可是还是不行,启动是成功了,然后过一会就会报alert里面文字太多,黏贴一部分内容,如果有需要继续传,高手帮帮忙哈,着急~~~
Mon Jul 29 10:16:46 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jul 29 10:16:46 2013
ALTER DATABASE OPEN
Mon Jul 29 10:16:47 2013
Beginning crash recovery of 1 threads
Mon Jul 29 10:16:47 2013
Started first pass scan
Mon Jul 29 10:16:47 2013
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Mon Jul 29 10:16:47 2013
Started recovery at
Thread 1: logseq 297, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 297 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO02.LOG
Mon Jul 29 10:16:47 2013
Ended recovery at
Thread 1: logseq 297, block 5, scn 0.58690729
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Mon Jul 29 10:16:47 2013
Thread 1 advanced to log sequence 298
Thread 1 opened at log sequence 298
Current log# 3 seq# 298 mem# 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Successful open of redo thread 1.
Mon Jul 29 10:16:47 2013
SMON: enabling cache recovery
Mon Jul 29 10:16:47 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00600: 内部错误代码,参数: [4193], [44], [50], [], [], [], [], []Mon Jul 29 10:16:48 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Mon Jul 29 10:16:49 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4193], [44], [50], [], [], [], [], []Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1440
ORA-1092 signalled during: ALTER DATABASE OPEN...alert里面文字太多,黏贴一部分内容,如果有需要继续传,高手帮帮忙哈,着急~~~
Oracle数据库
ora-01034 oracle not available
ora-27101 shared memory realm does not exist
从网上找到的方法试了
sqlplus /nolog
connect / as sysdba
startup
可是还是不行,启动是成功了,然后过一会就会报alert里面文字太多,黏贴一部分内容,如果有需要继续传,高手帮帮忙哈,着急~~~
Mon Jul 29 10:16:46 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jul 29 10:16:46 2013
ALTER DATABASE OPEN
Mon Jul 29 10:16:47 2013
Beginning crash recovery of 1 threads
Mon Jul 29 10:16:47 2013
Started first pass scan
Mon Jul 29 10:16:47 2013
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Mon Jul 29 10:16:47 2013
Started recovery at
Thread 1: logseq 297, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 297 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO02.LOG
Mon Jul 29 10:16:47 2013
Ended recovery at
Thread 1: logseq 297, block 5, scn 0.58690729
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Mon Jul 29 10:16:47 2013
Thread 1 advanced to log sequence 298
Thread 1 opened at log sequence 298
Current log# 3 seq# 298 mem# 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Successful open of redo thread 1.
Mon Jul 29 10:16:47 2013
SMON: enabling cache recovery
Mon Jul 29 10:16:47 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00600: 内部错误代码,参数: [4193], [44], [50], [], [], [], [], []Mon Jul 29 10:16:48 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Mon Jul 29 10:16:49 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4193], [44], [50], [], [], [], [], []Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1440
ORA-1092 signalled during: ALTER DATABASE OPEN...alert里面文字太多,黏贴一部分内容,如果有需要继续传,高手帮帮忙哈,着急~~~
Oracle数据库
ORA-00600 [4193] 错误提示 貌似是undo坏了ORA-00600: [4193]
将 alter system set undo_management=manual scope=spfile;打开后执行ddl还会报错ORA-00600: [4193]
删除原undo表空间并将undo_management改回auto 后正常
alter system set undo_management=auto scope=spfile;
alter system set undo_tablespace=undo2 scope=spfile;
shutdown immediate;
startup;ORA-01092: ORACLE instance terminated. Disconnection forced
启动数据库到mount状态
SQL> startup mount
可以看到,数据库没有CRASH.现在我们CLEAR GROUP4,先用alter database clear logfile group 4;(如果不行就用alter database clear unarchived logfile group 4;):
SQL> alter database clear logfile group 4;
数据库已更改。
SQL> alter database open;
数据库已更改.