ORA-600 [17114]

  • Post author:
  • Post category:其他


12月中午,北京局的一同事找到我,说他的一个新装的数据库错误:



ORA-600 [17114]

通过查看分析metalink相关文档:



ORA-600 [17114] “KGH Bad magic number in header” [ID 34782.1]








Modified



05-DEC-2011

Type

REFERENCE

Status

PUBLISHED




Note: For additional ORA-600 related information please read

Note:146580.1



PURPOSE:


This article discusses the internal error “ORA-600 [17114]”, what


it means and possible actions. The information here is only applicable


to the versions listed and is provided only for guidance.



ERROR:


]/g,’>’); msgfld = document.getElementById(“FullMsg”); msgfld.innerHTML += ”

Supplied Error Message: ORA-600 [17114]”+ arglst.toLowerCase(); } return; }

Format: ORA-600 [17114] [a]





VERSIONS:


versions 7.0 and above



DESCRIPTION:



Oracle has detected that the magic number in a memory chunk header has been


overwritten.



This is a heap (in memory) corruption and there is no underlying data


corruption.



The error may occur in the one of the process specific heaps


(the Call heap, PGA heap, or session heap) or in the shared heap (SGA).



ARGUMENTS:


Arg [a] Pointer to chunk header



FUNCTIONALITY:


HEAP MANAGEMENT



IMPACT:


PROCESS FAILURE


MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE


NON DATA CORRUPTIVE – No underlying data corruption.



SUGGESTIONS:



If you think you are not hitting any of the known issues shown below,


then you need to set event 10235 in your init.ora file :-



event=”10235 trace name context forever, level 1″



While the event is set, the next time you get the error a trace


file will be generated in your USER_DUMP_DEST directory.


Contact Oracle Support Services and supply the trace file.



Known Issues:




function getdoc(docstr) { pos=docstr.indexOf(‘:’); docid=docstr.substring(pos+1,docstr.length); tgt=”_self”; if ( location.href.slice(7,12) == “webiv” || location.href.slice(7,11) == “rmsu” ) { loc=”Get?WwwID=note:” + docid; window.open(loc,tgt) return; } if ( location.href.slice(7,12) == “metal” || location.href.slice(7,12) == “suppo” ) { loc=”showdoc?db=NOT&id=” + docid; window.open(loc,tgt) return; } else { loc=”http://metalink.oracle.com/metalink/plsql/showdoc”+ “?db=NOT&id=”+docid; window.open(loc,tgt) return; } }




Known Bugs


0) { // MUST have this tag if (affects==null || affects.indexOf(t)<0) { display=0; // but we do not have it } } else { if (Tags[t]0) { dig=iver.substr(0,1); if (dig==’.’) { return(res+iver); } if (dig==’0′) { dig=iver.substr(1,1); } else { dig=iver.substr(0,2); } res=res+sep+dig; sep=’.’; iver=iver.substr(2); } return(res); } function IamOn(ver){ Ver=ver; ShowRows(); var titl = document.getElementById(“BugListInfo”); if (titl!=null) { if (ver==null) { titl.innerHTML=”The list below shows bugs affecting any version”; } else { titl.innerHTML=”The list below is restricted to show only bugs “+ “believed to affect version “+NiceVer(ver)+”.

“+ “Other bugs may affect this version “+ ” but have not been confirmed as being relevant yet.”; } } } // ===== ACT ON URL ===== window.onload = SetVer; // ======================




窗体顶端



You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:






NB





Bug





Fixed





Description







12768840


12.1.0


.0


Memory Access Violation Reported as ORA-600 and/or ORA-7445 from qesma*() functions


V11010006 V11010007 V11020001 V11020002 CBO DUMP MEMCOR OERI




12714511


12.1.0


.0


ORA-600 [17114] / memory corruption optimizing ANSI queries with FIRST_ROWS(K)


V11020001 V11020002 V11020003 ANSI CBO DUMP MEMCOR OERI




12613970


11.2.0


.3, 12.1.0.0


ORA-600 [krbrrd_bz2_uncompressed] / ORA-600 [17114] on RMAN restore of compressed backup set


V11020001 V11020002 BADBACKUP OERI RMAN




12594032


12.1.0


.0


Call Memory corruption / ORA-600 [17114] with CDC


V11020001 V11020002 V11020003 CDC MEMCOR OERI




12579446


12.1.0


.0


SGA corruption / ORA-600 / dumps using XA with database links


V11020001 V11020002 V11020003 DBLINK DUMP MEMCOR MTS OERI XA




12374212


11.2.0


.3, 12.1.0.0


