This content has been marked as final. Show 4 replies
also see that java is version "java version "1.7.0_21""
Is your java 32 or 64 bit?
In your first example, it looks as if you are trying to load a 32-bit dll from a 64-bit program which would indicate a 64-bit jvm.
If you are using Java 7, then it isn't the one downloaded with sql developer.
So, checking what java is running:
java version "1.7.0_21"
Java(TM) SE Runtime Environment (build 1.7.0_21-b11)
Java HotSpot(TM) 64-Bit Server VM (build 23.21-b01, mixed mode)
However, I have C:\oracle\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf showing
Also, I thought that the loading 32 bit on 64 bit system message meant that sql developer was 64 bit. Does it matter is sql dev is 64 or 32 bit and how do I tell which it is?
Also, there is a log file that shows up in the sql dev bin folder that matches the time when the program closes, like hs_err_pid12380.log. It's showing:
# A fatal error has been detected by the Java Runtime Environment:
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000000006d9fd904, pid=13208, tid=8988
# JRE version: 6.0_45-b06
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.45-b01 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# V [jvm.dll+0x11d904]
So, appears that it is using the version specified in the .conf file. However, not seeing useful info in the log file, probably cause there's so much there.
When I try to get it to use the 64 bit driver, sql developer just closes. So, not sure if I'm actually pointing to the right location or what.
finally got it. It turned out it was a mis-match with the driver. I was able to edit my path and point to another version (client 11.2 instead of instant client) and it's now working.
Just a slight difference in the files, like:
ocijdbc11.dll dated 9/28/11 @ 100kb did not work
ocijdbc11.dll dated 3/4/10 @ 135kb did work
It was probably that file along with that file and OCI.dll and OraOCIEI11.dll which were the ones that had their paths change with I changed the environment path (which I saw in the log, here: