Workaround and fix for ORA-error stack (00600[ktt_check_thershold-1])

I have got the below issue from the grid control as shown below:

Message:

Message=ORA-error stack (00600[ktt_check_thershold-1]) logged in D:\ORACLE\PRODUCT\10.2.0\ADMIN\ISPNTDDB\BDUMP\alert_ISPNTDDB.log.
Metric=Generic Alert Log Error
Metric value=Errors in file d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_9296.trc:~ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [524288], [524288], [1048576], [], [], [], []~ 

The issue was occurring on database  10.2.0.4.0 on windows 64bit 2003.

after investigating the below trace:

Name
--------
d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_9676.trc

Sun Jan 05 12:37:20 2014
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:5577M/16381M, Ph+PgF:7222M/17821M
Instance name: ispntddb

Redo thread mounted by this instance: 1

Oracle process number: 27

Windows thread id: 9676, image: ORACLE.EXE (MMON)


*** SERVICE NAME:(SYS$BACKGROUND) 2014-01-05 12:37:20.062
*** SESSION ID:(462.42118) 2014-01-05 12:37:20.062
*** 2014-01-05 12:37:20.062
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [524288], [524288], [1048576], [], [], [], []
check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\ispntddb_ora_0.trc for preloading .sym file messages
----- Call Stack Trace -----
ksedmp <- ksfdmp <- kgerinv <- kgeasnmierr <- ktte_check_threshol
<- ktte_check_undo_tbs <- ktte_monitor_tsth <- 833 <- ktte_monitor_ts <- ksbcti
<- ksbabs <- kebm_mmon_main <- ksbrdp <- opirip <- opidrv
<- sou2o <- opimai_real <- opimai <- BackgroundThreadSta <- 0000000077D6B71A
---------
SO: 000000027255EC50, type: 4, owner: 000000026F3B9508, flag: INIT/-/-/0x00
(session) sid: 462 trans: 0000000000000000, creator: 000000026F3B9508, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-001B-00003047, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 0, prv: 0, sql: 0000000000000000, psql: 0000000000000000, user: 0/SYS
service name: SYS$BACKGROUND
last wait for 'control file sequential read' blocking sess=0x0000000000000000 seq=19 wait_time=1453 seconds since wait started=1
file#=0, block#=13, blocks=1
Dumping Session Wait History
for 'control file sequential read' count=1 wait_time=1453
file#=0, block#=13, blocks=1
for 'control file sequential read' count=1 wait_time=2076
file#=0, block#=11, blocks=1
----
SO: 000000026F3B9508, type: 2, owner: 0000000000000000, flag: INIT/-/-/0x00
(process) Oracle pid=27, calls cur/top: 00000002725E6480/00000002725E77F0, flag: (2) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 48
last post sent-location: ksoreq_reply
last process posted by me: 6f3b3328 1 14
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 000000026F4331C0
O/S info: user: SYSTEM, term: CAINCNTD01, ospid: 9676
OSD pid info: Windows thread id: 9676, image: ORACLE.EXE (MMON)
Dump of memory from 0x000000026F394998 to 0x000000026F394BA0
26F394990 0000000D 00000000 [........]
26F3949A0 6AA82350 00000002 00000010 000313A7 [P#.j............]
26F3949B0 725E77F0 00000002 00000003 000313A7 [.w^r............]
26F3949C0 726F31C0 00000002 0000000B 000313A7 [.1or............]
26F3949D0 7255EC50 00000002 00000004 0003129B [P.Ur............]
26F3949E0 726F7008 00000002 0000000B 000313A7 [.por............]
26F3949F0 726F7130 00000002 0000000B 000313A7 [0qor............]
26F394A00 6F7C4418 00000002 0000000D 000313A7 [.D|o............]
26F394A10 6C50A1A0 00000002 00000007 000313A7 [..Pl............]
26F394A20 726F7240 00000002 0000000B 000313A7 [@ror............]
26F394A30 726F7460 00000002 0000000B 000313A7 [`tor............]
26F394A40 6C50AF48 00000002 00000007 000313A7 [H.Pl............]
26F394A50 6C50CF70 00000002 00000007 000313A7 [p.Pl............]
26F394A60 6C50D730 00000002 00000007 000313A7 [0.Pl............]
26F394A70 00000000 00000000 00000000 00000000 [................]
Repeat 18 times
(FOB) flags=2 fib=000000026C9D4D20 incno=0 pending i/o cnt=0
fname=O:\ISPNTDDB\CONTROL03.CTL
fno=2 lblksz=16384 fsiz=1030
(FOB) flags=2 fib=000000026C9D4980 incno=0 pending i/o cnt=0
fname=O:\ISPNTDDB\CONTROL02.CTL
fno=1 lblksz=16384 fsiz=1030
(FOB) flags=2 fib=000000026C9D45E0 incno=1 pending i/o cnt=0
fname=O:\ISPNTDDB\CONTROL01.CTL
fno=0 lblksz=16384 fsiz=1030

==============================================================

Alert Log Content:

Wed Jan 01 10:56:46 2014
Restarting dead background process MMON
MMON started with pid=27, OS id=9668
Wed Jan 01 10:56:49 2014
Errors in file d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_9668.trc:
ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [1179648], [1179648], [1572864], [], [], [], []

Wed Jan 01 10:57:50 2014
Restarting dead background process MMON
MMON started with pid=30, OS id=8956
Wed Jan 01 10:57:53 2014
Errors in file d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_8956.trc:
ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [1179648], [1179648], [1572864], [], [], [], []

==================================================================

Reason for the issue:

When initially create the datafile with MAXSIZE specified and then resize the file > MAXSIZE and the datafile in autoextend mode then you may hit the bug.

================================================================

Permanent fix:

Apply the patch number is 8392341.

=============================================================

Workaround:

Try to resize the datafile for both undo and temp and check if this will fix the issue.

If the issue still exist disable the autoextend and this should fix the issue.

Kind Regards

Mohamed ELAzab