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 |
|
|
|
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 | |
|
|
12.1.0.0 |
ORA-600 [17114] / memory corruption optimizing ANSI queries with FIRST_ROWS(K) |
V11020001 V11020002 V11020003 ANSI CBO DUMP MEMCOR OERI | |
|
|
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 | |
|
|
12.1.0.0 |
Call Memory corruption / ORA-600 [17114] with CDC |
V11020001 V11020002 V11020003 CDC MEMCOR OERI | |
|
|
12.1.0.0 |
SGA corruption / ORA-600 / dumps using XA with database links |
V11020001 V11020002 V11020003 DBLINK DUMP MEMCOR MTS OERI XA | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
+ |
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 | |
|
+ |
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 | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
|
11.2.0.2, 12.1.0.0 |
Dump [kglbrk] during trigger execution |
V11010006 V11010007 V11020001 DUMP OERI TRIGGER | |
|
|
11.2.0.2 |
Memory corruption / OERI [17158] using XSLPROCESSOR |
V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 MEMCOR OERI XDB | |
|
|
|
Parsing XSL files using include files gets ORA-31020 |
V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 ERROR XDB | |
|
|
11.2.0.1 |
ORA-600 [733] / ORA-600 [17114] from parallel DML to interval partitioned table |
V11010006 V11010007 OERI PART PQO | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
|
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 | |
|
|
11.2.0.1 |
Memory corruption / ORA-600 [17147] Txt indexing long HTML strings |
V10010005 V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 ITEXT MEMCOR OERI | |
|
|
11.1.0.7, 11.2.0.1 |
Memory corruption / OERI from CDI Text query with > 32 predicate conditions |
V11010006 ITEXT OERI | |
|
|
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 | |
|
|
|
DIAG process fails with ORA-600 [17114] |
V10020002 V10020003 V10020004 V10020005 MEMCOR OERI | |
|
|
10.2.0.5, 11.1.0.6 |
Private memory corruption / ORA-600 [17114] |
V10020002 V10020003 V10020004 MEMCOR OERI | |
|
|
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 | |
|
|
10.2.0.4, 11.1.0.6 |
OERI[17114] using EMPTY_CLOB() in a trigger |
V10020002 V10020003 LOB OERI TRIGGER | |
|
|
10.2.0.5, 11.1.0.6 |
ORA-600 [kksaxs: kzpzasz] / [17114] can occur |
V10020002 V10020003 V10020004 DUMP MEMCOR OERI | |
|
|
10.2.0.3, 11.1.0.6 |
Memory corruption / OERI[17114] from HS |
V10010005 V10020002 HS MEMCOR OERI | |
|
|
10.2.0.5.5 |
Session dump with stack memcpy <- kjzhgigblk in RAC env |
V10020002 V10020003 V10020004 V10020005 DUMP MEMCOR OERI OPS | |
|
|
10.2.0.4.4, 10.2.0.5 |
Memory corruption / OERI:17147 in DIAG in RAC |
V10020002 V10020003 V10020004 MEMCOR OERI OPS | |
|
|
10.2.0.4 |
Capture process aborts with OERI [17112] / OERI [17147] |
V10020002 V10020003 MEMCOR OERI STREAMS | |
|
|
10.2.0.4 |
SGA corruption in RAC (OERI [17114] / OERI [17112]) |
V10020002 V10020003 MEMCOR OERI OPS | |
|
P* |
10.2.0.5 |
Windows: Memory Corruption after Applying 10.2.0.4 Patch 5 - Patch 9 |
V10020004 DUMP MEMCOR OERI P208 P233 P912 | |
|
|
9.2.0.8, 10.2.0.1 |
Memory corruption / OERI[17147] following a "kksfbc:hash" chunk |
V10010005 MEMCOR | |
|
|
9.2.0.8, 10.1.0.5, 10.2.0.1 |
DBMS_XMLGEN.CONVERT can cause memory corruption |
MEMCOR OERI XDB | |
|
|
|
Memory Corruption on Statements with a Large Number of Bind Variables |
V09020008 MEMCOR | |
|
|
|
SQL_TRACE / 10046 trace single bit memory corruption after "ksm stack" in PGA |
V09020008 DUMP MEMCOR OERI | |
|
|
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 | |
|
|
9.2.0.8 |
Memory corruption on query |
MEMCOR OERI | |
|
|
9.2.0.1 |
Private memory corruption from LIKE used as index stop key |
MEMCOR | |
|
+ |
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 | |
|
|
9.2.0.1 |
INDEX_JOIN hint can cause memory corruption if _INDEX_JOIN_ENABLED=false |
MEMCOR OERI | |
|
P |
|
Shadow process memory corruption can occur on some platforms |
MEMCOR P38 P46 P59 P87 | |
|
|
8.0.6.3, 8.1.6.3, 8.1.7.0 |
OERI:17114 / OERI:17112 using STAR_TRANSFORMATION |
MEMCOR OERI REGRESSION STAR | |
|
|
8.1.6.2, 8.1.7.0 |
SGA heap memory corruption from statements Unique index on IOT |
IOT MEMCOR OERI | |
|
|
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
Errors
|
这个oracle的一个bug。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12129601/viewspace-713660/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 关于HBase协处理器导致问题的研究
- ORA-00600: 内部错误代码, 参数: [ktspScanInit-l1], [], [], [], [], [], [], []
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"
- ORA-00600: 内部错误代码, 参数: [qertbFetchByRowID], [], [],
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],
- PL/SQL:ORA-00980同义词转换不再有效
- ORA-31693;ORA-31617;ORA-19505;ORA-27037
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []
- ORA-01031,ORA-01031错的分析与处理
- Fatal NI connect error 12170
