Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Command line utility to delete database on Solaris.
What about the simple Unix command "rm filename"? A shell script with rm
commands for all files can easily be generated by spooling to file some
simple queries in sqlplus.
There is no Solaris equivalent of "oradim" because services exists only on
Windows.
To remove a database on Unix, just shutdown the instance, remove all files
of the database (datafiles, redolog files and control files), clean up the
files in the directories used for background dump dest, core dump dest,
audit dump dest and user dump dest (which values you can query from
V$PARAMETER) and if you want remove the proper line from file
/var/opt/oracle/oratab (/etc/oratab on most other Unix platforms). Remove
the initSID.ora file in $ORACLE_HOME/dbs (or wherever you stored it) to be
really complete.
If you did a "simply uninstall the software" I think you really should spent
some time getting more familiar with Oracle on Unix. I tried to find a
starting point for you. Maybe others have a better idea but you could look
in the "Oracle Administrators Reference for Sun" (and/or HP, AIX etc...)
You can find it as follows: http://docs.oracle.com, click Database tab,
click the proper version, click Sun Solaris, choose the latest distribution
(like pack v15 for V8.1.7), then download the Administrators Reference for
unix.
I think I can't make it easier for you.
PeterS <member_at_dbforums.com> schreef in berichtnieuws
2011541.1036520072_at_dbforums.com...
|
| Greetings!
|
| Does anybody know about some kind of command line utility to delete a
| database on Solaris?
|
| On Win2K we use 'oradim' command to delete Oracle service and than
| remove database files.
| Currently, to delete a databse on Solaris, we simply uninstall the
| entire Oracle installation, which in its turn is a little messy. Plus
| the next time we need to create a databse, we have to start completely
| brand new install.
| I'd like to keep Oracle software intact.
| I used UI based 'dbassist' tool, but unfortunately it's UI.
|
| Is it possible to run it from command line, like we can do it with
| Oracle silent install?
|
| Thank you in advance!
| Peter.
|
| --
| Posted via http://dbforums.com
Received on Tue Nov 05 2002 - 15:35:34 CST