-
Remove Ora 8i DB from Solaris
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
"Greatest Rewards come only with Greatest Commitments!"
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Thanks a lot jovery for instant reply. Could you plz elaborate step no 3.
Thanks & Regards
Sandy
"Greatest Rewards come only with Greatest Commitments!"
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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 .
siva prakash
DBA
-
Thanks a million Jovery and Prakash.
Sandy
"Greatest Rewards come only with Greatest Commitments!"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|