SQL Developer Error Messages: "Enter the full pathname for java.exe" and "Cannot find a J2SE SDK installed at path"

11

2

Yesterday, I downloaded SQL Developer 3 with SDK and was able to use it just fine. After shutting down my PC last night and booting it up again this morning, every time I try to run it, I get this message:

"Enter the full pathname for java.exe"

I browse to C:\Program Files\Java\jre6\java.exe where the EXE is located and I get this message:

"Cannot find a J2SE SDK installed at path C:\Program Files\Java\jre6\java.exe"

What could be the issue here when it was working just fine yesterday? I will add that my PC did freeze last night during shutdown, so I ended up having to power it off, but I don't know if that's relevant.

I reinstalled Java and it still gives the same message. I also downloaded SQL Developer without the SDK and get the same message. I will also add that I am not actually installing SQL Developer, just running the executable from the folder. I don't think you actually install it anyway.

Anyone know what could be causing this? I am on Windows 7 32-bit.

oscilatingcretin

Posted 2012-01-17T15:00:12.423

Reputation: 4 093

I appear to have fixed it my uninstalling Java and deleting the SQl Developer program folder. I then reinstalled Java and re-extracted SQL Developer and it works now. Before I put this as my answer, I'll see what everyone else has to say, if anything. – oscilatingcretin – 2012-01-17T15:10:04.373

Answers

7

"jre6" in the folder name implies you have JRE installed there, and not the SDK. Point it to somewhere where you have java.exe of a JDK/SDK installation, instead of JRE, and from thereon it should work.

If you had to power off during shutdown, it might've not been able to save the SDK reference, thus asking it on the next startup.

eis

Posted 2012-01-17T15:00:12.423

Reputation: 1 851

2After booting up my PC again today, I was greeted with the error message yet again! I searched my C drive for java.exe and found out that there was a copy deep in the folder that I extracted the ZIP file I downloaded. Specifically, it was in sqldeveloper-3.0.04.34\sqldeveloper\jdk\jre\bin. I pointed it to that and worked! – oscilatingcretin – 2012-01-18T17:48:25.360

4

If your jdk file gets stuck on asking for the jdk file on repeat in windows 7, or you are having problems with the jdk file, try running SQLDeveloper as administrator rather than just the regular startup.

amanda fouts

Posted 2012-01-17T15:00:12.423

Reputation: 41

Sounds like my issue - not giving me an error when I point it to a jdk, just asking again with a fresh, empty dialog -- what do I do if I can't run as administrator? – Code Jockey – 2019-06-12T18:34:12.097

This was my problem. I also recommend that you only open as administrator the once, set the Java path, close and open as normal. You shouldn't need to run as admin more than once. – Dan Atkinson – 2013-05-02T09:46:09.217

2

ibrahim TURK

Posted 2012-01-17T15:00:12.423

Reputation: 21

2

Resolved. It didnt work for me but after spending lot of time , here is what what I did to fix it.

1) Open the file

..\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf 

and add the following line to set jdk path:

SetJavaHome C:\Program Files\Oracle\11g\product\11.1.0\client_1\jdk

If it don’t allow you to save the file, copy whole sqldeveloper folder to a different location where you have write access to modify this file.

2) Run sqldeveloper.exe (from the new place if you moved the folder out from oracle folders) as administrator and enter the jdk path that comes with your oracle installation:

C:\Program Files\Oracle\11g\product\11.1.0\client_1\jdk\bin

It should work then... hope it will help you save hours. - snehal

Snehal Harkawat

Posted 2012-01-17T15:00:12.423

Reputation: 21

At least in version 4 of SQL Developer, there is also a product.conf in your roaming profile that also sets a line for SetJavaHome. If product.conf exists, you either need to rename it, or SetJavaHome there instead of sqldeveloper.conf: http://web.archive.org/web/20150331165602/http://www.thatjeffsmith.com/archive/2013/12/oracle-sql-developer-4-windows-and-the-jdk/

