Tag Archives: ORA-1110

ORA-600(KSSRMP2)错误

客户的Oracle 10.1.0.4环境碰到这个错误。 详细错误信息为: Wed DEC 14 21:10:27 2005 Errors IN file /oracle/admin/ocrl/bdump/ocrl_smon_160060.trc: ORA-00600: internal error code, arguments: [KSSRMP2], [0x1102F0128], [0], [0], [], [], [], [] ORA-01157: cannot identify/LOCK DATA file 201 – see DBWR trace file ORA-01110: DATA file 201: … Continue reading

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

分区表部分分区不可用导致统计信息收集失效

一个客户碰到的具体需求,分区表中有些分区所在的表空间被OFFLINE,导致在删除统计信息时报错。 下面通过例子来说明这个问题: SQL> CREATE TABLE t_part_read (id NUMBER) 2 partition BY range (id) 3 (partition p1 VALUES less than (10) tablespace ts1, 4 partition p2 VALUES less than (20) tablespace ts2, 5 partition pmax VALUES less than (maxvalue) tablespace users); … Continue reading

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

ORA-600(krhpfh_03)错误

测试服务器上出现这个错误信息。 这个错误是发生在表空间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-1251和ORA-600(kjccgmb:l)错误

客户的数据库出现了ORA-1251错误,进而引发了ORA-600(kjccgmb:l)错误。 数据库版本是9208 RAC for Linux X86-64。客户数据库一个数据文件突然不可用,被置为OFFLINE状态: ORA-01171: datafile 44 going offline due TO error advancing checkpoint ORA-01122: DATABASE file 44 failed verification CHECK ORA-01110: DATA file 44: ‘/dev/raw/raw77’ ORA-01251: UNKNOWN File Header Version READ FOR file NUMBER 44ORA-01171: datafile 44 … Continue reading

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

DATA GUARD出现ORA-26040错误

客户在搭建好的DATA GUARD环境出现了ORA-26040错误。 在备库只读打开时,出现了下面的错误: ORA-12801: error signaled IN parallel query server P000 ORA-01578: ORACLE DATA block corrupted (file # 75, block # 1046445) ORA-01110: DATA file 75: ‘/oradata2/accdb/a_txn_data09.dbf’ ORA-26040: DATA block was loaded USING the NOLOGGING OPTION ORA-12801: error signaled IN … Continue reading

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