SQL Developer closes abruptly when opening or testing a connection.
Here's what I do.
Open SQL Developer.
Create a connection:
Connection Name: [some string]
Save password: checked
Connection type: TNS
Connect Identifier: somedatabasename
Then I click on "Test" and the application immediately quits. No error messages. The app does the same thing if I save the connection and try to expand its node on the list of connections.
Mind you, if I use sqlplus like so:
It connects just fine.
I captured the output from the command console after SQL Developer crashed:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
_execv() failed, err=2Registered TimesTen
# A fatal error has been detected by the Java Runtime Environment:
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000000006d9f97c5, pid=5480, t
# JRE version: 6.0_43-b01
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.14-b01 mixed mode windows-amd64
# Problematic frame:
# V [jvm.dll+0x1397c5]
# An error report file with more information is saved as:
# If you would like to submit a bug report, please visit:
I am using:
sqldeveloper 3.2.20.09.87 (64-bit)
Java 1.6.0_43 (64-bit)
Windows 7 Enterprise SP1 (64-bit)
ODAC 220.127.116.11.20 x64
Edited by: 993662 on Mar 13, 2013 9:10 AM
What happens if you use a basic connection? Specify the hostname,port and sid/service from your tnsnames directly in SQL Developer.
This will ignore any other oracle components you have and just use JDBC. That may avoid any DLL clash causing your Access Violation Error.
Not necessarily. It may just be a mismatch between the JDBC version in SQL Developer and the OCI and JDBCOCI dlls in ODAC.
I'm not really sure how to go about confirming that. Perhaps someone else here will have some more specific info on versions.
Thanks for your suggestion. After several hours of experimenting, I've managed to fix my problem by copying the ojdbc6.jar from my ODAC installation and replacing the one in [sqldeveloper root]\jdbc\lib
To whomever has a similar issue: See my original post for what software I was using and their version numbers.
Edited by: FrostyZoob on Mar 14, 2013 8:11 AM