Edit the file /etc/oratab by removing the line that starts with your database name.Go to the $ORACLE_HOME/admin//adump directory and delete all files in that directory.Go to the $ORACLE_HOME/admin//pfile directory and delete the init.ora file.Go to the $ORACLE_HOME/dbs directory and delete the init.ora, orapw, and spfile.ora files.Go to the $ORACLE_HOME/network/admin directory and delete the tnsnames.ora and listener.ora files.Reminder: did you back up your database yet? When ready, go ahead delete your data files, redo log files, control files, and temp files. Recall the file paths found earlier use them as a check list as you delete each one of those files.

Stop the listener service by issuing the following command in the terminal prompt:įrom Oralce Linux account do: lsnrctl stop Shut down the database within SQL*Plus, and then exit out of SQL*Plus sqlplus ' / as sysdba' shutdown immediate Type the following commands to get the path to various files: select name from v$datafile Use SQL*Plus or your favorite SQL command line tool to log in to the target database log in as sysdba I have Centos 6 system with Oralce 11G installed. The following steps shows how to manually delete a database within Oracle 11g, running in an Linux environment. How to delete Oracle 11g database manually?

Dupeguru picture mode linux