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

Last updated on NOVEMBER 28, 2016

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

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