– Sun – 2015-03-31T16:57:38.803

2

I encountered the following message repeatedly when trying to start SQL Developer from my installation of Oracle Database 11g Enterprise: Enter the full pathname for java.exe.

No matter how many times I browsed to the correct path, I kept being presented with the exact same dialog box. This was in Windows 7.

The solution was to right-click on the SQL Developer icon and select "Run as administrator".
I then used this path: C:\app\shellperson\product\11.1.0\db_1\jdk\jre\bin\java.exe

Imran Khan

Posted 2012-01-17T15:00:12.423

Reputation: 21

1

Try entering the full path to java.exe while using SQL Developer. For example:

c:\app\shellperson\product\11.1.0\db_1\jdk\jre\bin\java.exe

RUDRA

Posted 2012-01-17T15:00:12.423

Reputation: 11

1

Try setting the path below. It worked for me.

C:\Program Files\Java\jdk1.7.0_79

To cross check, you can check the path specified to locate JVM in the configuration file:

..\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf 

Sravya Yeramareddy

Posted 2012-01-17T15:00:12.423

Reputation: 11

0

there is some conflict between communicating between java and oracle so oracle is installing an specific java for it self .

try to insert this address :

[ORACLEHOME]\product\12.1.0\dbhome_1\jdk\jre\bin\java.exe

remember [ORACLEHOME] means where your oracle has installed

Hadi Rahjoo

Posted 2012-01-17T15:00:12.423

Reputation: 1

0

If you are in 64 bit environment, you need to install the latest java 6 SE for 32 bit and use that (oracle calls these versions i586 eg, Jdk-6u45-windows-i586.exe).

thedrs

Posted 2012-01-17T15:00:12.423

Reputation: 235

0

I found the file(sqldeveloper.conf) in this path

D:\app\admin\product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin

and then I set the javahome like below, previously it was pointing to the jdk1.7

SetJavaHome C:\Program Files\Java\jdk1.6.0_06

Manoj Kumar

Posted 2012-01-17T15:00:12.423

Reputation: 1

1The key point is that it is D:\app\admin..., because the user is admin, so it will be changed according to the user. And where to look in your pc , the location can be found in the 'path' environment variable'. It is like that in my pc : D:\app\admin\product\11.2.0\dbhome_1 – Manoj Kumar – 2015-04-19T06:53:45.070

You can include you explanation in the answer itself. There is no need for mentioning it separately in the comment. Answers explained in details are always welcomed. :) – Ayan – 2015-04-19T12:23:54.787

0

When SQL developer asks for Java path, mention the path as including java.exe also:

C:\Program Files\Java\jdk1.6.0_06\bin\java.exe

This worked for me.

user482136

Posted 2012-01-17T15:00:12.423

Reputation: 1

Can you clarify your answer- do you mean editing the $PATH variable to include the location you mentioned? If so, how? – bertieb – 2015-08-11T10:05:23.603

-1

Check your sqldeveloper.conf file. It contains:

SetJavaHome ../../jdk

This means when SQL Developer starts up it will look in the ../../jdk folder for java.exe.

Once you've installed a version of JDK, copy the folder to ../../jdk location relative to the sqldeveloper.conf file (which you can find in /bin folder).

/installed folder
    ...
    /dataminer
    /ide
    /javavm
    /jdk   <== create this and copy jdk stuff here
    ...
    sqldeveloper.exe

...

then you won't be prompted with the question.

hak

Posted 2012-01-17T15:00:12.423

Reputation: 1

-1

the solution, in the sqldeveloper.exe icon, press right button clic and the compatibility part, select, run this program in compatibility for ...select Windows XP(Service Pack 3). down select ejecute this program as Administrator, press Acept,

run again the program, select the java folder, press select, ready. this will function.

Anderssi

Posted 2012-01-17T15:00:12.423

Reputation: 1

2The OP states the platform is Windows 7. – suspectus – 2015-08-27T15:57:06.663