ORA-00600: [2103] terminates the instance after a drop tablespace command (Doc ID 456346.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.4 and later   [Release: 9.2 and later ]
z*OBSOLETE: Microsoft Windows 2000
***Checked for relevance on 01-Mar-2012***

Symptoms

You executed a "drop tablespace" statement that failed with ORA-01259, ORA-27056, and OSD-04024 due to O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

Eventually, DBWR crashed the database due to ORA-600: arguments [2103]

Tue May 15 16:45:31 2007
DROP TABLESPACE TWS4#PROCESS#00010 INCLUDING CONTENTS AND DATAFILES
Tue May 15 16:45:32 2007
Errors in file C:\udump\ORCL_ora_2524.trc:
ORA-01259: unable to delete datafile E:\TWS4#PROCESS#000011.ORA
ORA-27056: skgfrdel: could not delete file
OSD-04024: Unable to delete file.
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
Completed: DROP TABLESPACE TWS4#PROCESS#00010 INCLUDING CONTE
Tue May 15 16:45:36 2007
DROP TABLESPACE TWDT#PROCESS_IND0#00001 INCLUDING CONTENTS AND DATAFILES
Tue May 15 16:45:36 2007
DROP TABLESPACE TWS4#PROCESS_IND0#00011 INCLUDING CONTENTS AND DATAFILES
Tue May 15 17:01:06 2007
Errors in file C:\bdump\ORCL_dbw0_2324.trc:
ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []
Tue May 15 17:01:11 2007
Errors in file C:\bdump\twdb_dbw0_2324.trc:
ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []
Tue May 15 17:01:11 2007
DBW0: terminating instance due to error 600


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