My Oracle Support Banner

ORA-00600: internal error code, arguments: [5236], [1024] After Tempfile was Removed (Doc ID 1507757.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

ORA-00600: internal error code, arguments: [5236], [1024], [], [], [], [], [], [], [], [], [], []

Dump continued from file: /SIDS/app/oracle/diag/rdbms/tmrdmd/TMRDMD/trace/TMRDMD_pmon_27065.trc
ORA-00600: internal error code, arguments: [5236], [1024], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 240026 (ORA 600 [5236]) ========

*** 2012-11-08 11:07:25.417
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.

----- Call Stack Trace -----
skdstdst  ksedst1  ksedst  dbkedDefDump  ksedmp ksfdmp  dbgexPhaseII  dbgexProcessError  dbgeExecuteForError  dbgePostErrorKGE 2138  dbkePostKGE_kgsf  kgeade  kgeriv_int  kgeriv kgeasi  ktstrelextent  ktstdt  ktstdropobj  ktaftt ktafat  kxttClnUp  kssxdl  kssdel  kssdch ksuxds  kssxdl  kssdel  kssdch  ksudlp kssxdl  kssdel  ksuxdl  ksuxda_del_proc  ksucln_dpc_cleanup ksucln_dpc_dfs  ksucln_dpc_main  187  ksucln_dpc  ksucln ksbrdp  opirip  opidrv  sou2o  opimai_real ssthrdmain  main  libc_start_main  start

Changes

In alert.log, we see temp file has been removed:

Wed Nov 07 13:31:25 2012
DROP TABLESPACE "TEMP" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
ORA-1031 signalled during: DROP TABLESPACE "TEMP" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS...
Wed Nov 07 13:32:13 2012
alter database tempfile '/SIDS1/oradata/TMRDMD/temp03.dbf' offline
Completed: alter database tempfile '/SIDS1/oradata/TMRDMD/temp03.dbf' offline
alter database tempfile '/SIDS3/oradata/TMRDMD/temp01.dbf' offline
Completed:  alter database tempfile '/SIDS3/oradata/TMRDMD/temp01.dbf' offline
Wed Nov 07 13:32:31 2012
alter database tempfile '/SIDS3/oradata/TMRDMD/temp01.dbf' drop
Completed: alter database tempfile '/SIDS3/oradata/TMRDMD/temp01.dbf' drop
Wed Nov 07 13:32:43 2012
alter database tempfile '/SIDS1/oradata/TMRDMD/temp03.dbf' drop
Completed: alter database tempfile '/SIDS1/oradata/TMRDMD/temp03.dbf' drop
Wed Nov 07 13:33:40 2012
drop tablespace temp
Wed Nov 07 13:35:56 2012
ORA-1013 signalled during: drop tablespace temp...
...
Thu Nov 08 12:43:26 2012
SMON: enabling cache recovery
[32199] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:635443898 end:635444258 diff:360 (3 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
        This condition can occur when a backup controlfile has
        been restored.  It may be necessary to add files to these
        tablespaces.  That can be done using the SQL statement:

        ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

        Alternatively, if these temporary tablespaces are no longer
        needed, then they can be dropped.
          Empty temporary tablespace: TEMP
*********************************************************************

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
Changes
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.