Tag Archives: ORA-4031

ORA-600(koksadqb1)错误

Posted on 2013/07/08 by yangtingkun

使用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 →

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

ORA-600(ksxp_rm_check0)错误

Posted on 2013/07/04 by yangtingkun

客户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 , , , , , , , , | Leave a comment

11.2.0.3 ASM实例出现ORA-4031导致数据库归档失败

Posted on 2013/07/03 by yangtingkun

客户的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 →

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

ASM实例出现ORA-4031错误导致实例崩溃

Posted on 2012/08/15 by yangtingkun

数据库的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 , , , , , , , , | Leave a comment

ORA-4031导致CJQ进程出现ORA-1003错误

Posted on 2012/07/17 by yangtingkun

客户数据库出现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 →

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

ORA-600(1616)和ORA-569错误

Posted on 2012/06/08 by yangtingkun

出现错误的数据库为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 →

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

9i出现内存分配错误

Posted on 2012/05/06 by yangtingkun

在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 , , , | Leave a comment

ORA-600(kjrpar:noalloc)错误

Posted on 2012/02/29 by yangtingkun

由于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 →

Posted in BUG | Tagged , , , , , | 1 Comment

数据泵导出出现ORA-31623错误

Posted on 2012/02/07 by yangtingkun

客户数据库在调整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 →

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