How to drop Oracle Instance?
I used a script to create the database on hp-ux 11 64bit with Oracle Enterprise 18.104.22.168.
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?
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 anything else you created related to this database
That should pretty much get rid of it.
Re: How to drop Oracle Instance?
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.
Originally posted by ca152220
...I want to drop the instance..
Click Here to Expand Forum to Full Width