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
Printable View
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.
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.Quote:
Originally posted by ca152220
...I want to drop the instance..
Jack