Re: How to remove Oracle DB service under win 2000

Hi Harry,

I did this job just yestarday and it is not easy. On Windows 2000 I tried to upgrade Oracle 8i to Oracle EE 8. There is a long check list. Oracle advises just to uninstall the software and reinstalle the EE version.
It didn't work at all on our two machines. Basically I decided to export the entire database and reimport it. Here is what I did:

1. Export of the original DB.
2. Stop all oracle services.
3. Clean the registry. Use regedit.exe and search for Oracle key. Remove all key that references Oracle.
4. Remove ORACLE_SID, LOCAL, ORACLE_HOME etc ... from your settings.
5. Remove the old oracle 8i directories
6. Reboot the machines.
7. Install oracle EE. It will hang when configuring the Listener ... Stop the installer and kill the jrew.exe running.
8. Configure the listener
9. Set ORACLE_SID and LOCAL
10. Create the oracle service with oradim
11. Create the DB with Create Database
12. Import your DB from your export file.

There are more detailled articles in this news group on how to uninstall oracle.
For a 20GB database it takes 7 hours all this work.

Good luck, Andras

Harry <a_at_abc.com> wrote in message news:<5igasuclkij6fq60u528akdalofltdrv8e_at_4ax.com>...
> Using win 2000 (sp3)
>
> Had Oracle 8i installed & need to install the enterprise edition so I
> stopped the oracle services & uninstalled the whole lot using oracle
> installer. However when installing the ent edition I could use the
> same db instance name as used in the standard edition as appaerntly is
> still exists
>
> Windows services still shows this service "OracleServiceDEV" but the
> whole lot was supposed to be removed - how can I remove this so I can
> use the same db instance name?
>
> thanks
>
> harry
Received on Mon Nov 04 2002 - 10:14:33 CST