ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600 [17114]

ORA-600 [17114]

原创 Linux操作系统 作者:dcswinner 时间:2011-12-20 23:21:57 0 删除 编辑

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 <- kjzhgigblk in RAC env

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-03

  • 博文量
    61
  • 访问量
    486789