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
"Greatest Rewards come only with Greatest Commitments!"
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
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
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 .