Removing a database in Oracle 11g, noting specific files that need to be removed and/or edited for a clean deletion.

This article details the step-by-step for manually removing a database in Oracle 11g, noting specific files that need to be removed and/or edited for a clean deletion.

This page is filed under keyword(s): oracle.

The following steps outlines how to manually delete a database within Oracle 11g, running in an Linux environment. I am currently running Oracle’s Enterprise Linux release 5 update 2.

  • Use SQL*Plus or your favorite SQL command line tool to log in to the target database; log in as sysdba
  • Issue the following commands to get the path to various files
    select name from v$datafile;
    select member from v$logfile;
    select name from v$controlfile;
    select name from v$tempfile;
    
  • Shut down the database within SQL*Plus, and then exit out of SQL*Plus
    shutdown immediate;
    quit;
    
  • Stop the listener service by issuing the following command in the terminal prompt:
    lsnrctl stop
  • Recall the file paths found earlier; use them as a check list as you delete each one of those 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.
  • Go to the $ORACLE_HOME/network/admin directory and delete the tnsnames.ora and listener.ora files
  • Go to the $ORACLE_HOME/dbs directory and delete the init[db_name].ora, orapw[db_name], and spfile[db_name].ora files
  • Go to the $ORACLE_HOME/admin/[db_name]/pfile directory and delete the init[db_name].ora file
  • Go to the $ORACLE_HOME/admin/[db_name]/adump directory and delete all files in that directory
  • Edit the file /etc/oratab by removing the line that starts with your database name
Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: