I installed Oracle 11g in my home PC. I am trying to open the OracleSQL developer. It's asking for Java.exe file. (Enter the full pathname forjava.exe ) What I need to do? Please advice.

Hi,

I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
to open the Oracle SQL developer. It's asking for Java.exe file.
(Enter the full pathname for java.exe )
What I need to do? Please advice.

Thanks,
DK

On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
> Hi,
>
> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
> to open the Oracle SQL developer. It's asking for Java.exe file.
> (Enter the full pathname for java.exe )
> What I need to do? Please advice.
>
> Thanks,
> DK

Do you have the Java Development Kit (JDK) installed on your PC? You
might have downloaded it with SQL Developer. Oracle offers two SQL
Developer downloads, one includes the JDK, one doesn't.

Assuming you have the JDK on your computer, you need to find the
java.exe file and point SQL Developer at that. For example, mine is::

C:\Program Files\sqldeveloper\jdk\jre\bin\java.exe

HTH

-g

On Thu, 11 Jun 2009 17:15:40 -0700, DK wrote:

> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying to
> open the Oracle SQL developer. It's asking for Java.exe file. (Enter the
> full pathname for java.exe ) What I need to do? Please advice.

Have you tried entering the full pathname for java.exe?



--
http://mgogala.freehostia.com

On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
> Hi,
>
> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
> to open the Oracle SQL developer. It's asking for Java.exe file.
> (Enter the full pathname for java.exe )
> What I need to do? Please advice.
>
> Thanks,
> DK

Look under ${ORACLE_HOME}/jdk/bin too.

HTH

-g

gazzag schreef:
> On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
>> Hi,
>>
>> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
>> to open the Oracle SQL developer. It's asking for Java.exe file.
>> (Enter the full pathname for java.exe )
>> What I need to do? Please advice.
>>
>> Thanks,
>> DK
>
> Look under ${ORACLE_HOME}/jdk/bin too.
>
> HTH
>
> -g

Since this is Windows, you should look under %ORACLE_HOME%/jdk/bin.

Shakespeare

On 12 June, 14:36, Shakespeare <what...@xs4all.nl> wrote:
> gazzag schreef:
>
>
>
>
>
> > On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
> >> Hi,
>
> >> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
> >> to open the Oracle SQL developer. It's asking for Java.exe file.
> >> (Enter the full pathname for java.exe )
> >> What I need to do? Please advice.
>
> >> Thanks,
> >> DK
>
> > Look under *${ORACLE_HOME}/jdk/bin too.
>
> > HTH
>
> > -g
>
> Since this is Windows, you should look under %ORACLE_HOME%/jdk/bin.
>
> Shakespeare- Hide quoted text -

Well, if you're going to split hairs, you should look under
%ORACLE_HOME%\jdk\bin :-)

HTH

-g

gazzag (gareth@jamms.org) wrote:
: On 12 June, 14:36, Shakespeare <what...@xs4all.nl> wrote:
: > gazzag schreef:
: >
: >
: >
: >
: >
: > > On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
: > >> Hi,
: >
: > >> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
: > >> to open the Oracle SQL developer. It's asking for Java.exe file.
: > >> (Enter the full pathname for java.exe )
: > >> What I need to do? Please advice.
: >
: > >> Thanks,
: > >> DK
: >
: > > Look under =A0${ORACLE_HOME}/jdk/bin too.
: >
: > > HTH
: >
: > > -g
: >
: > Since this is Windows, you should look under %ORACLE_HOME%/jdk/bin.
: >
: > Shakespeare- Hide quoted text -

: Well, if you're going to split hairs, you should look under
: %ORACLE_HOME%\jdk\bin :-)

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

On Jun 12, 12:50*pm, yf...@vtn1.victoria.tc.ca (Malcolm Dew-Jones)
wrote:

snip

> Windows %ORACLE_HOME% must be new for 11g. *

> set oracle_home=
> for %%i in (%PATH%) do if %oracle_home%.==. if exist %%i\sqlplus.exe set

Some operating systems are more sensitive to case ( lower/upper ) than
other ones.

John Hurley (johnbhurley@sbcglobal.net) wrote:
: On Jun 12, 12:50=A0pm, yf...@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.

On Jun 12, 2:56*pm, yf...@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.

gazzag schreef:
> On 12 June, 14:36, Shakespeare <what...@xs4all.nl> wrote:
>> gazzag schreef:
>>
>>
>>
>>
>>
>>> On 12 June, 01:15, DK <kumardtha...@gmail.com> wrote:
>>>> Hi,
>>>> I am new to Oracle. I installed Oracle 11g in my home PC. I am trying
>>>> to open the Oracle SQL developer. It's asking for Java.exe file.
>>>> (Enter the full pathname for java.exe )
>>>> What I need to do? Please advice.
>>>> Thanks,
>>>> DK
>>> Look under ${ORACLE_HOME}/jdk/bin too.
>>> HTH
>>> -g
>> Since this is Windows, you should look under %ORACLE_HOME%/jdk/bin.
>>
>> Shakespeare- Hide quoted text -
>
> Well, if you're going to split hairs, you should look under
> %ORACLE_HOME%\jdk\bin :-)
>
> HTH
>
> -g
>
>
aaaaaaaaaaaarrrrrrrrrgh... luckily Windows Server understands the / as
well.....

Shakespeare

John Hurley schreef:
> On Jun 12, 2:56 pm, yf...@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

On 12 June, 17:50, yf...@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