SQL Developer

Hi,

We are trying to find a workable alternative to TOAD and have tried to install SQL Developer with not much success.... I think I am just about to give up but hope this last attempt to post for help can create a miracle.

I would appreciate very much if any one knows of a comprehensive document out there that can help trouble shoot the installation problems.

Let me give you the hardware and software versions first and then the problems.
1) SQL Developer tried: sqldeveloper-1.2.1.3213-no-jre and sqldeveloper-1.2.1.3213
2) JRE tried: JRE 1.5 and JRE 6 (C:\Program Files\Java\jre1.6.0_03)
3) Window: XP Professional version 2002 Service pack 2
4) Hardware: Intel Pentium 4 CPU 2.80 GHz, 1.98 GB of RAM

Problems:
1) SQL Developer could not find native JDBC. I don't understand why, despite all the variables set in Oracleclient10g_basic in the registry, SQL Developer did not seem to be able to find a 10g client on a network drive. I have to install 10g client directly onto my pc (C:\oracle\product\10.2.0\client_1) to solve this problem.

2) SQL Developer abruptly disappeared after database login.
I was able to connect and log into an Oralce 10g database with TNS Connect Identifier approach. There were objects (tables, views, etc) showed up briefly on the left hand side of the SQL Developer and then it just completely disappeared without even an error message or a tearful good-bye.

The only thing I can find is this error log about EXCEPTION_ACCESS_VIOLATION. After hours searching through OTN for possible mentioning of this error with SQL Developer, I found nothing so far.

Why is it so difficult to install SQL Developer? Are there a set of un-spoken pre-requisites that has to be satisfied before it can be installed properly? If so, what are they? Path system variable? Registry? Anything else?

Here's the complete EXCEPTION_ACCESS_VIOLATION error log:
#
# An unexpected error has been detected by Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x2ca5683c, pid=952, tid=2576
#
# Java VM: Java HotSpot(TM) Client VM (1.6.0_03-b05 mixed mode, sharing)
# Problematic frame:
# C [OraOCIEI10.dll+0x4f683c]
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#

--------------- T H R E A D ---------------

Current thread (0x04330400): JavaThread "Init Insight" [_thread_in_native, id=2576]

siginfo: ExceptionCode=0xc0000005, reading address 0x00000000

Registers:
EAX=0x31a28e40, EBX=0x00000000, ECX=0x03231622, EDX=0x00000000
ESP=0x04b0f168, EBP=0x04b0f1a8, ESI=0x00000001, EDI=0x0413ded4
EIP=0x2ca5683c, EFLAGS=0x00010297

Top of Stack: (sp=0x04b0f168)
0x04b0f168: 00000001 00a3fb8e 0000000a 00000001
0x04b0f178: 0413c78c 00000001 02c52aa8 0000000a
0x04b0f188: 00000020 00a4047e 090ea038 0413def4
0x04b0f198: 03231622 6d8a87b3 032325c1 0413c78c
0x04b0f1a8: 04b0f1d8 2ca57072 0413ded4 032325c1
0x04b0f1b8: 00000001 00000000 03231620 03231622
0x04b0f1c8: 00000000 00000000 00000000 00000000
0x04b0f1d8: 04b0f234 2ca56e06 0413c78c 0413ded4

Instructions: (pc=0x2ca5683c)
0x2ca5682c: 5c 00 a1 80 58 b3 31 88 9f c4 00 00 00 8b 14 98
0x2ca5683c: 8b 0a 81 e1 00 80 00 00 89 4d dc 0f 85 90 03 00


