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
Printable View
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
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
Thanks a lot jovery for instant reply. Could you plz elaborate step no 3.
Thanks & Regards
Sandy
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
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 .
Thanks a million Jovery and Prakash.
Sandy