-
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
Category Archives: ORACLE
统计信息收集出现DFS等待导致实例HANG死
客户10.2.0.4 RAC环境，出现大量的library cache lock和cursor: pin S wait on X等待，经分析是由于统计信息收集僵死导致的。 数据库在8点到9点期间，数据库两个节点都存在明显的cursor: pin S wait on X和library cache lock的等待： Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class cursor: pin S wait on X 1,573,056 30,651 … Continue reading
Posted in BUG
Tagged cursor: pin S wait on X, DBF lock handle, DBMS_STATS, library cache lock, RAC
Leave a comment
ORA-600(kposcws-2)错误
客户11.2.0.2 RAC环境出现ORA-600[kposcws-2]错误。 错误信息为： Thu Sep 27 10:48:15 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_34145026.trc (incident=682292): ORA-00600: 内部错误代码, 参数: [kposcws-2], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_682292/orcl1_ora_34145026_i682292.trcThu Sep 27 10:48:15 2012 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_34145026.trc … Continue reading
ORA-600(kollasg:client-side tmp lob)错误
客户11.2.0.3 RAC环境，出现ORA-600[kollasg:client-side tmp lob]错误。 错误信息为： Thu Apr 28 20:54:53 2011 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_31916032.trc (incident=148665): ORA-00600: 内部错误代码, 参数: [kollasg:client-side tmp lob], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_148665/orcl1_ora_31916032_i148665.trc Thu Apr 28 20:54:59 … Continue reading
ORA-600(ksxp_rm_check0)错误
客户11.2.0.3 RAC的ASM实例出现ORA-600[ksxp_rm_check0]错误。 错误信息如下： Tue Jul 02 19:22:59 2013 Errors IN file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_6488960.trc (incident=165804): ORA-04031: unable TO allocate 3000 bytes OF shared memory ("shared pool","select INSTANCE_NUMBER , IN…","sga heap(1,0)","call") USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 … Continue reading
Posted in BUG
Tagged ASM, ksxp_rm_check0, memory_target, ORA-4031, ORA-600, PROCESSES, RAC, sga heap, shared pool
Leave a comment
11.2.0.3 ASM实例出现ORA-4031导致数据库归档失败
客户的11.2.0.3 RAC数据库出现了归档失败的情况，导致单个实例出现HANG死的状况。 检查错误信息发现： Tue Jul 02 16:49:13 2013 ARC1: Error 19504 Creating archive log file TO ‘+DATA02’ ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance orcl1 – Archival Error ORA-16038: log 14 SEQUENCE# 68244 cannot be archived ORA-19504: … Continue reading
ORA-7445(ptmax)错误
一个9.2.0.8上的bug。 虽然12c已经发布，但是仍然有部分客户的核心数据库还跑在9i环境上，有碰到了一个9208上的bug。 Thu May 16 14:18:48 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_11922.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT mapped TO object] [0x000000010] [] [] Thu May 16 14:19:49 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_12389.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT … Continue reading
ORA-600(ktsfbfmt:objdchk_kcbnew_3)错误
客户的11.2.0.3 RAC环境出现ORA-600[ktsfbfmt:objdchk_kcbnew_3]错误。 错误信息为： Sat May 18 01:37:23 2013 Errors IN file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j009_13090.trc (incident=1002558): ORA-00600: 内部错误代码, 参数: [ktsfbfmt:objdchk_kcbnew_3], [3], [5370496], [0], [], [], [], [], [], [], [], [] Incident details IN: /oracle/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_1002558/orcl1_j009_13090_i1002558.trc USE ADRCI OR Support Workbench TO package the … Continue reading
ORA-600(kcbchg1_12)和ORA-600(kdifind:kcbget_24)错误
客户11.2.0.3 RAC for Aix上出现的错误。 在客户环境中，上述两个错误都出现了： Sun May 19 01:20:41 2013 Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j003_32468.trc (incident=1002135): ORA-00600: 内部错误代码, 参数: [kdifind:kcbget_24], [5296768], [1], [0], [1], [], [], [], [], [], [], [] ORA-06512: 在 “CP_TMS.TMP_P_TMS_MAIL_AGENCY_OUT”, line 386 ORA-06512: 在 line 2 Incident … Continue reading
Posted in BUG
Tagged kcbchg1_12, kdifind:kcbget_24, ORA-600, _db_file_no_contig_mblock_read_count
Leave a comment
Logminer获取UNKNOWN的USERNAME
客户反馈尝试通过LOGMINER获取USERNAME和PROGRAM信息，但是即使打开了SUPPLEMENTAL LOG，仍然到得UNKNOWN的结果。 查询了MOS文档，果然找到了一个对应的BUG：Some Column Values Change To UNKNOWN Or NULL When Querying V$LOGMNR_CONTENTS [ID 1307497.1]。 当在START_LOGMINER的时候指定了START_SCN并在OPTIONS中指定了DDL_DICT_TRACKING时，查询V$LOGMNR_CONTENTS视图，第一次访问可以得到正确的USERNAME、MACHINE_NAME、OS_USERNAME、SESSION_INFO等信息，但是再次查询上述列会变成NULL或者UNKNOWN。 这个BUG影响版本从10.2.0.4到11.2.0.2，在11.2.0.3中被FIXED，Oracle还提供了单独了PATCH 10129774来解决这个问题。不过其实最简单避免这个错误的方法就是在START_LOGMINER后，通过CREAT TABLE的方式将V$LOGMNR_CONTENTS视图的内容保留下来，这其实也可以避免多次扫描V$LOGMNR_CONTENTS视图造成后台进行多次的日志挖掘。
Posted in BUG
Tagged DDL_DICT_TRACKING, logminer, MACHINE_NAME, NULL, OS_USERNAME, SESSION_INFO, START_SCN, UNKNOWN, USERNAME, V$LOGMNR_CONTENTS
Leave a comment
私有网络接口丢失导致实例崩溃
客户10.2.0.4 RAC数据库出现网络异常，导致实例崩溃并伴随大量ORA-27300错误。 详细错误信息为： Wed Nov 21 16:37:36 2012 Errors IN file /u01/oracle/app/admin/orcl/udump/orcl2_ora_29173.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:if_not_found failed WITH STATUS: 0 ORA-27301: OS failure message: Error … Continue reading
Posted in ORACLE
Tagged if_not_found, KGXGN, ORA-15064, ORA-27300, ORA-27301, ORA-27302, ORA-27303, ORA-27504, ORA-29702, ora-3113, ORA-603, skgxpvaddr9
Leave a comment