How to Drop Database in Oracle 11 Without Using DBCA

First, connect to your Oracle instance as a privileged user and shut down the database by running shutdown immediate in SQL*Plus.

Shut Down the Database

Next, start the Oracle instance in mount mode using the command startup mount. This will ensure the database is mounted but not open, allowing you to drop it safely.

Start the Instance in Mount Mode

Once in mount mode, execute the command drop database; in SQL*Plus. This will delete the database, including all associated data files, control files, and redo logs.

Drop the Database Using SQL Command

After dropping the database, manually remove any remaining data files, control files, and redo logs from the file system. You can do this using standard Linux or Windows commands.

Manually Remove Database Files

On Windows, use the oradim command to remove any Oracle services linked to the database you just dropped. This ensures the services are no longer running.

Remove the Associated Oracle Services

For more advanced Oracle database administration tips and Linux tutorials, visit unixmen.com, where you'll find comprehensive guides on managing databases and systems.

Learn More at unixmen.com