Re: help: how do you find oracle home on windows

vafanassiev_at_aapt.com.au (Vsevolod Afanassiev) wrote in message news:<4f7d504c.0207180113.73bfa432_at_posting.google.com>...
> By using file "oracle.key". This is how it works
> 1. You can have multiple ORACLE_HOME since 8.0.5. Installer asks into
> what ORACLE_HOME to install.
> 2. Every time a new ORACLE_HOME is created, a new entry in the
> registry is also created.
> 3. In ORACLE_HOME\bin you find a small text file "oracle.key". It is
> created during installation and it points to the corresponding
> ORACLE_HOME
> entry in the registry.
> 4. When you start Oracle utility like SQL*Plus, it looks for file
> "oracle.key" located in the same directory as the utility itself.
> It reads the file, and then find the section in the Registry.
>
> See Oracle8i Administrator's Guide
> Release 2 (8.1.6) for Windows NT
> Jan 2000
> Part No 73008-01
> Page 3-12

Vsevolod,
I understand what you are referring to but what I was trying to say in my post was that if you goto command line and type echo %ORACLE_HOME%, you will not be able to get the value *unless* you explicitly set ORACLE_HOME=.... before that OR if you have created an environment variable called ORACLE_HOME.

Hope this clarifies it.
//Rauf Sarwar Received on Fri Jul 19 2002 - 23:45:42 CDT