Tag Archives: memory_target

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-7445(kcrfw_update_blk_list)错误

Posted on 2011/12/25 by yangtingkun

客户的11.2数据库测试环境中碰到了ORA-7445(kcrfw_update_blk_list)错误。 详细的错误信息如下： Tue DEC 20 22:00:02 2011 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue DEC 20 22:00:46 2011 Exception [TYPE: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_lgwr_24506.trc … Continue reading →

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