首页 / 数据库 / MySQL / ORA-00600: internal error code, arguments: [4194], [53], [41], [], [], [], [], []
真心不动了,研发的同事关测试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教程:实例故障恢复 http://www.linuxidc.com/Linux/2011-08/40857.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址