-
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-4031
ORA-600(koksadqb1)错误
使用utlrp.sql编译失效对象引发的ORA-600错误。 错误信息如下: Sat DEC 19 05:29:59 2009 Completed: ALTER DATABASE OPEN Sat DEC 19 05:30:20 2009 SERVER COMPONENT id=UTLRP_BGN: TIMESTAMP=2009-12-19 05:30:20 Sat DEC 19 05:31:09 2009 Errors IN file /oraclelog/admin/orcl3/bdump/orcl31_cjq0_24952.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable … 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
ASM实例出现ORA-4031错误导致实例崩溃
数据库的ASM实例出现了ORA-4031错误,导致了数据库实例的崩溃。 详细的错误信息为: Wed Jul 25 08:03:45 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_asmb_34668994.trc (incident=808023): ORA-04031: unable TO allocate 3432 bytes OF shared memory ("shared pool","unknown object","sga heap(1,0)","ASM file") Incident details IN: /u01/app/oracle/diag/rdbms/orcl/ORCL1/incident/incdir_808023/ORCL1_asmb_34668994_i808023.trc Wed Jul 25 08:03:47 2012 Trace dumping IS performing id=[cdmp_20120725080347] … Continue reading
Posted in BUG
Tagged ASM, asm file, memory_target, ORA-1092, ORA-15064, ORA-4031, sga heap, shared pool, unknown object
Leave a comment
ORA-4031导致CJQ进程出现ORA-1003错误
客户数据库出现ORA-4031错误,随后出现了大量的ORA-1003和ORA-604错误。 数据库版本为10.2.0.3 RAC for HP-UX,详细的报错信息为: Mon Jul 16 15:30:30 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_2389.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable TO allocate 32 bytes OF shared memory ("shared … Continue reading
ORA-600(1616)和ORA-569错误
出现错误的数据库为Oracle 10.2.0.4 RAC for HP-UX。 在RAC的一个节点上出现了ORA-600[1616]错误和ORA-569错误: Sat Apr 7 03:03:09 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:14 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:15 … Continue reading
9i出现内存分配错误
在9.2.0.8 RAC环境中,告警日志频繁出现内存分配错误的信息。 错误信息如下: Wed May 2 10:20:43 2012 Trace dumping IS performing id=[cdmp_20120502102043] There are 1444 memory allocation errors FOR object-level stat IN the LAST 15 minutes . . . There are 1605 memory allocation errors FOR object-level stat IN … Continue reading
Posted in BUG
Tagged memory allocation errors, object-level, ORA-4031, _OBJECT_STATISTICS
Leave a comment
ORA-600(kjrpar:noalloc)错误
由于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
数据泵导出出现ORA-31623错误
客户数据库在调整SGA后,导出出现ORA-31623错误。 Oracle对于这个错误的描述为: ORA-31623: a job IS NOT attached TO this SESSION via the specified handle Cause: An attempt TO reference a job USING a handle which IS invalid OR no longer valid FOR the CURRENT SESSION. Action: SELECT a handle … Continue reading