Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Command line utility to delete database on Solaris.

Re: Command line utility to delete database on Solaris.

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Tue, 5 Nov 2002 22:35:34 +0100
Message-ID: <3dc839a9$0$46611$e4fe514c@news.xs4all.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US