-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|