My Oracle Support Banner

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

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

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.