Delete / drop database - Revision history

Stuart: /* Unix */

2018-04-19T10:33:07Z

‎Unix

Stuart: /* Unix */

2018-02-16T16:09:51Z

‎Unix

Stuart: /* Unix */

2017-09-22T11:37:34Z

‎Unix

Stuart: /* Unix */

2017-09-22T11:36:39Z

‎Unix

Stuart: /* Find location of files to delete */

2017-09-22T11:35:31Z

‎Find location of files to delete

Stuart: /* Unix */

2017-09-20T14:31:09Z

‎Unix

Stuart: /* Unix */

2017-05-17T08:32:19Z

‎Unix

Stuart at 08:31, 17 May 2017

2017-05-17T08:31:03Z

Stuart: Created page with "==Windows== ===Check where the ORACLE_HOME for this instance is===

 Start:Run... services.msc

Double click on OracleService, the first part of "Path to execut..."

2017-05-17T08:30:08Z

Created page with "==Windows== ===Check where the ORACLE_HOME for this instance is=== <pre> Start:Run... services.msc </pre> Double click on OracleService<SID>, the first part of "Path to execut..."

New page

==Windows==
===Check where the ORACLE_HOME for this instance is===
<pre>
Start:Run... services.msc
</pre>
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
<pre>
select name from v$datafile;
select member from v$logfile;
show parameter control
show parameter dump
show parameter archive_dest
</pre>
===Stop the services related to the instance===
<pre>
set ORACLE_HOME=<oracle home>
oradim -delete -sid <SID>
</pre>
<pre>
*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
</pre>
<pre>
Check in Registry to make sure entries have gone from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<home>
==Unix==
===Clean up RMAN repository===
<pre>
rman target sys/sys@DBTOGO catalog rman/rman@rmancat
RMAN> unregister database;
. oraenv
DBTOGO
dbca -silent -deleteDatabase -sourceDB DBTOGO
Connecting to database
4% complete
…
100% complete
</pre>

@@ Line 48: / Line 48: @@
 or
 <pre>
-startup force mount exclusive restrict
+startup force mount restrict
 drop database;
 </pre>

@@ Line 48: / Line 48: @@
 or
 <pre>
-startup mount exclusive restrict
+startup force mount exclusive restrict
 drop database;
 </pre>

@@ Line 43: / Line 43: @@
 Connecting to database
 % complete
-…
+% complete
 % complete
 </pre>

@@ Line 45: / Line 45: @@
 …
 % complete
 </pre>
 * Delete database references manually from other places

@@ Line 13: / Line 13: @@
 select name from v$datafile;
 select member from v$logfile;
-show parameter control
+select member from v$controlfile;
 show parameter dump
 show parameter archive_dest
 </pre>
 ===Stop the services related to the instance===
 <pre>

@@ Line 28: / Line 28: @@
 </pre>
 Check in Registry to make sure entries have gone from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<home>
-==Unix==
+===Unix===
-===Clean up RMAN repository===
+* Clean up RMAN repository
 <pre>
 rman target sys/sys@DBTOGO catalog rman/rman@rmancat
 RMAN> unregister database;
 </pre>
-===Drop the database===
+* Drop the database (using the silent option of dbca)
 <pre>
 . oraenv
@@ Line 44: / Line 44: @@
 % complete
 </pre>