Oracle SQL Developer is a popular tool to connect to Oracle database and perform SQL queries (and not only). When you start SQL Developer for the first time it asks you where your Java SDK is.
You enter your JDK path and Oracle SQL Developer uses it for running in Java JVM. Now what if you want to change it? It is easy. Open [sqldeveloper_installation]\sqldeveloper\bin\sqldeveloper.conf (on my machine the path is C:\tools\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf) and modify it as following:
That is, comment out or remove the old path to Java SDK and place the new path. Now restart Oracle SQL Developer and verify that it uses the new path by going "Help->About" and selecting "Properties" tab:
8 comments:
Excellent, thanks!!
Thanks. This was spot on and save me a ton of time.
Awesome. Thanks :)
very useful, thank you for posting.
very helpful.. thanks..
Really helpful...
But sometimes, even after changing this wont work. In that case, need to perform the following.
Go to
C:\Users\\AppData\Roaming\sqldeveloper\1.0.0.0.0 for WIN 7
Or
C:\Documents and Settings\\AppData\Roaming\sqldeveloper\1.0.0.0.0 for WIN Xp
Open the Product.conf file
Modify the correct java path there and save the file.
Restart the SQL Developer which will solve the issue.
sometime on windows 7, you need to be administrator for this to work. Not all PCs allow this, but
1. right click the short cut and select "run as administrator"
2. enter the correct java path
3. SQL developer will save this into the conf file
you won't need to do this until you want to change the path again
I still have the previous path in Properties and I don't find Product.conf
Do you have another solution for Windows 7?
Thanks
Post a Comment