Tag Archives: parallel

ORA-7445(kxfrSortGranuleInstance)错误

10.2.0.4 RAC for HP-UX上出现了这个错误。 错误信息为: Sat DEC 31 14:48:42 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl1_ora_26183.trc: ORA-07445: exception encountered: core dump [kxfrSortGranuleInstance()+1248] [SIGBUS] [Invalid address alignment] [0x9FFFFFFFBDF45674] [] [] Sat DEC 31 14:49:26 2011 Thread 1 advanced TO log SEQUENCE 68840 CURRENT … Continue reading

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

ORA-600(ksnpost:ksnigb)错误

客户10.2.0.5 RAC for HP-UX ia64出现ORA-600(ksnpost:ksnigb)的错误。 错误信息如下: Wed Apr 25 16:32:21 UTC 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc: ORA-00600: Message 600 NOT found; No message file FOR product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping IS performing id=[cdmp_20120425163255] … Continue reading

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

ORA-600(15214)错误

告警日志中包含ORA-600[15214]错误。 错误信息为: Fri Feb 03 01:21:47 EAT 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_p155_29897.trc: ORA-00600: internal error code, arguments: [15214], [0], [2], [], [], [], [], [] Fri Feb 03 01:21:49 EAT 2012 Trace dumping IS performing id=[cdmp_20120203012149] 很显然,这是一个并行执行导致的错误,进一步检查详细TRACE: *** 2012-02-03 01:21:47.380 … Continue reading

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

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

客户的Oracle10204 RAC FOR Hp数据库执行EXPDP并行导出时出现了这个错误信息。 导出报错如下: Export: Release 10.2.0.4.0 – 64bit Production ON Thursday, 12 January, 2012 6:10:00 Copyright (c) 2003, 2007, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, … Continue reading

Posted in ORACLE | Tagged , , , , | 1 Comment

ORA-7445(qerixGetKey)错误

执行并行查询时碰到的问题。 错误信息如下: Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p001_8093.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [21] [] [] [] Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p000_8091.trc: ORA-07445: exception encountered: core dump … Continue reading

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

ORA-600(krd_check_slaves_1)错误

物理STANDBY环境在进行恢复时碰到这个错误。 详细错误信息为: <pre lang=’SQL’>Sun Sep 11 06:59:47 2011 alter database recover datafile list clear Sun Sep 11 06:59:47 2011 Completed: alter database recover datafile list clear Sun Sep 11 06:59:47 2011 alter database recover datafile list 1 , 2 , … Continue reading

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