-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
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
分区表部分分区不可用导致统计信息收集失效
一个客户碰到的具体需求,分区表中有些分区所在的表空间被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 DBMS_STATS, granularity, lock_partition_stats, offline, ORA-1110, ora-376, partition
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
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
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