很头疼啊 求高手解决啊
4 个解决方案
#1
600錯誤一般都是oracle的bug引起的,最好找oracle support,如果沒有的話,一般很難解決。
#2
检查一些SQL 语句,然后看一下对应的dump 文件。
一般DML 不会导致这个不错。 10g和11g 对语法的支持不一样,可能会导致这种错误,以前我遇到过一次,10g的SQL 到11g 就报ora-600的错误了。
#3
SQL语句贴出来看看,有什么特别的东西
没有的话就是数据库出问题了,BUG?
没有的话就是数据库出问题了,BUG?
#4
12391183 11.2.0.3, 12.1.0.0 ORA-600 [kcbnew_3] with "_db_fast_obj_truncate"=false
11902008 12.1.0.0 SMON may crash with ORA-00600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
9456964 11.2.0.2 OERI[kcbnew_3] after shrinking an IOT and reusing the blocks freed by shrink
6970071 10.2.0.5, 11.2.0.1 ORA-600 [kcbnew_3] when recyclebin is active
6730125 10.2.0.5, 11.1.0.7, 11.2.0.1 OERI[kcbnew_3] during instance recovery
6079038 10.2.0.5, 11.2.0.1 Problems from DML with error logging / batch errors against partitioned table
5303237 11.1.0.6 ORA-600 [kcbgtcr_5] during create queue table
11902008 12.1.0.0 SMON may crash with ORA-00600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
9456964 11.2.0.2 OERI[kcbnew_3] after shrinking an IOT and reusing the blocks freed by shrink
6970071 10.2.0.5, 11.2.0.1 ORA-600 [kcbnew_3] when recyclebin is active
6730125 10.2.0.5, 11.1.0.7, 11.2.0.1 OERI[kcbnew_3] during instance recovery
6079038 10.2.0.5, 11.2.0.1 Problems from DML with error logging / batch errors against partitioned table
5303237 11.1.0.6 ORA-600 [kcbgtcr_5] during create queue table
#1
600錯誤一般都是oracle的bug引起的,最好找oracle support,如果沒有的話,一般很難解決。
#2
检查一些SQL 语句,然后看一下对应的dump 文件。
一般DML 不会导致这个不错。 10g和11g 对语法的支持不一样,可能会导致这种错误,以前我遇到过一次,10g的SQL 到11g 就报ora-600的错误了。
#3
SQL语句贴出来看看,有什么特别的东西
没有的话就是数据库出问题了,BUG?
没有的话就是数据库出问题了,BUG?
#4
12391183 11.2.0.3, 12.1.0.0 ORA-600 [kcbnew_3] with "_db_fast_obj_truncate"=false
11902008 12.1.0.0 SMON may crash with ORA-00600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
9456964 11.2.0.2 OERI[kcbnew_3] after shrinking an IOT and reusing the blocks freed by shrink
6970071 10.2.0.5, 11.2.0.1 ORA-600 [kcbnew_3] when recyclebin is active
6730125 10.2.0.5, 11.1.0.7, 11.2.0.1 OERI[kcbnew_3] during instance recovery
6079038 10.2.0.5, 11.2.0.1 Problems from DML with error logging / batch errors against partitioned table
5303237 11.1.0.6 ORA-600 [kcbgtcr_5] during create queue table
11902008 12.1.0.0 SMON may crash with ORA-00600 [kcbgcur_3] or ORA-600 [kcbnew_3] during Transaction recovery
9456964 11.2.0.2 OERI[kcbnew_3] after shrinking an IOT and reusing the blocks freed by shrink
6970071 10.2.0.5, 11.2.0.1 ORA-600 [kcbnew_3] when recyclebin is active
6730125 10.2.0.5, 11.1.0.7, 11.2.0.1 OERI[kcbnew_3] during instance recovery
6079038 10.2.0.5, 11.2.0.1 Problems from DML with error logging / batch errors against partitioned table
5303237 11.1.0.6 ORA-600 [kcbgtcr_5] during create queue table