How to manually remove Oracle 10g instance from Windows 2003

Hi experts,

I need to remove a Oracle 10g database instance from Windows 2003. The steps that I've looked up appear to simple. Can you give me the instuctions in a step by step manner? This is a dev/play db so I really can't mess it up.

Thanks,
7Souls
7SoulsData Analyst/Database AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
sventhanCommented:
Use oracle universal installer to remove the oracle Home. DBCA to remove the DB.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
sventhanCommented:
step1: remove the DB using DBCA
step2: remove oracle Home using Oracle universal installer
0
 
Victor TarasovHead of the Department of System AdministrationCommented:
In the past I've had many problems uninstalling all Oracle products from Windows systems. Here's my last resort method:

Uninstall all Oracle components using the Oracle Universal Installer (OUI).
Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.
Delete any references to Oracle services left behind in the following part of the registry (HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*). It should be pretty obvious which ones relate to Oracle.
Reboot your machine.
Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.
Delete the "C:\Program Files\Oracle" directory.
Empty the contents of your "C:\temp" directory.
Empty your recycle bin.

or applied for windows server 2003
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
yuchingCommented:
If you want to remove 10G database instance only then as suggested by others by using DBCA.

If you wish to completely uninstall Oracle from the machine, you can refer http://docs.oracle.com/cd/B19306_01/install.102/b14316/deinstall.htm
0
 
7SoulsData Analyst/Database AdministratorAuthor Commented:
Thank you all I only need to remove one instance. I'm not ready to do it yet I just wanted to know which way to go. Once I remove it I will let you all know how it went and award points.

Thanks,
7Souls
0
 
BajwaCommented:
Use the Oradim utility as shown in this website

http://psoug.org/reference/oradim.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.