Assorted dump , internal errors, memory corruptions with cursor_sharing = force


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 V11020002 DUMP LITREPL MEMCOR OERI




11858315


11.2.0


.3, 12.1.0.0


Bind related memory corruption / ORA-600 (near kxs-heap-b heap)


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 V11020002 DUMP MEMCOR OERI




11698419


11.2.0


.3, 12.1.0.0


Spatial Index based query fails with ORA-7445 [mdrtdminqw_geod] / ORA-600 [kghfrempty:ds]


V11020001 V11020002 DUMP OERI SDO




11065090


11.2.0


.3, 12.1.0.0


CDC apply process memory corruption / ORA-600 / dump for LOB columns


V11020001 V11020002 CDC DUMP LOB MEMCOR OERI STREAMS




10635754


11.2.0


.3, 12.1.0.0


Private Memory corruption / ORA-600 [17147] on select using stemmer


V11010006 V11010007 V11020001 V11020002 ITEXT MEMCOR OERI


+



9724970


11.2.0


.1.BP08, 11.2.0.2.2, 11.2.0.2.BP02, 11.2.0.3, 12.1.0.0


Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check


V11020001 V11020002 CORR/LOG CRASH DUMP ERROR OERI PQO


+



9577583


11.2.0


.1.BP08, 11.2.0.2, 12.1.0.0


False ORA-942 or other errors when multiple schemas have identical object names


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 BADCURSOR CORR/LOG DUMP ERROR PLSQL RMAN WRONGRES




9478199


11.2.0


.3, 12.1.0.0


Memory corruption / ORA-600 from PLSQL anonymous blocks


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 V11020002 DUMP MEMCOR OERI PLSQL




9145181


11.2.0


.2, 12.1.0.0


Creating more than 1023 scheduler chains fails with ORA-6532 / gets memory corruption


V11010006 V11010007 V11020001 DBMSPKG ERROR JOBQ MEMCOR OERI




8912701


11.2.0


.2, 12.1.0.0


OERI [17114] during select from external table / SELECT from external table may fail with KUP-4058/KUP-4050


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 EXTTAB LEAK/MEM LOB MEMCOR OERI




8425797


11.2.0


.2, 12.1.0.0


Dump [kglbrk] during trigger execution


V11010006 V11010007 V11020001 DUMP OERI TRIGGER




9193152


11.2.0


.2


Memory corruption / OERI [17158] using XSLPROCESSOR


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 MEMCOR OERI XDB




8302548



Parsing XSL files using include files gets ORA-31020


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 ERROR XDB




8253459


11.2.0


.1


ORA-600 [733] / ORA-600 [17114] from parallel DML to interval partitioned table


V11010006 V11010007 OERI PART PQO




7643188


10.2.0


.5, 11.1.0.7.2, 11.2.0.1


Invalid / corrupt AWR SQL statistics


V10020002 V10020003 V10020004 V11010006 V11010007 AWR MEMCOR OERI PERF/MON




7330434


11.1.0


.7.1, 11.2.0.1


Memory corruption / OERI:17147 from DBMS_MVIEW.REFRESH


V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 MEMCOR MVIEW OERI




7298601


11.1.0


.7.8, 11.2.0.1


Wrong results / dump from INDEX RANGE SCAN with inequality predicates


V11010006 V11010007 DUMP MEMCOR OERI WRONGRES




7272297


10.2.0


.4.1, 10.2.0.5, 11.1.0.7, 11.2.0.1


Memory corruption / OERI[17114] / OERI[17125] with literal replacement


V10020002 V10020003 V10020004 V11010006 LITREPL MEMCOR OERI




6872049


11.2.0


.1


Memory corruption / ORA-600 [17147] Txt indexing long HTML strings


V10010005 V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 ITEXT MEMCOR OERI




6439034


11.1.0


.7, 11.2.0.1


Memory corruption / OERI from CDI Text query with > 32 predicate conditions


V11010006 ITEXT OERI




8674660


10.2.0


.5, 11.1.0.7


DIAG process gets PGA memory corruption or ORA-600[kjzhablar:idx] or dump in RAC env


V10020002 V10020003 V10020004 V11010006 DUMP OERI OPS




12551583



DIAG process fails with ORA-600 [17114]


V10020002 V10020003 V10020004 V10020005 MEMCOR OERI




6123694


10.2.0


.5, 11.1.0.6


Private memory corruption / ORA-600 [17114]


V10020002 V10020003 V10020004 MEMCOR OERI




5939230


10.2.0


.5, 11.1.0.6


Dump [kkeidc] / memory corruption from query over database link


V10020002 V10020003 V10020004 CBO DBLINK DUMP HANG/SPIN MEMCOR




