Actually, I have installed the Oracle 11g Version 1 in my machine. After that instead of using universal installer for uninstallation manually I had removed the files from installed location.

Now, the impact is if I install the same version in my system, I get the error like the SID is already available in your system.

What are the ways to remove that installed instance details?

Please help me to get know about that.


First, the pro-forma: Better to uninstall the application rather than just delete the files. Yes, it doesn't help, but it is true and someone will bring it up, so saving time...

Now, assuming that you just want the SID to be able to go through. Normally, the SID is stored in the registry HKEY_LOCAL_MACHINE\SOFTWARE\Oracle. It can be in several places there. Please note that several pieces of Oracle software use this key (e.g. Oracle client) so be careful; probably worth backing up with a registry export command first.

You would also need to check the Windows Services (from a command prompt, type "services.msc"). The Oracle services begin with "Oracle" in their name, so they are easy to find. If you see some with the SID in the name, you probably need to remove them before installing. I would use SC.exe to install this as explained here (https://stackoverflow.com/questions/330836/how-to-uninstall-a-windows-service-when-there-is-no-executable-for-it-left-on-th).

If you want a more complete purge, you are in for tons of registry editing, as Oracle often leaves other stuff in the registry.

Good luck, and I hope that this helps,

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy