Removing NT instance from registry

[gps]

Can anyone tell me whether it is possible to remove an instance from the NT registry. The datafiles have been removed and its not possible to remove using database assistant.

[ligang]

In 7.3 , YOu should be able to find the NT instance manager ...

[TerryD]

Yes, if not, use the command line version:

You will need to look up the exact syntax, but I think it's something along the lines of:

7.3 - oradim73
8.0.x - oradim80
8.1.x - oradim (I think)

oradim -DELETE -SID SIDNAME -SRVC

Terry

[gps]

Terry are those unix commands?

I eventually managed to delete the database using database assistant (enabling service) the problem now is deleting the services associated with those instances.

[TerryD]

They are NT commands...

I'm on Unix now though and I can't check the exact syntax for you. To delete the services you would certainly need to use the oradim utility - it's definatley something like:

oradim -DELETE -SID SIDNAME -SRVC

if you run oradim /help from the command prompt it should give you the options. (or oradim73 for Oracle 7.3 etc).

[rschulze]

When this is a non production server you can also open the registry (regedit). Navigate to local machine - system and delete the instance out of the controlsets.

But be carefull, messing too much with the registry can really crash NT.