ORA-00600: internal error code, arguments: [4194], [53], [41
真心不动了,研发的同事关测试IBM 3650服务器是直接关插排电源???第二天加点重启之后oracle 打开报错ORA-00600: internal err
真心不动了,研发的同事关测试IBM 3650服务器是直接关插排电源???
第二天加点重启之后Oracle 打开报错ORA-00600: internal error code, arguments: [4194], [53], [41], [], [], [], [], []
求助DBA
决绝办法,启用undo手动管理,重建undo表空间
步骤如下:
SQL> alter system set undo_management=MANUAL scope=spfile;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database open;
SQL> create undo tablespace undotbs2 datafile '+data' size 16g;
SQL> alter system set undo_management=AUTO scope=spfile;
SQL> alter system set undo_tablespace=undotbs2 scope=spfile;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database open;
到此,数据库正常启动。
重建undo表空间可以避免4194事件,但数据库处于随时crash的状态,为了避免意外宕机发生,将数据全库导出在导入一个新库中。
在此再次声明运维SERVER不要认为断电关机省事,,它不是pc,pc也经不起这样折腾!!!
Oracle教程:实例故障恢复
Linux-6-64下安装Oracle 12C笔记
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
推荐阅读
-
ORA-00600: internal error code, arguments: [4194], [53], [41
-
ORA-00600: internal error code, arguments: [qkabix], [0], []
-
遭遇 ORA-00600: internal error code, arguments: [4194] ORA-155
-
ORA-00600: internal error code, arguments: [13310]
-
ORA-00600: internal error code, arguments: [13310]
-
遇到ORA-00600:internal error code,arguments:[kcblasm_1],[103],[],[],[],[]报错的解决办法
-
ORA-00600: internal error code, arguments: [evapth : unexpec
-
ORA-00600: internal error code, arguments: [4194] ,ORA-00607
-
ORA-00600 internal error code,arguments
-
ORA-00600: internal error code, arguments: [15709]