5676637


10.2.0


.4, 11.1.0.6


OERI[17114] using EMPTY_CLOB() in a trigger


V10020002 V10020003 LOB OERI TRIGGER




5563231


10.2.0


.5, 11.1.0.6


ORA-600 [kksaxs: kzpzasz] / [17114] can occur


V10020002 V10020003 V10020004 DUMP MEMCOR OERI




4995320


10.2.0


.3, 11.1.0.6


Memory corruption / OERI[17114] from HS


V10010005 V10020002 HS MEMCOR OERI




9322219


10.2.0


.5.5


Session dump with stack memcpy


V10020002 V10020003 V10020004 V10020005 DUMP MEMCOR OERI OPS




7028176


10.2.0


.4.4, 10.2.0.5


Memory corruption / OERI:17147 in DIAG in RAC


V10020002 V10020003 V10020004 MEMCOR OERI OPS




6136494


10.2.0


.4


Capture process aborts with OERI [17112] / OERI [17147]


V10020002 V10020003 MEMCOR OERI STREAMS




5681955


10.2.0


.4


SGA corruption in RAC (OERI [17114] / OERI [17112])


V10020002 V10020003 MEMCOR OERI OPS


P*



7322985


10.2.0


.5


Windows: Memory Corruption after Applying 10.2.0.4 Patch 5 – Patch 9


V10020004 DUMP MEMCOR OERI P208 P233 P912




4047969


9.2.0


.8, 10.2.0.1


Memory corruption / OERI[17147] following a “kksfbc:hash” chunk


V10010005 MEMCOR




3684772


9.2.0


.8, 10.1.0.5, 10.2.0.1


DBMS_XMLGEN.CONVERT can cause memory corruption


MEMCOR OERI XDB




9786831



Memory Corruption on Statements with a Large Number of Bind Variables


V09020008 MEMCOR




6503844



SQL_TRACE / 10046 trace single bit memory corruption after “ksm stack” in PGA


V09020008 DUMP MEMCOR OERI




2028564


9.0.1


.4, 9.2.0.2, 10.1.0.2


ORA-7445 or OERI:17114 errors possible after OERI:729 – PMON may die


CRASH DUMP OERI




3891092


9.2.0


.8


Memory corruption on query


MEMCOR OERI




2686597


9.2.0


.1


Private memory corruption from LIKE used as index stop key


MEMCOR


+



1836101


8.1.7


.3, 9.0.1.2, 9.2.0.1


Memory Corruption from distributed query / query with binds (OERI:17114 / dump in kkecdn/kgh*/kke*)


CBO DBLINK DUMP MEMCOR OERI




1682090


9.2.0


.1


INDEX_JOIN hint can cause memory corruption if _INDEX_JOIN_ENABLED=false


MEMCOR OERI


P



2566849



Shadow process memory corruption can occur on some platforms


MEMCOR P38 P46 P59 P87




1280983


8.0.6


.3, 8.1.6.3, 8.1.7.0


OERI:17114 / OERI:17112 using STAR_TRANSFORMATION


MEMCOR OERI REGRESSION STAR




1182496


8.1.6


.2, 8.1.7.0


SGA heap memory corruption from statements Unique index on IOT


IOT MEMCOR OERI




584858


8.0.4


.4, 8.0.5.0, 8.1.5.0


OERI:17114 / bad data using PLSQL arrays


MEMCOR OERI


·




‘*’


against a bug indicates that an alert exists for that issue.


·




‘+’


indicates a particularly notable bug.


·




‘P’


indicates a port specific bug.


·





“OERI:

nnnnn




” is used as shorthand for

ORA-600 [

nnnnn

]

.





Bug# 898074


PRIVATE MEM CORR ON PARTITION TABLE & NON-PARTITION-KEY PREDICATE


Fixed: 8.0.6.1, 8.1.6.0



Bug# 573746


DBMS_SQL DEFINE_ARRAY / ARRAY FETCH TO LARGE ARRAY MAY CAUSE ORA-600[17114]


Fixed: 8.0.4.4, 8.0.5.0, 8.1.5.0






Related




Products





·




Oracle Database Products > Oracle Database > Oracle Database > Oracle Server – Standard Edition


·




Oracle Database Products > Oracle Database > Oracle Database > Oracle Server – Enterprise Edition


·




Oracle Database Products > Oracle Database > Oracle Database > Oracle Server – Personal Edition



Keywords





BUGTAG_ADDBUGS; DDRCONFIRMED; INTTEAMREVIEWED



Errors





ORA-600[17114]


这个oracle的一个bug。


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12129601/viewspace-713660/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/12129601/viewspace-713660/