Tag Archives: ORA-600

数据字典不一致造成大量ORA-600和ORA-7445错误

Posted on 2012/03/23 by yangtingkun

测试环境中，由于将数据字典表错误的导入到当前的数据库SYS用户下，导致数据字典出现了不一致的状态，反应出来的结果就是大量的ORA-600和ORA-7445错误。 列几个错误信息，简单记录一下这个问题： Fri Feb 10 16:30:14 CST 2012 Errors IN file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_8690.trc: ORA-00600: internal error code, arguments: [16201], [1403], [], [], [], [], [], [] Fri Feb 10 16:30:16 CST 2012 Errors IN file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_8690.trc: ORA-00600: internal error code, arguments: … Continue reading →

Posted in ORACLE | Tagged , , , , , , , | Leave a comment

ORA-600(19004)错误

Posted on 2012/03/15 by yangtingkun

客户数据库出现ORA-600(19004)错误。 错误信息如下： ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [] 对应的详细TRACE为： *** 2012-03-15 13:10:31.283 ksedmp: internal OR fatal error ORA-00600: internal error code, … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kzdugt)错误

Posted on 2012/03/14 by yangtingkun

创建用户时产生ORA-600(kzdugt)错误。 错误信息为： Mon Mar 12 12:06:58 CST 2012 Errors IN file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_22193.trc: ORA-00600: internal error code, arguments: [kzdugt], [], [], [], [], [], [], []Mon Mar 12 12:06:58 CST 2012 Errors in file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_22193.trc: ORA-00600: internal error code, arguments: [kzdugt], … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

分配LOB空间失败导致ORA-600(kddummy_blkchk)错误

Posted on 2012/03/13 by yangtingkun

测试环境发现一个ORA-600错误，简单重现了一下。 错误信息如下： Fri Mar 2 23:28:49 2012 Corrupt Block Found TSN = 4, TSNAME = USERS RFN = 4, BLK = 395, RDBA = 16777611 OBJN = 0, OBJD = 53647, OBJECT = /6ee738c_AccessorUtilities, SUBOBJECT = SEGMENT OWNER = PUBLIC, … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

删除表空间报错ORA-600(ktssdrp1)错误

Posted on 2012/03/12 by yangtingkun

测试环境的新建表空间在删除时报错。 数据库创建一个新的表空间后执行删除，出现了ORA-600的错误信息： SQL> SELECT tablespace_name FROM dba_tablespaces; TABLESPACE_NAME —————————— SYSTEM UNDOTBS SYSAUX TEMP TBS_1 GGX USERS PERFSTAT STATSPACK ALA_TEST 10 ROWS selected. SQL> DROP tablespace ala_test including contents AND datafiles; DROP tablespace ala_test including contents AND datafiles * ERROR at … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-600(2758)错误

Posted on 2012/03/05 by yangtingkun

客户数据库异常DOWN机，在启动过程中出现了这个错误。 由于掉电导致了客户数据库出现了控制文件的不一致，尝试启动报错如下： SQL> startup ORACLE instance started. Total System Global Area 126950956 bytes Fixed SIZE 454188 bytes Variable SIZE 92274688 bytes DATABASE Buffers 33554432 bytes Redo Buffers 667648 bytes * ORA-00214: controlfile ‘D:\ORACLE\ORADATA\SXXHDTS\CONTROL03.CTL’ version 2623 inconsistent WITH file ‘D:\ORACLE\ORADATA\SXXHDTS\CONTROL02.CTL’ version … Continue reading →

Posted in ORACLE | Tagged , , , , , , , , , | Leave a comment

缺少归档导致不完整恢复

Posted on 2012/03/04 by yangtingkun

简单介绍一次客户由于缺少归档造成数据丢失的案例。 分享一个案例：客户的一个测试数据库要迁移到另一台服务器上，客户DBA在将数据库备份到带库后，对原数据库服务器进行了格式化。 当DBA在目标服务器上进行数据库的恢复时发现了问题。数据库的备份虽然成功完成，但是随后的归档日志的备份由于报错失败了。现在只有一个全库的热备份，而没有任何归档日志的备份。目前已经不是丢失数据的问题了，而是缺少一致性的备份，数据库根本无法打开。 当然这个案例的恢复对于我们来说不算什么困难的事情，全库恢复后，直接RECOVER UNTIL CANCEL，尝试直接OPEN RESETLOGS，会出现错误： SQL> conn / AS sysdba Connected. SQL> ALTER DATABASE OPEN READ ONLY; ALTER DATABASE OPEN READ ONLY * ERROR at line 1: ORA-16004: backup DATABASE requires recovery ORA-01152: file 1 was NOT restored … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-600(krhpfh_03)错误

Posted on 2012/03/03 by yangtingkun

测试服务器上出现这个错误信息。 这个错误是发生在表空间OFFLINE的时候： 2012-01-07 00:42:13.026000 +08:00 CREATE tablespace test datafile SIZE 10m 2012-01-07 00:42:15.619000 +08:00 Completed: CREATE tablespace test datafile SIZE 10m 2012-01-07 00:46:25.448000 +08:00 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_smon_13951.trc: ORA-01116: error IN opening DATABASE file 5 ORA-01110: DATA file 5: ‘/u01/app/oracle/oradata/ORCL/datafile/o1_mf_test_7jg93510_.dbf’ … Continue reading →

Posted in ORACLE | Tagged , , , , , , , , , , , | Leave a comment

修改数据字典表导致ORA-600(ktecgsc:kcbz_objdchk)错误

Posted on 2012/03/02 by yangtingkun

公司的测试服务环境被整崩溃了，简单记录一下错误。 同事发现一个测试数据库无法登录，对数据库执行SHUTDOWN ABORT后，重新启动bootstrap报错： [ora11g@hpserver2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 4 00:37:58 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global … Continue reading →

Posted in ORACLE | Tagged , , , , , , , | Leave a comment

ORA-600(kjrpar:noalloc)错误

Posted on 2012/02/29 by yangtingkun

由于ORA-4031引发的ORA-600错误。 告警日志中错误如下： Sat Jan 28 06:07:49 2012 Errors IN file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc: ORA-12012: error ON auto EXECUTE OF job 66 ORA-04031: unable TO allocate 6592 bytes OF shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP") Sat Jan 28 06:08:15 2012 Errors IN file … Continue reading →

Posted in BUG | Tagged , , , , , | 1 Comment