My Oracle Support Banner

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

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.6 [Release 10.1 to 11.1]
Information in this document applies to any platform.
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.

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
...

Changes

 NONE

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
 PROBLEM
 TRACE FILE
Changes
Cause
Solution
 SOLUTION
 WORKAROUND
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.