Re: Validity of HKLM\Software\Oracle\ALL_HOMES\Default_Home ?

Alex Willmer <alex_at_moreati.org.uk> wrote in message news:<nz38c.1642$nX4.14201912_at_news-text.cableinet.net>...
> Dear Experts,
>
> My questions in brief:
>
> 1. On Win32 with Oracle 9.2, should
> HKLM\Software\Oracle\ALL_HOMES\Default_Home point to the current default
> ORACLE_HOME? Or is some sort of useless appendage from a previous
> incarnation?
>
> 2. Would searching the directories listed in %PATH% for the instances of the
> file oracle.key and then referencing it's contents in the registry be a
> valid alternative method?
>
> The longwinded history:
>
> I've been trying to work out the logic that defines the default ORACLE_HOME
> in Windows 2000, with Oracle 9i release 2. We've recently upgraded from 8i
> release 3. The new version was installed to a new ORACLE_HOME and the old
> installation kept, just in case.
>
> The upgrade has thrown up an error in the logic of some backup scripts.
> These inspect the registry key HKLM\Software\Oracle\ALL_HOMES\Default_Home
> to build the full path for running sqlplus. However the ORACLE_HOME named
> by this key is OraHome817, the pre-upgrade original installation; not as I
> expected, OraHome920.
>
> I've run Oracle Home Selector and made sure OraHome920 is the default. I
> even monitored what registry keys were modified and only the key for %PATH%
> is written to. The OUI installed is 2.2, as comes with 9.2 and (I assume)
> comes bundled with Oracle Home Selector.
>
> Any responses gratefully received.
>
> Sincerely
>
> Alex

either:

1. use one account per version for administration (e.g. running scripts) and adjust that user's path.
2. set the path in the script.
3. use the latest version of sqlplus for all cases.

any of these 3 should work just fine for you. your setup (reading the oracle key) might just be overly sophisticated.

OTOH, you could just keep an inittab-style file and parse it to see what database is on what version.

Pd Received on Wed Mar 24 2004 - 02:46:38 CST