Re: oracle's use of NT Registry

Was this machine upgraded from a pre-8i version? Before then, multiple homes did not work well on NT and most, if not all values, went in ORACLE. With the multiple home option, most values are now stored under the appropriate HOMEx key. Non-home specific values (such as those defining the homes themselves) are kept in ORACLE.

This explanation is probably incomplete, as this is only what I have gathered from working with it over the past few years. There may be more caveats as well.

"Ed Stevens" <ed.stevens_at_home.com> wrote in message news:95f5gt$jn0$1_at_nnrp1.deja.com...
> We are a bit confused about some of the uses Oracle makes of the NT
> Registry. (Well, actually I am confused about a lot of things, most of
> which have nothing to do with Oracle, but that's a different story! ;-)
>
> Specifically, we're wondering why the same string values appear in
> HKLM\SOFTWARE\ORACLE and also in HKLM\SOFTWARE\ORACLE\HOME0 -- and, in
> a multi-home system, in HKLM\SOFTWARE\ORACLE\HOME1 thru HOMEn.
>
> Of particular interest is the use of TNS_ADMIN to point to TNSNAMES.ORA
> and SQLNET.ORA. We have had some inconsistent results in trying to
> determine which leaf of the registry is being used. This may be a poor
> example of the more general question because TNS_ADMIN is not created by
> default at installation time. But the general question becomes "how
> does Oracle determine which registry leaf (\ORACLE vs. \ORACLE\HOMEx) it
> is going to look to for any particular key value?" And as a follow-on
> question, " if it is always going to look in \ORACLE\HOMEx, why does it
> bother putting any string values at all in \ORACLE ?
>
> TIA.
>
> --
> - Ed Stevens
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 02 2001 - 15:49:53 CST