How to drop Oracle Instance?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to drop Oracle Instance?

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Location
    Ottawa
    Posts
    12

    Cool How to drop Oracle Instance?

    I used a script to create the database on hp-ux 11 64bit with Oracle Enterprise 9.2.0.1.

    Instance was up, but none of the control files were created.

    I want to drop the instance, re-create the whole things.

    Any advice please?

    Jack

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    shutdown
    rm -r /directories/containing/datafiles OR
    rm /directories/containing/datafiles/* (leaves the directories in place)
    ps -ef | grep ora, kill -9 PID for any remaining process
    rm $ORACLE_HOME/dbs/the_bad_controlfiles
    rm $ORACLE_HOME/dbs/the_bad_init_ora_file
    rm anything else you created related to this database
    That should pretty much get rid of it.

  3. #3
    Join Date
    Mar 2002
    Posts
    200

    Re: How to drop Oracle Instance?

    Originally posted by ca152220

    ...I want to drop the instance..

    Jack
    And I must say there is nothing like "Dropping" an Instance. You can either start it(associate it with a database) or shutdown as stecal has explained.

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