Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as text by 123 ( 17 years ago )
Subject: 	ORA-600 [17182] "Heap chunk header BAD MAGIC"
  	Doc ID: 	34779.1 	Type: 	REFERENCE
  	Modified Date : 	19-MAR-2009 	Status: 	PUBLISHED


Note: For additional ORA-600 related information please read Note 146580.1

PURPOSE:            
  This article discusses the internal error "ORA-600 [17182]", what 
  it means and possible actions. The information here is only applicable 
  to the versions listed and is provided only for guidance.
 
ERROR:              
  ORA-600 [17182] [a] [b] [c] [d] [e]
 
VERSIONS:
  versions 7.0 to 9.2
 
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).
 
 
FUNCTIONALITY:
  HEAP MANAGEMENT
 
IMPACT:             
  PROCESS FAILURE
  MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE.
  NON DATA CORRUPTIVE - No underlying data corruption.
 
SUGGESTIONS:

  Check to see if the issue is reproducable.

  Check the OS system logs (/var/adm/messages on Solaris, for example)
  for any memory corruption and run low level memory tests on the system.

  If reproducable, send alert.log and trace files to support.

  Known Issues:

  Bug# 6452485   See Note 6452485.8
      SGA memory corruption / OERI [17182] with fix for Bug 6085625
      Fixed: 10.2.0.4, 11.1.0.7
 
  Bug# 5983683   See Note 5983683.8
      OERI[17182] creating / deleting XDB resource in XA environment
      Fixed: 10.2.0.4, 11.1.0.7, 11.2
 
  Bug# 5172559   See Note 5172559.8
      ora-600's during reinstate of logical standby after fast-start failover
      Fixed: 10.2.0.4, 11.1.0.6
 
  Bug# 5128625   See Note 5128625.8
      OERI[17147] / OERI [17182] / NULL result from NLSSORT
      Fixed: 10.2.0.4, 11.1.0.6
 
  Bug# 5051602   See Note 5051602.8
      OERI[17182] from SCROLLABLE select with duplicate columns
      Fixed: 10.2.0.4
 
  Bug# 4899479   See Note 4899479.8
      Undo/redo corruption if distributed transactions used
      Fixed: 10.2.0.4, 11.1.0.6
 
  Bug# 4104619   See Note 4104619.8
      DIAG may fail with OERI[17182] during dumping of information
      Fixed: 9.2.0.7, 10.1.0.2
 
  Bug# 4061532   See Note 4061532.8
      OERI [17182] / memory corruption from ANY_PATH predicate
      Fixed: 10.1.0.5, 10.2.0.1
 
  Bug# 3139818   See Note 3139818.8
      OERI[17182] / memory corruption / data corruption from JAVA only TRIGGER
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 3053014   See Note 3053014.8
      Memory corruption during/after query on IOT using subset of PK columns
      Fixed: 9.2.0.8, 10.1.0.2
 
  Bug# 3051782   See Note 3051782.8
      Logical standby may fail with OERI:17182 / memory corruption
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 2912559   See Note 2912559.8
      OERI[17182] / memory corruption possible on COMMIT in XDB
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 2839655   See Note 2839655.8
      Single byte CGA memory corruption using NLS_COMP=ANSI with PLSQL
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 2712376   See Note 2712376.8
      DIAG process suffers PGA memory corruption / OERI[17182]
      Fixed: 9.2.0.7, 10.1.0.2
 
  Bug# 2686597   See Note 2686597.8
      Private memory corruption from LIKE used as index stop key
      Fixed: 9.2.0.1
 
  Bug# 2491893   See Note 2491893.8
      OERI:17182 from refresh of DB2 tables using DBMS_PASSTHROUGH
      Fixed: 9.0.1.0
 
  Bug# 2281320   See Note 2281320.8
      OERI:17182 possible during memory free under <Function:kkscls>
      Fixed: 9.0.1.0
 
  Bug# 2228280 +  See Note 2228280.8
      Private memory corruption possible with OPTIMIZER_MODE=RULE if tracing sometimes used
      Fixed: 9.0.1.4, 9.2.0.2, 10.1.0.2
 
  Bug# 2152752   See Note 2152752.8
      Memory corruption / OERI:17182 possible fetching CHAR from DB2 over HS
      Fixed: 8.1.7.4, 9.0.1.3, 9.2.0.1
 
  Bug# 1771999   See Note 1771999.8
      OERI[17182] under ksfdvread reading >1Mb contiguous data blocks
      Fixed: 9.2.0.1
 
  Bug# 1752554   See Note 1752554.8
      OERI:17182 selecting DB2 DATA TYPE of CHAR over HS
      Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1
 
  Bug# 1542218   See Note 1542218.8
      Heap corruption (OERI:17182 / dump in kghfrf) using very large collections
      Fixed: 8.1.7.3, 9.0.1.2, 9.2.0.1
 
  Bug# 1522053   See Note 1522053.8
      Sporadic "session heap" memory corruption (eg: OERI:17182)
      Fixed: 8.1.6.3
 
  Bug# 1365873   See Note 1365873.8
      OERI:17182 / CGA corruption with CURSOR_SHARING=FORCE
      Fixed: 8.1.7.2, 9.0.1.0
 
  Bug# 1279398   See Note 1279398.8
      OERI:17182 from ALTER SESSION SET NLS_.. when CURSOR_SPACE_FOR_TIME=TRUE
      Fixed: 8.1.6.2, 8.1.7.0
 
  Bug# 1060189   See Note 1060189.8
      OERI:17182 corrupt session heap from UNION ALL over DBLINK
      Fixed: 8.0.6.2, 8.1.6.2, 8.1.7.0
 
  Bug# 939235   See Note 939235.8
      Corrupt data on PCTAS with MAX/MIN on VARCHAR2 & GROUP BY & INSTANCES>1
      Fixed: 8.0.6.1
 
  Bug# 917604   See Note 917604.8
      Oracle Trace can cause SGA heap corruption (OERI:17182)
      Fixed: 
 
  Bug# 916309   See Note 916309.8
      PQ: Private memory corruption from AVG() & OR on PARTITIONED table
      Fixed: 8.0.6.1, 8.1.6.0
 
  Bug# 914998   See Note 914998.8
      Cntrl-C during a select from GV$PQ_SLAVE can cause OERI:17182
      Fixed: 8.1.7.0
 
  Bug# 862170   See Note 862170.8
      Work heap mem corr. / wrong results using CONCAT BITMAP index
      Fixed: 7.3.4.5, 8.0.6.1, 8.1.6.0
 
  Bug# 825260   See Note 825260.8
      OCI: OERI:17182 possible binding uninitialized data of type SQLT_VNU
      Fixed: 8.1.5.1, 8.1.6.0
 
  Bug# 808049   See Note 808049.8
      OERI:17182 using INDEX_DESC on concat index & LIKE predicates
      Fixed: 7.3.4.5, 8.0.4.4, 8.0.5.2, 8.0.6.0
 
  Bug# 802297   See Note 802297.8
      OERI:17182 heap corruption setting TIMED_STATISTICS=TRUE
      Fixed: 8.1.5.1, 8.1.6.0
 
  Bug# 801692   See Note 801692.8
      OERI:17182 from QC after single row parallel query
      Fixed: 8.0.5.2

 

Revise this Paste

Your Name: Code Language: