Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Apr 25 '13 at 13:54

This question came from our site for professional and enthusiast programmers.

1 Answer 1

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 (http://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,

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.