How to drop Oracle Instance?

[ca152220]

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

[stecal]

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.

[quester]

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.