How to change settings for SQL Developer to correctly recognize current version of SDK

oracle oracle11g oracle-sqldeveloper jdk1.6
Lakshitha Herath picture Lakshitha Herath · Sep 12, 2011 · Viewed 90.2k times · Source

I've installed Oracle 11g r2 to my machine and when I opened Oracle SQL Developer it says: java 1.6.0_02 is not supported and telling me to install new java version.

Then I've installed JDK 1.6.0_27 and set the path in environment variables and run Oracle SQL Developer again, but the same error occurred.

How can I change the settings for Oracle SQL Developer to recognize 1.6.0_27 as my SDK?

Answer

Atilla Ozgur picture Atilla Ozgur · Nov 14, 2018

In windows 10, I needed to go to following folder and change following product.conf file and set SetJavaHome directive.

%APPDATA%\sqldeveloper\<product-version>\product.conf

in my machine:

C:\Users\ati_o\AppData\Roaming\sqldeveloper\17.4.0\product.conf

with following line.

SetJavaHome C:\Tools\oraclejdk8

Thanks to comment from @thatjeffsmith, in MacOS or Linux/Unix, go to:

$HOME/.sqldeveloper/<product-version>/product.conf

to set same SetJavaHome directive.

Related questions

How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use …

Read More
Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted to explicitly set one column to null? How do I do that in the SQL Developer GUI? Previously in MSSQL, …

Read More
How to increase buffer size in Oracle SQL Developer to view all records?

How to increase buffer size in Oracle SQL Developer to view all records (there seems to be a certain limit set at default)? Any screen shots and/or tips will be very helpful.

Read More