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.
Printable View
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.
In 7.3 , YOu should be able to find the NT instance manager ...
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
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.
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).
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.