Re: deleting instance on HP-UX

Toni,

My experience with the dbassist is that this tool is not ready for for prime time. Also, this tool kind-of dumbs down what is really going on. I prefer the manual way of doing things:

1. Take a colde data base backup of the database.
2. sqlplus /nolog
3. connect internal
4. shutdown abort
5. exit
6. cd ~/admin/<ORACLE_SID>/pfile
7. rm initSID.ora
8. cd $ORACLE_HOME/dbs
9. rm initSID.ora

Next go to each mount point where database files exist (i.e. '/u01/oradata/<ORACLE_SID>') and do a rm for all files in these directories.

Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.

In article <3A53BD49.51C0DDC6_at_non.hp.com>,   Toni Graybill <toni_graybill_at_non.hp.com> wrote:
> I have spent all day trying to find some documentation on how to
 delete
> an oracle 8i instance on HP-UX. The utility, dbassist, hangs. Can't
 find
> any documentation on the error message or an alternate manual process.
> I'm plunging on & manually cleaning it up myself, but am posting this
 in
> the hopes someone "older & wiser" may have a better way.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 12:51:33 CST