Category Archives: BUG

Oracle bugs

STANDBY数据库出ORA-1009错误

Posted on 2012/09/10 by yangtingkun

在10.2.0.4 DATA GUARD的STANDBY数据库中，出现了大量的ORA-1009错误。 错误信息为： Thu May 31 14:11:16 2012 FAL[client, MRP0]: Error 1009 fetching archived redo log FROM orcl Thu May 31 14:11:16 2012 Errors IN file /opt/app/oradir/admin/orcl_st/bdump/orcl_st_mrp0_23866.trc: ORA-01009: missing mandatory parameter Thu May 31 14:11:46 2012 FAL[client, MRP0]: Error … Continue reading →

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

ORA-600(qerrmOStart2)(972)错误

Posted on 2012/09/09 by yangtingkun

关于ORA-600[qerrmOStart2]已经碰到第三次不同的错误了，简单记录一下这个问题。 数据库版本为10.2.0.5 RAC for Linux X86-64，错误信息为： Fri Jun 29 14:53:29 CST 2012 Errors IN file /opt/app/oracle/admin/ora/udump/ora2_ora_5832.trc: ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier IS too long ], [], [], [], [], [] Fri Jun 29 14:53:36 CST 2012 … Continue reading →

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

数据泵导入分区表长时间HANG住

Posted on 2012/09/07 by yangtingkun

客户10.2.0.3环境数据库在使用数据库导入分区表时，出现长时间HANG住的情况。 通过10046跟踪，发现等待发生在空闲等待wait for unread message on broadcast channel上，部分10046 TRACE摘录如下： ===================== PARSING IN CURSOR #27 len=93 dep=2 uid=0 oct=3 lid=0 tim=1314162845109698 hv=3190910778 ad=’5a938130′ SELECT NVL(SUM(data_io),0) FROM "SYS"."SEASHELL_ENTRY_P_20110126_88" WHERE process_order = :1 END OF STMT PARSE #27:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845109693 BINDS #27: kkscoacd Bind#0 oacdty=02 … Continue reading →

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

HPUX上出现ORA-27300、ORA-27301、ORA-27302的STATUS 11错误

Posted on 2012/08/22 by yangtingkun

数据库出现ORA-27300、ORA-27301和ORA-27302错误并最终出现ORA-29702错误，导致数据库实例的崩溃。 数据库版本为10.2.0.4 RAC for HP-UX，详细错误信息为： Wed Jun 27 04:31:07 2012 Process startup failed, error stack: Wed Jun 27 04:31:07 2012 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_psp0_1943.trc: ORA-27300: OS system dependent operation:fork failed WITH STATUS: 11 ORA-27301: OS failure message: Resource temporarily unavailable … Continue reading →

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

ORA-4030、ORA-27300错误和大量ORA-7445错误

Posted on 2012/08/16 by yangtingkun

客户11.2 RAC环境出现大量的ORA-7445错误、ORA-4030错误以及ORA-27300、ORA-27301和ORA-27302错误。 错误信息为： Sat DEC 31 02:33:18 2011 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_p015_28613.trc: ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address NOT mapped TO object] [] ORA-04030: OUT OF process memory WHEN trying TO allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba) … 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-4030错误

Posted on 2012/08/14 by yangtingkun

客户Oracle 10.2.0.3环境，在导出是碰到ORA-4030错误。 错误信息为： Processing object TYPE SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object TYPE SCHEMA_EXPORT/TABLE/TRIGGER Processing object TYPE SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object TYPE SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ ORA-39014: One OR more workers have prematurely exited. ORA-39029: worker 1 WITH process name “DW01” prematurely TERMINATED ORA-31671: Worker process DW01 … Continue reading →

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

ORA-7445(xsStkPurge)错误

Posted on 2012/08/11 by yangtingkun

客户数据库出现ORA-7445(xsStkPurge)错误。 数据库告警日志出现如下的错误信息： Fri Aug 3 17:10:03 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_23101.trc: ORA-07445: exception encountered: core dump [xsStkPurge()+73] [SIGSEGV] [Address NOT mapped TO object] [0x0] [] [] ORA-04030: OUT OF process memory WHEN trying TO allocate 8184 bytes (OLAP stack hea,OLAP … Continue reading →

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

ORA-7445(kwqbcsoa)和ORA-7445(lstclo)错误

Posted on 2012/08/07 by yangtingkun

客户环境出现多次ORA-7445错误以及Oracle executable binary mismatch detected的告警信息。 数据库版本为10.2.0.3 for Linux，错误信息如下： Mon Aug 6 11:13:11 2012 WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these … Continue reading →

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

ORA-600(kghstack_underflow_internal_2)错误

Posted on 2012/08/06 by yangtingkun

数据库10.2.0.3 for Linux 32环境出现ORA-600(kghstack_underflow_internal_2)错误。 详细错误信息为： Tue Aug 7 08:36:43 2012 Errors IN file /ora/app/oracle/admin/ORC/udump/orcl_ora_29455.trc: ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0xB72101E8], [], [], [], [], [], [] ORA-01013: USER requested cancel OF CURRENT operation ORA-01013: USER requested cancel OF CURRENT … Continue reading →

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