Tag Archives: ORA-8103

ORA-8103错误

最近碰到两次ORA-8103错误,简单总结一下。 一次是客户的10.2数据库出现了ORA-600[6002]错误,导致的问题是索引出现了逻辑损坏,本来问题很简单,只需要删除索引并重建,或者通过ONLINE REBUILD方式就可以了。但是索引删除后,扫描这张表出现了ORA-8103错误,这说明错误不仅出现在索引上,在数据块上同样存在逻辑错误,从而导致了前面的ORA-600[6002]错误。 第二个问题是11.2.0.2环境中出现的ORA-8103错误,错误发生在统计信息收集过程中: Fri Mar 30 02:00:00 2012 DBMS_STATS: GATHER_STATS_JOB encountered errors. CHECK the trace file. Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j000_25932.trc: ORA-20011: Approximate NDV failed: ORA-08103: object no longer EXISTS TRACE文件的详细信息内容为: *** 2012-03-31 14:08:25.269 *** SESSION ID:(485.61983) 2012-03-31 14:08:25.269 *** … Continue reading

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

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

公司的测试服务环境被整崩溃了,简单记录一下错误。 同事发现一个测试数据库无法登录,对数据库执行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