Re: I installed Oracle 11g in my home PC. I am trying to open the
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 12 Jun 2009 21:56:17 +0200
Message-ID: <4a32b2da$0$196$e4fe514c_at_news.xs4all.nl>
John Hurley schreef:
> On Jun 12, 2:56 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones)
> wrote:
>
> snip
>
>
> 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.
Date: Fri, 12 Jun 2009 21:56:17 +0200
Message-ID: <4a32b2da$0$196$e4fe514c_at_news.xs4all.nl>
John Hurley schreef:
> On Jun 12, 2:56 pm, yf..._at_vtn1.victoria.tc.ca (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