| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dropping a database under unix
I do this to remove a database on solaris :
1. Shut down the instance.
2. Delete all the datafiles, log files, control files of the database.
3. Remove the init{ORACLE_SID} file from $ORACLE_HOME/dbs directory
4. Remove the databases entry from /opt/var/oratab file.
5. Remove the databases entry from $ORACLE_HOME/network/admin/listener.ora file.
6. Remove the databases entry from $ORACLE_HOME/network/admin/tnsnames.ora file.
7. Remove the databases entry from the centrally maintained tnsnames.ora file ( if you
have one)
Thanks
Baiju
Oracle DBA
MBT, Pune India.
dlj wrote:
> Use an OS command of rm filename.
>
> dlj
> --- "Mr. Majestic" <rc_at_neomenia.com> wrote:
> > How do I do this Under svrmgrl on a Solaris? My
> > initial databse wasn't propery created and I need to
> > go back and recreate it.
> >
> > I know you have to remove its datafiles, redo log
> > files, and all other associated files (control
> > files, parameter files, archived log files).
> >
> > But I don't know how it's done under unix.
> >
> > ThanksI, new to unix
> > Student
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Thu Jun 08 2000 - 03:47:29 CDT
 |
 |