Re: I installed Oracle 11g in my home PC. I am trying to open the
From: gazzag <gareth_at_jamms.org>
Date: Mon, 15 Jun 2009 04:16:25 -0700 (PDT)
Message-ID: <dfd5f4b8-2cee-4748-9355-69ec5b7bbd15_at_37g2000yqp.googlegroups.com>
On 12 June, 17:50, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> Windows %ORACLE_HOME% must be new for 11g.
>
> None of my installations have that defined unless I set the value myself.
>
> The oracle provided batch files set it at various stages themselves, but
> always using setlocal so nothing else sees the value later.
>
> My batch files do the following, which finds the first home in the path.
>
> set oracle_home=
> for %%i in (%PATH%) do if %oracle_home%.==. if exist %%i\sqlplus.exe set
> oracle_home=%%i\..
> set oracle_home=%oracle_home:\bin\..=%
>
> $0.10
Date: Mon, 15 Jun 2009 04:16:25 -0700 (PDT)
Message-ID: <dfd5f4b8-2cee-4748-9355-69ec5b7bbd15_at_37g2000yqp.googlegroups.com>
On 12 June, 17:50, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> Windows %ORACLE_HOME% must be new for 11g.
>
> None of my installations have that defined unless I set the value myself.
>
> The oracle provided batch files set it at various stages themselves, but
> always using setlocal so nothing else sees the value later.
>
> My batch files do the following, which finds the first home in the path.
>
> set oracle_home=
> for %%i in (%PATH%) do if %oracle_home%.==. if exist %%i\sqlplus.exe set
> oracle_home=%%i\..
> set oracle_home=%oracle_home:\bin\..=%
>
> $0.10
Malcolm, you are quite right. I meant the Windows registry entry ORACLE_HOME not an environment variable. I didn't make that clear in my posts.
Cheers,
-g Received on Mon Jun 15 2009 - 06:16:25 CDT