Remove Ora 8i DB from Solaris
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Remove Ora 8i DB from Solaris

  1. #1
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203

    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!"

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Thanks a lot jovery for instant reply. Could you plz elaborate step no 3.
    Thanks & Regards
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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

  6. #6
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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
  •  



Click Here to Expand Forum to Full Width