Re: Cannot delete a database instance

"Edwinah63" <edwinah_at_customercare.com.au> wrote in message news:d714e824.0402242117.73dcfcb6_at_posting.google.com...
> Hi everyone,
>
> i am trying to delete a database 'Assist'. i have:
>
> * oracle 9i
> * win 2k

> what do i need to check? how can i delete this bl**dy database?

Thanks for the kind words. It is a bit invidious to name folk as there are a *lot* of helpful people here.

To delete a database on win2k you should only need to

stop the service
run oradim -delete -sid <sid>
delete all the files from disk.

You might wish first to delete the database from listener.ora and restart the listener and tnsnames.ora as well. This will stop people from connecting to the database. to delete from OEM I *think* that you have to delete the node, carry out the database delete and the deletes from the listener, and rediscover the node. I suspect that there might be an easier way, but I am not familiar with it if so. If you have jobs and events registered against targets on the node you would need to deregister them first so it does become somewhat complex getting the order right.

hope this helps

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK