Re: I installed Oracle 11g in my home PC. I am trying to open the

From: Shakespeare <>
Date: Fri, 12 Jun 2009 21:56:17 +0200
Message-ID: <4a32b2da$0$196$>

John Hurley schreef:
> On Jun 12, 2:56 pm, (Malcolm Dew-Jones)
> wrote:
> snip
>> : > Windows %ORACLE_HOME% must be new for 11g. =A0
>> : > set oracle_home=3D
>> : > for %%i in (%PATH%) do if %oracle_home%.=3D=3D. if exist %%i\sqlplus.exe =
>> : set
>> : Some operating systems are more sensitive to case ( lower/upper ) than
>> : other ones.
>> uh, yes, but the above is for Windows which doesn't care about case.
>> I have never seen an oracle install on windows which resulted in an
>> environment variable called ORACLE_HOME being available (upper or lower
>> case).  If you wish to write a general purpose batch file that runs on
>> Windows that references the oracle home then it has to find it itself.
>> The one environment variable that is always set up by the Windows oracle
>> install is PATH, and the home can be determined from that.
>> The things installed by Oracle in Windows (batch files, short cuts, etc)  
>> all have the path hard coded into them.
>> Anyway, perhaps that has changed in 11g.

> Could be I don't really do anything with oracle on windows.
> I was trying to point out that the comment someone made about
> ORACLE_HOME on windows could easily have also meant oracle_home since
> windows is not case sensitive ... guess I did a bad job in attempting
> to point that out.

Indeed, Oracle on Windows does not install any environment variable named ORACLE_HOME (both name and value case insensitive by the way). Strange enough, some utilities demand that ORACLE_HOME has been set. But in the case of the OP, I just meant to look for his .exe file in the oracle home directory, and most Windows users who are not familiar to Unix/Linux do not understand the $ORACLE_HOME notation, but do recognize %ORACLE_HOME%. Shakespeare Received on Fri Jun 12 2009 - 14:56:17 CDT

Original text of this message