Remove Ora 8i DB from Solaris

[sandycrab]

Hi Friends,
Could anyone plz tell me how to remove/drop Oracle 8i database from Sun SPARC solaris. What are the steps involved...or could anyone plz give some good leads/URLs for the same .
Thanks in Advance
Sandy

[jovery]

If you just want to remove a database:

1. Shutdown the database
2. Remove all datafiles
3. Remove ../admin/instance_name directory tree
4. Remove init_instance_name.ora from $ORACLE_HOME/dbs
5. Remove orapw_instance_name from $ORACLE_HOME/dbs
6. Remove entry from /var/opt/oracle/oratab

Regards

[sandycrab]

Thanks a lot jovery for instant reply. Could you plz elaborate step no 3.
Thanks & Regards
Sandy

[jovery]

The admin tree will be where you have placed your udump/bdump directory settings. For example in one of my hosts here I have the following

$ORACLE_BASE/admin/DB1
in this directory I have udump, bdump, cdump, pfile, create, exp

$ORACLE_BASE/admin/DB2
in this directory I have udump, bdump, cdump, pfile, create, exp

So if I was removing the DB1 database I would delete all of the DB1 directory tree.

Regards

[prakashs43]

if u want to drop the database instance just run dbassist tool to remove all the datafiles and instance.
it will delete files from ur filesystem also ofcourse other folders
udump , bdump ,cdump etc... has to be removed manually . this will ease your second step in teh above list .

if u want to remove binaries as well follow the above procedure .

[sandycrab]

Thanks a million Jovery and Prakash.
Sandy