close

1.error

Thu Dec 13 12:11:51 2012
Errors in file /op/dbms/trace/ora_8249562_op1.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [17182], [804385148], [], [], [], [], [], [
]
ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode]
, [], [], [], [], [], []

 

2.trace file

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /oracle817
System name:    AIX
Node name:      kela1
Release:        3
Version:        5
Machine:        00CEDE3E4C00
Instance name: op1
Redo thread mounted by this instance: 1
Oracle process number: 1815
Unix process pid: 3621166, image: oracle@op1 (TNS V1-V3)

*** 2012-12-13 12:12:50.955
*** SESSION ID:(276.18188) 2012-12-13 12:12:50.954
********** Internal heap ERROR 17182 addr=0x2ff1f17c *********
***** Dump of memory around addr 0x2ff1f17c:
2FF1EF70                            00000008              [....]
2FF1EF80 00000000 00000000 00090000 201413F0  [............ ...]
2FF1EF90 201419A4 00000000 2FF1EBE8 2FF1EB28  [ ......./.../..(]
2FF1EFA0 200B5098 00000005 2014EE74 00000000  [ .P..... ..t....]
2FF1EFB0 00000000 00000000 00000000 00000000  [................]
        Repeat 12 times

******************************************************
HEAP DUMP heap name="callheap"  desc=0x2000a9a8
 extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=3
 parent=20007f70 owner=0 nex=0 xsz=0x424
EXTENT 0
  Chunk 20195644 sz=     1052    perm      "perm           "  alo=52
EXTENT 1
  Chunk 2014ea9c sz=       20    perm      "perm           "  alo=20
  Chunk 2014eab0 sz=      968    free      "               "
  Chunk 2014ee78 sz=       24    freeable  "kgllo          "
  Chunk 2014ee90 sz=       24    freeable  "kgllo          "
Total heap size    =     2088
FREE LISTS:
 Bucket 0 size=76
 Bucket 1 size=268
  Chunk 2014eab0 sz=      968    free      "               "
 Bucket 2 size=1036
Total free space   =      968
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
  Chunk 20195644 sz=     1052    perm      "perm           "  alo=52
  Chunk 2014ea9c sz=       20    perm      "perm           "  alo=20
Permanent space    =     1072

3. oracle proclime

ORA-00600 [17182] on Oracle 8.1.7.4.0 After a CTRL-C or Client Termination
Applies to:
Oracle Server – Enterprise Edition – Version: 8.1.7.4
This problem can occur on any platform.
Checked for relevance on 06-Mar-2007

Oracle RDBMS Server Versions prior to 9i
Symptoms
1. Intermittent heap corruptions errors like ORA-00600 [17182] are reported in the alert.log file.

2. There is no impact to the database other than the process which encounters the errors getting killed.

3. From the trace file generated for this ORA-00600 error, check if the top few functions are :

kgherror kghfrf kkscls opicca

Cause
If the trace file shows that kkscls calls kghfrf, then it is related to:

Bug 2281320 — ORA-600[17182] POSSIBLE AFTER CTRL-C OR CLIENT DEATH
Solution
The problem is when we call kghfrf to free a chunk of memory, we expect that this chunk to have been allocated from the Heap Memory and hence have a valid header, although internally we have used Frame Memory managed chunk. As a result, kghfrf errors out with the “Bagic Magic Number” in the Memory Chunk header error message.

If you are running Oracle 8174, encounter this ORA-00600 [17182], and the call stack indicates the following functions { kgherror kghfrf kkscls }, then download and apply Patch 2281320 from MetaLink.

This issue has been fixed in Oracle Server 8.1.7.5 and later versions.

Note 2281320.8 is not limited to dblinks and can occur during normal database operation as well.

 

根據Oracle對ORA-00600 17182的官方解釋:
    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)

4.solution

Ignore it.




arrow
arrow

    哈哈小熊 發表在 痞客邦 留言(0) 人氣()