Stack: [0x04ac0000,0x04b10000), sp=0x04b0f168, free space=316k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
C [OraOCIEI10.dll+0x4f683c]
C [OraOCIEI10.dll+0x4f7072]
C [OraOCIEI10.dll+0x4f6e06]
C [OraOCIEI10.dll+0x419685]
C [OCI.dll+0x7333]

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
j oracle.jdbc.driver.T2CStatement.t2cParseExecuteDescribe(Loracle/jdbc/driver/OracleStatement;JIIIZZZZ[BIBII[SI[B[CII[SII[B[CII[I[S[BIIIIZZ[Loracle/jdbc/driver/Accessor;[[[B[J[BI[CI[SIZ)I+0
j oracle.jdbc.driver.T2CCallableStatement.executeForDescribe()V+271
j oracle.jdbc.driver.T2CCallableStatement.executeForRows(Z)V+41
j oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()V+275
j oracle.jdbc.driver.OraclePreparedStatement.executeInternal()I+94
j oracle.jdbc.driver.OraclePreparedStatement.execute()Z+17
j oracle.jdbc.driver.OracleCallableStatement.execute()Z+60
j oracle.dbtools.raptor.insight.CompletionInsight.getInsightableOracleDatabase(Loracle/javatools/db/Database;)Loracle/dbtools/raptor/insight/InsightableDatabase;+70
j oracle.dbtools.raptor.insight.CompletionInsight.<init>(Loracle/ide/Context;Loracle/javatools/db/Database;)V+161
j oracle.dbtools.sqlworksheet.sqlview.SqlEditorMainPanel$5.run()V+52
j java.lang.Thread.run()V+11
v ~StubRoutines::call_stub

--------------- P R O C E S S ---------------

Java Threads: ( => current thread )
=>0x04330400 JavaThread "Init Insight" [_thread_in_native, id=2576]
0x0416ac00 JavaThread "Timer-4" [_thread_blocked, id=1460]
0x0412cc00 JavaThread "Timer-3" [_thread_blocked, id=2544]
0x04323800 JavaThread "WeakDataReference polling" [_thread_blocked, id=3756]
0x0315cc00 JavaThread "Image Fetcher 3" daemon [_thread_blocked, id=3412]
0x02c17c00 JavaThread "Image Fetcher 2" daemon [_thread_blocked, id=2124]
0x04324800 JavaThread "Image Fetcher 1" daemon [_thread_blocked, id=2088]
0x04321800 JavaThread "Image Fetcher 0" daemon [_thread_blocked, id=276]
0x02ca2c00 JavaThread "WaitCursorTimer" daemon [_thread_blocked, id=2096]
0x00296800 JavaThread "DestroyJavaVM" [_thread_blocked, id=3816]
0x02cb0400 JavaThread "Timer-1" [_thread_blocked, id=2832]
0x02c32000 JavaThread "IconOverlayTracker Timer" [_thread_blocked, id=1204]
0x04060800 JavaThread "Log Page Updater" [_thread_blocked, id=2160]
0x03323800 JavaThread "TimerQueue" daemon [_thread_blocked, id=3996]
0x032d1800 JavaThread "AWT-EventQueue-0" [_thread_blocked, id=4004]
0x032ca400 JavaThread "AWT-Windows" daemon [_thread_in_native, id=1488]
0x032c9800 JavaThread "AWT-Shutdown" [_thread_blocked, id=256]
0x032c8400 JavaThread "Java2D Disposer" daemon [_thread_blocked, id=1064]
0x02c0d000 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2956]
0x02c08400 JavaThread "CompilerThread0" daemon [_thread_blocked, id=3236]
0x02c07400 JavaThread "Attach Listener" daemon [_thread_blocked, id=3248]
0x02c06800 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=3232]
0x02bfe400 JavaThread "Finalizer" daemon [_thread_blocked, id=2328]
0x02bfd400 JavaThread "Reference Handler" daemon [_thread_blocked, id=1668]

Other Threads:
0x02bfc000 VMThread [id=2868]
0x02c0e800 WatcherThread [id=2940]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

Heap
def new generation total 1536K, used 500K [0x06960000, 0x06b00000, 0x090c0000)
eden space 1408K, 26% used [0x06960000, 0x069bd3b0, 0x06ac0000)
from space 128K, 100% used [0x06ac0000, 0x06ae0000, 0x06ae0000)
to space 128K, 0% used [0x06ae0000, 0x06ae0000, 0x06b00000)
tenured generation total 19372K, used 12857K [0x090c0000, 0x0a3ab000, 0x26960000)
the space 19372K, 66% used [0x090c0000, 0x09d4e400, 0x09d4e400, 0x0a3ab000)
compacting perm gen total 22272K, used 22205K [0x26960000, 0x27f20000, 0x2a960000)
the space 22272K, 99% used [0x26960000, 0x27f0f780, 0x27f0f800, 0x27f20000)
ro space 8192K, 62% used [0x2a960000, 0x2ae614a8, 0x2ae61600, 0x2b160000)
rw space 12288K, 52% used [0x2b160000, 0x2b7a7278, 0x2b7a7400, 0x2bd60000)

Dynamic libraries:
0x00400000 - 0x00423000 C:\WINDOWS\system32\java.exe
0x7c900000 - 0x7c9b0000 C:\WINDOWS\system32\ntdll.dll
0x7c800000 - 0x7c8f5000 C:\WINDOWS\system32\kernel32.dll
0x77dd0000 - 0x77e6b000 C:\WINDOWS\system32\ADVAPI32.dll
0x77e70000 - 0x77f02000 C:\WINDOWS\system32\RPCRT4.dll
0x77fe0000 - 0x77ff1000 C:\WINDOWS\system32\Secur32.dll
0x7c340000 - 0x7c396000 C:\Program Files\Java\jre1.6.0_03\bin\msvcr71.dll
0x6d7c0000 - 0x6da0a000 C:\Program Files\Java\jre1.6.0_03\bin\client\jvm.dll
0x7e410000 - 0x7e4a0000 C:\WINDOWS\system32\USER32.dll
0x77f10000 - 0x77f57000 C:\WINDOWS\system32\GDI32.dll
0x76b40000 - 0x76b6d000 C:\WINDOWS\system32\WINMM.dll
0x6d310000 - 0x6d318000 C:\Program Files\Java\jre1.6.0_03\bin\hpi.dll
0x76bf0000 - 0x76bfb000 C:\WINDOWS\system32\PSAPI.DLL
0x6d770000 - 0x6d77c000 C:\Program Files\Java\jre1.6.0_03\bin\verify.dll
0x6d3b0000 - 0x6d3cf000 C:\Program Files\Java\jre1.6.0_03\bin\java.dll
0x6d7b0000 - 0x6d7bf000 C:\Program Files\Java\jre1.6.0_03\bin\zip.dll
0x6d000000 - 0x6d1c3000 C:\Program Files\Java\jre1.6.0_03\bin\awt.dll
0x73000000 - 0x73026000 C:\WINDOWS\system32\WINSPOOL.DRV
0x77c10000 - 0x77c68000 C:\WINDOWS\system32\msvcrt.dll
0x76390000 - 0x763ad000 C:\WINDOWS\system32\IMM32.dll
0x774e0000 - 0x7761d000 C:\WINDOWS\system32\ole32.dll
0x5ad70000 - 0x5ada8000 C:\WINDOWS\system32\uxtheme.dll
0x73760000 - 0x737a9000 C:\WINDOWS\system32\ddraw.dll
0x73bc0000 - 0x73bc6000 C:\WINDOWS\system32\DCIMAN32.dll
0x6d2b0000 - 0x6d303000 C:\Program Files\Java\jre1.6.0_03\bin\fontmanager.dll
0x74720000 - 0x7476b000 C:\WINDOWS\system32\MSCTF.dll
0x7c9c0000 - 0x7d1d7000 C:\WINDOWS\system32\shell32.dll
0x77f60000 - 0x77fd6000 C:\WINDOWS\system32\SHLWAPI.dll
0x773d0000 - 0x774d3000 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03\comctl32.dll
0x5d090000 - 0x5d12a000 C:\WINDOWS\system32\comctl32.dll
0x77b40000 - 0x77b62000 C:\WINDOWS\system32\Apphelp.dll
0x77c00000 - 0x77c08000 C:\WINDOWS\system32\VERSION.dll
0x03850000 - 0x0386a000 C:\sqldeveloper-1.2.1.3213-no-jre\sqldeveloper\ide\lib\idenative.dll
0x77120000 - 0x771ab000 C:\WINDOWS\system32\OLEAUT32.dll
0x6d570000 - 0x6d583000 C:\Program Files\Java\jre1.6.0_03\bin\net.dll
0x71ab0000 - 0x71ac7000 C:\WINDOWS\system32\WS2_32.dll
0x71aa0000 - 0x71aa8000 C:\WINDOWS\system32\WS2HELP.dll
0x6d590000 - 0x6d599000 C:\Program Files\Java\jre1.6.0_03\bin\nio.dll
0x605d0000 - 0x605d9000 C:\WINDOWS\system32\mslbui.dll
0x6d220000 - 0x6d243000 C:\Program Files\Java\jre1.6.0_03\bin\dcpr.dll
0x71a50000 - 0x71a8f000 C:\WINDOWS\System32\mswsock.dll
0x76f20000 - 0x76f47000 C:\WINDOWS\system32\DNSAPI.dll
0x76fb0000 - 0x76fb8000 C:\WINDOWS\System32\winrnr.dll
0x76f60000 - 0x76f8c000 C:\WINDOWS\system32\WLDAP32.dll
0x66210000 - 0x66219000 C:\WINDOWS\system32\netware\NWWS2NDS.DLL
0x50d50000 - 0x50d98000 C:\WINDOWS\system32\NETWIN32.DLL
0x50d00000 - 0x50d15000 C:\WINDOWS\system32\CLNWIN32.DLL
0x50df0000 - 0x50e10000 C:\WINDOWS\system32\LOCWIN32.DLL
0x50db0000 - 0x50ddc000 C:\WINDOWS\system32\NCPWIN32.dll
0x71ad0000 - 0x71ad9000 C:\WINDOWS\system32\WSOCK32.dll
0x66220000 - 0x6622c000 C:\WINDOWS\system32\netware\NWWS2SLP.DLL
0x66250000 - 0x66257000 C:\WINDOWS\system32\NWSRVLOC.dll
0x76fc0000 - 0x76fc6000 C:\WINDOWS\system32\rasadhlp.dll
0x662b0000 - 0x66308000 C:\WINDOWS\system32\hnetcfg.dll
0x71a90000 - 0x71a98000 C:\WINDOWS\System32\wshtcpip.dll
0x6d560000 - 0x6d569000 C:\Program Files\Java\jre1.6.0_03\bin\management.dll
0x62f00000 - 0x62f13000 C:\oracle\product\10.2.0\client_1\ocijdbc10.dll
0x03e50000 - 0x03ea7000 C:\oracle\product\10.2.0\client_1\OCI.dll
0x2c560000 - 0x31bf6000 C:\oracle\product\10.2.0\client_1\OraOCIEI10.dll
0x77a80000 - 0x77b14000 C:\WINDOWS\system32\CRYPT32.dll
0x77b20000 - 0x77b32000 C:\WINDOWS\system32\MSASN1.dll

VM Arguments:
jvm_args: -Xmx512M -Xverify:none -XX:JavaPriority10_To_OSPriority=10 -XX:JavaPriority9_To_OSPriority=9 -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Dsun.java2d.ddoffscreen=false -Dwindows.shell.font.languages= -Dide.conf=sqldeveloper.conf -Dide.home.dir.name=.sqldeveloper
java_command: oracle.ide.boot.Launcher
Launcher Type: SUN_STANDARD

Environment Variables:
PATH=C:\oracle\product\10.2.0\client_1;X:\oracle10g\product\10.2.0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH;C:\Program Files\IDM Computer Solutions\UltraEdit-32
USERNAME=leexx255
OS=Windows_NT
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel



--------------- S Y S T E M ---------------

OS: Windows XP Build 2600 Service Pack 2

CPU:total 1 (1 cores per cpu, 1 threads per core) family 15 model 2 stepping 9, cmov, cx8, fxsr, mmx, sse, sse2

Memory: 4k page, physical 2079468k(1385300k free), swap 4021668k(3516444k free)

vm_info: Java HotSpot(TM) Client VM (1.6.0_03-b05) for windows-x86, built on Sep 24 2007 22:24:33 by "java_re" with unknown MS VC++:1310


Is this a java problem? SQL Developer problem? Or something else?

Thanks in advance,

a TOAD lover