Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Upgrade and the Registry

RE: Upgrade and the Registry

From: Vergara, Michael (TEM) <>
Date: Fri, 23 May 2003 12:12:08 -0800
Message-ID: <>

Breathe...Lisa...breathe...'s a long weekend coming up...calm...  

Ok...You can either scrub the Registry or not - your choice. oradim only works on services, not the whole registry. There should be a entry in HKLM\SOFTWARE\ORACLE\ALL_HOMES called DEFAULT_HOME. That's the default. There is a "utility" (I use the term loosely) for setting your current ORACLE_HOME. It works if all you want to do is change the value of ORACLE_HOME; it does NOT change all the other variables in HLKM\SOFTWARE\ORACLE. I think it was built by the OUI team. ;)  

I've never tried running both 8 and 9 on the same machine at the same time, so I don't know about how the services will start and know which HOME to use. However, upgrading is much the same as in UNIX. You load the binaries, shut down v8, reset the environment, start 9, and run u08xxxx.sql.  

If you've already installed v9, then you probably shouldn't completely scrub the Registry. However, there have been times when I've been working on a completely munged system where a registry cleanout was the only hope I had. I would search the Registry for anything that looked like 'ora', delete what I knew about, and then run Registry First Aid to clean out the rest.'s 3:00pm where you are, on a Holiday Friday. This machine will still be waiting for you on Monday. Go to the beach, and have a piņa colada for us!  


-----Original Message-----
Sent: Friday, May 23, 2003 9:17 AM
To: Multiple recipients of list ORACLE-L

Hello all,

Now I'm confused. I have deinstalled as much 8.1.7 crap on my w2k box as the 8.1.7 installer will let me. However, do I need to clean up the registry? How can I tell which home will be the default? I'm concerned about the autostart entries. Under both the 8.1.7 and 9.2 homes (ID0 is pointing to the 81 home, ID1 is pointing to the 92 home) under HOME0 and HOME1, there are startup and shutdown entries for 81 and 92, respectively.

I already ran oradim and deleted the services, suppossedly. Is oradim suppossed to clean up the registry?

Any suggestions are appreciated. Nothing is jumping out at me on Metalink (when it chooses to respond)


Please see the official ORACLE-L FAQ:

Author: Vergara, Michael (TEM)

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 23 2003 - 15:12:08 CDT

Original text of this message