Delete Databases

Available Instance(s)

For Windows : Select the database instance that you want to configure, or delete. The database instance is identified by a unique name, known as the SID, appended to the OracleService. Each database instance corresponds to a series of files. For example, when you delete OracleServiceXXX, you delete the database instance (identified by the SID XXX) and its control file(s), redo log files, and data files. The initialization parameter file is not deleted.

For UNIX or Linux : Select the database instance to delete. Each database is identified by a unique name. The unique name, known as the system identifier (SID), can be up to eight alphanumeric characters in length. Each database instance corresponds to a series of files that contain the SID in their names. For example, if you choose SID oradb to delete, the database instance identified by oradb , its control files, redo log files, and database files will be removed.

Note: In order to change database configuration, or delete a database, you must have that SID (ORACLE_SID) set in the shell from which Oracle Database Configuration Assistant is launched. If no SID is set, you cannot choose to change database configuration, or delete a database. If an incorrect SID is set, you can choose Change database configuration, or Delete a database, but these operations will not work.

User Name

Enter a user name that has SYSDBA privileges.

Password (Windows only)

You will be prompted to enter a password only if your Windows user name is not identified by the Windows operating system as a member of the ORA_DBA or ORA_SID_DBA Windows local group. If you are a member of either local groups, you can delete the selected Oracle Database without entering a password. See the Oracle Database Platform Guide for Microsoft Windows for more information.

Password (Unix or Linux)

You will be prompted for a password only if the user is not OS-authenticated.