Delete / drop database

Windows

Check where the ORACLE_HOME for this instance is

Start:Run... services.msc

Double click on OracleService<SID>, the first part of "Path to executable" is the home or regedit and go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE See list of homes

Find location of files to delete

Connect as sys and

select name from v$datafile;
select member from v$logfile;
show parameter control
show parameter dump
show parameter archive_dest

Stop the services related to the instance

set ORACLE_HOME=<oracle home>
oradim -delete -sid <SID>

*Clean up database files:
delete %ORACLE_HOME%\database\PWD<SID>.ora and any pfile, spfile and .dat files
Delete the files and directories shown by above queries

Check in Registry to make sure entries have gone from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<home>

Unix

• Clean up RMAN repository

rman target sys/sys@DBTOGO catalog rman/rman@rmancat
RMAN> unregister database;

• Drop the database (using the silent option of dbca)

. oraenv
DBTOGO
dbca -silent -deleteDatabase -sourceDB DBTOGO
Connecting to database
4% complete
…
100% complete

• Delete database references manually from other places
  • ${ORACLE_HOME}/network/admin/tnsnames.ora (possibly on many hosts)
  • ${ORACLE_HOME}/network/admin/listener.ora (probably only on this host)
  • stop / restart the listener if this db was attached to a general listener
  • remove entry from /etc/oratab
• Is it a clustered database?

If so, remove it from the Veritas (Solaris) or HACMP (AIX) configuration.

• Remove from any monitoring software (Grid, 3rd party)
• Clean any cleanup script where it may be hard-coded (Eek!)
• Delete archivelog directory
• Remove the database definition from backup software