ORA-00600 [17147] when using long date format in TO_CHAR function with multi-byte character set (Doc ID 563685.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6
This problem can occur on any platform.

Symptoms

PROBLEM

On databases using a multi-byte character set (such as AL32UTF8) queries may terminate with ORA-600 [17147] when there's a long date format being used in the date specification of the TO_CHAR function.

EXAMPLE
--------
select to_char(systimestamp, 'CC "century", YYYY MONTH DD, DAY HH24:MI:SS.FF, DDD "day of year"') from dual;


The query terminates with ORA-600 [17147] which indicates a memory heap corruption.

TRACE FILE

ksedmp: internal or fatal error 
ORA-00600: internal error code, arguments: [17147], [0xB72A61E8], [], []
********** Internal heap ERROR 17147 addr=0xb72afd1c ********* 
***** Dump of memory around addr 0xb72afd1c:
B72AED10 00000000 [....]
B72AED20 00000000 00000000 00000000 00000000 [................]
...
HEAP DUMP heap name="Typecheck" desc=0xb72aff98
extent sz=0x1024 alt=32767 het=32767 rec=0 flg=3 opc=3
parent=0xcd3c440 owner=(nil) nex=(nil) xsz=0x104c
...
EXTENT 7 addr=0xb72afc10
Chunk b72afc18 sz= 260 NEXT CHUNK'S PREVIOUS POINTER NOT POINTING TO
CURRENT CHUNK 52414559
...



----- Call Stack Trace ----- 
kghfrmrg kghfre kghfrh_internal kghfrh qkesReleaseEvalCtx xtyfld ...
HEAP DUMP heap name="subheap" desc=098A5EA0 
extent sz=0x1024 alt=32767 het=32767 rec=0 flg=2 opc=3
parent=098AFF98 owner=00000000 nex=00000000 xsz=0x854
EXTENT 0 addr=098A5640
Chunk 98a5648 sz= 1132 perm "perm " alo=140
Chunk 98a5ab4 sz= 780 BAD MAGIC NUMBER IN NEXT CHUNK (1000)
recreate "kksfr: qkesSet " latch=00000000
ERROR, BAD FIRST EXTENT (00000000)
...

----- Call Stack Trace ----- 
kgherror kghnsp kghfre kghfrh_internal kghfrh kxsEphemeralFramePop qkesReleaseEvalFrame
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms