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.
Best Answer
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,