Email: service@parnassusdata.com 7 x 24 online support!

    You are here

Oracle UNABLE TO OPEN DATABASE DUE TO ORA-600 [KTFDFINSERT1], [9], [84130]

Oracle UNABLE TO OPEN DATABASE DUE TO ORA-600 [KTFDFINSERT1], [9], [84130]

PROBLEM:
--------
After some trouble with Temp Tablespaces, and after a SHUTDOWN IMMEDIATE,
the database will NOT OPEN.  Getting the following errors.
 
Fri Sep 05 12:50:11 2003
Completed: alter database open 
Fri Sep 05 12:56:50 2003
Thread 1 advanced to log sequence 15537
  Current log# 3 seq# 15537 mem# 0: E:\ORACLE\ORADATA\LINK2HRD\REDO0301.DBF
  Current log# 3 seq# 15537 mem# 1: D:\ORACLE\ORADATA\LINK2HRD\REDO0302.DBF
Fri Sep 05 13:01:03 2003
Errors in file e:\oracle\admin\Link2HRD\bdump\link2hrdSMON.TRC:
ORA-600: internal error code, arguments: [ktfdfinsert1], [9], [84130], [], 
[], [], [], []
 
 
TRACE FILE SHOWS
===============
Dump file e:\oracle\admin\Link2HRD\bdump\link2hrdSMON.TRC
Fri Sep 05 13:01:03 2003
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: link2hrd
 
Redo thread mounted by this instance: 1
 
Oracle process number: 6
 
Windows thread id: 1588, image: ORACLE.EXE
 
*** ID:(5.1) 2003-09-05 13:01:03.227
*** 13:01:03.227
ksedmp: internal or fatal error
ORA-600: internal error code, arguments: [ktfdfinsert1], [9], [84130], [], 
[], [], [], []
----- Call Stack Trace -----
ksedmp ksfdmp kgerinv kgeasnmierr ktfdfinsert ktssdro_segment ktssdt_segs 
ktmmon ksbrdp 
opirip opidrv sou2o opimai
===================================
 
DIAGNOSTIC ANALYSIS:
--------------------
TRACE FILE SHOWS
Dump file e:\oracle\admin\Link2HRD\bdump\link2hrdSMON.TRC
Fri Sep 05 13:01:03 2003
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: link2hrd
 
Redo thread mounted by this instance: 1
 
Oracle process number: 6
 
Windows thread id: 1588, image: ORACLE.EXE
 
 
*** ID:(5.1) 2003-09-05 13:01:03.227
*** 13:01:03.227
ksedmp: internal or fatal error
ORA-600: internal error code, arguments: [ktfdfinsert1], [9], [84130], [], 
[], [], [], []
----- Call Stack Trace -----
ksedmp ksfdmp kgerinv kgeasnmierr ktfdfinsert ktssdro_segment ktssdt_segs 
ktmmon ksbrdp 
opirip opidrv sou2o opimai
===================================
 
WORKAROUND:
-----------
None.
 
I have asked Ct to take a backup of current database and to create a new 
database and to import his latest full database export.  Ct has no backups and 
is not running archive log mode.
 
RELATED BUGS:
-------------
Bug:1838308 
Bug:1561125
 
REPRODUCIBILITY:
----------------
Ct cannot open database!!
 
TEST CASE:
----------
N/A
 
STACK TRACE:
------------
----- Call Stack Trace -----
ksedmp ksfdmp kgerinv kgeasnmierr ktfdfinsert ktssdro_segment ktssdt_segs 
ktmmon ksbrdp 
opirip opidrv sou2o opimai