7 Replies Latest reply on Jul 25, 2019 9:38 PM by st*2977432*sa

    sql developer hangs on startup

    st*2977432*sa

      I can't get SQL Developer 19.1 started. I've downloaded with, and without the included JDK. And I've tried separate installs of JDK 32 bit and 64, these two versions specifically:

      jdk-12.0.2_windows-x64_bin.exe

      jdk-8u221-windows-i586.exe

       

      I've reset java_home and the path environment variables for each install.

       

      I've tried deleting the entire sqldeveloper directory, and subdirectories from here, and watched them be recreated...

      C:\Users\VHASLCMartiS\AppData\Roaming\sqldeveloper\19.1.0

       

      I'm on windows 7.

        • 1. Re: sql developer hangs on startup
          thatJeffSmith-Oracle

          >>jdk-12.0.2_windows-x64_bin.exe

          This won't work. At least not until version 19.2 of SQL Developer is released (due soon!)

           

          So you'll need to use

          >>jdk-8u221

           

          And you'll want to make sure that the product.conf file is pointing to that Oracle Java JDK 8 home under your roaming\sqldeveloper\19.1.0 folder.

           

          With that done, open a cmd window, and CD to your sqldeveloper\sqldeveloper\bin folder.

           

          Run the sqldveloper.exe file, what exactly do you see?

           

          Jeff

           

          • 2. Re: sql developer hangs on startup
            st*2977432*sa

            My dos window is administrator...

             

            C:\WINDOWS\system32>whoami

            vhamaster\vhaslcmartis0

             

            C:\>whoami

            VHAMASTER\VHASLCMartiS0

             

            C:\>rd /S /Q "C:\Users\vhaslcmartis0\AppData\Roaming\SQL Developer\"

            The system cannot find the file specified.

             

            C:\>rd /S /Q "C:\Users\VHASLCMartiS0\AppData\Roaming\sqldeveloper\"

            The system cannot find the file specified.

             

            C:\>cd /d c:\oracle\sqldeveloper19\

             

            c:\oracle\sqldeveloper19>C:\oracle\Java\jdk-8.221\bin\java.exe -version

            java version "1.8.0_221"

            Java(TM) SE Runtime Environment (build 1.8.0_221-b11)

            Java HotSpot(TM) Client VM (build 25.221-b11, mixed mode)

             

             

            c:\oracle\sqldeveloper19>.\sqldeveloper.exe

             

            SQL Developer hangs but lots of files are created...

             

            dir /S "C:\Users\VHASLCMartiS0\AppData\Roaming\sqldeveloper\"

            07/24/2019  06:21 PM             2,804 product.conf

             

            dir /S "C:\Users\vhaslcmartis0\AppData\Roaming\SQL Developer\"

            67 files created

             

            SQL Developer still stuck...minutes later, or the next week...

             

            pskill sqldeveloper

            Process sqldeveloper killed.

            • 3. Re: sql developer hangs on startup
              st*2977432*sa

              c:\oracle\sqldeveloper19>cd sqldeveloper\bin

               

              c:\oracle\sqldeveloper19\sqldeveloper\bin>.\sqldeveloper.exe

              Custom UI class oracle.bali.ewt.olaf2.OracleLookAndFeel not found.

              • 4. Re: sql developer hangs on startup
                st*2977432*sa

                Here's the full stack trace, from pressing Ctrl-BREAK in the command window...

                 

                c:\oracle\sqldeveloper19\sqldeveloper\bin>echo %java_home%

                C:\oracle\Java\jdk-8.221

                 

                c:\oracle\sqldeveloper19\sqldeveloper\bin>sqldeveloper.exe

                Custom UI class oracle.bali.ewt.olaf2.OracleLookAndFeel not found.

                2019-07-24 19:12:30

                Full thread dump Java HotSpot(TM) Client VM (25.221-b11 mixed mode):

                 

                "Framework Event Dispatcher" #26 daemon prio=5 os_prio=0 tid=0x080a5000 nid=0x8e0c in Object.wait() [0x0a2ff000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x215d92a8> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

                        at java.lang.Object.wait(Object.java:502)

                        at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)

                        - locked <0x215d92a8> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

                        at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336)

                 

                "Framework Active Thread" #23 prio=5 os_prio=0 tid=0x080a4400 nid=0x39a8 in Object.wait() [0x09ddf000]

                  java.lang.Thread.State: TIMED_WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x215d97d8> (a org.eclipse.osgi.framework.internal.core.Framework)

                        at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1870)

                        - locked <0x215d97d8> (a org.eclipse.osgi.framework.internal.core.Framework)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.TimedSoftReference]" #22 daemon prio=1 os_prio=-2 tid=0x080a4000 nid=0x9fc in Object.wait() [0x0886f000]

                  java.lang.Thread.State: TIMED_WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd2bc0> (a java.lang.Object)

                        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2002)

                        - locked <0x20dd2bc0> (a java.lang.Object)

                 

                "Active Reference Queue Daemon" #19 daemon prio=1 os_prio=-2 tid=0x05fcf000 nid=0x6bf4 in Object.wait() [0x07c2f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd31e0> (a java.lang.ref.ReferenceQueue$Lock)

                        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)

                        - locked <0x20dd31e0> (a java.lang.ref.ReferenceQueue$Lock)

                        at org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper(ActiveQueue.java:93)

                        at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:131)

                 

                "TimerQueue" #17 daemon prio=5 os_prio=0 tid=0x05db8c00 nid=0x8fe4 waiting on condition [0x0706f000]

                  java.lang.Thread.State: TIMED_WAITING (parking)

                        at sun.misc.Unsafe.park(Native Method)

                        - parking to wait for  <0x20dd3380> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                        at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)

                        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)

                        at java.util.concurrent.DelayQueue.take(DelayQueue.java:223)

                        at javax.swing.TimerQueue.run(TimerQueue.java:174)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "AWT-EventQueue-0" #16 prio=6 os_prio=0 tid=0x05d7a800 nid=0x8a28 waiting on condition [0x06acf000]

                  java.lang.Thread.State: WAITING (parking)

                        at sun.misc.Unsafe.park(Native Method)

                        - parking to wait for  <0x20dd3560> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

                        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)

                        at java.awt.EventQueue.getNextEvent(EventQueue.java:554)

                        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:187)

                        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

                        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

                        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

                        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

                        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

                 

                "Thread-3" #15 daemon prio=5 os_prio=0 tid=0x05d62400 nid=0x8784 runnable [0x0687f000]

                  java.lang.Thread.State: RUNNABLE

                        at com.sun.java.accessibility.AccessBridge.runDLL(Native Method)

                        at com.sun.java.accessibility.AccessBridge.access$300(AccessBridge.java:57)

                        at com.sun.java.accessibility.AccessBridge$dllRunner.run(AccessBridge.java:141)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "EventQueueMonitor-ComponentEvtDispatch" #14 daemon prio=5 os_prio=0 tid=0x05d76000 nid=0x772c in Object.wait() [0x0671f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd3940> (a java.lang.Object)

                        at java.lang.Object.wait(Object.java:502)

                        at com.sun.java.accessibility.util.ComponentEvtDispatchThread.run(EventQueueMonitor.java:582)

                        - locked <0x20dd3940> (a java.lang.Object)

                 

                "AWT-Windows" #11 daemon prio=6 os_prio=0 tid=0x05d2bc00 nid=0x2e78 runnable [0x065df000]

                  java.lang.Thread.State: RUNNABLE

                        at sun.awt.windows.WToolkit.eventLoop(Native Method)

                        at sun.awt.windows.WToolkit.run(WToolkit.java:315)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "AWT-Shutdown" #10 prio=5 os_prio=0 tid=0x05d22000 nid=0x3f44 in Object.wait() [0x0649f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd3ca8> (a java.lang.Object)

                        at java.lang.Object.wait(Object.java:502)

                        at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:295)

                        - locked <0x20dd3ca8> (a java.lang.Object)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "Java2D Disposer" #9 daemon prio=10 os_prio=2 tid=0x05d21800 nid=0x2e30 in Object.wait() [0x0635f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd3e48> (a java.lang.ref.ReferenceQueue$Lock)

                        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)

                        - locked <0x20dd3e48> (a java.lang.ref.ReferenceQueue$Lock)

                        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)

                        at sun.java2d.Disposer.run(Disposer.java:148)

                        at java.lang.Thread.run(Thread.java:748)

                 

                "Service Thread" #7 daemon prio=9 os_prio=0 tid=0x05504c00 nid=0x9ac4 runnable [0x00000000]

                  java.lang.Thread.State: RUNNABLE

                 

                "C1 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x054d0c00 nid=0x57e0 waiting on condition [0x00000000]

                  java.lang.Thread.State: RUNNABLE

                 

                "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x054cfc00 nid=0x382c runnable [0x00000000]

                  java.lang.Thread.State: RUNNABLE

                 

                "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x054cd000 nid=0x5080 waiting on condition [0x00000000]

                  java.lang.Thread.State: RUNNABLE

                 

                "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x02327400 nid=0x79ac in Object.wait() [0x0574f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd4610> (a java.lang.ref.ReferenceQueue$Lock)

                        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)

                        - locked <0x20dd4610> (a java.lang.ref.ReferenceQueue$Lock)

                        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)

                        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:216)

                 

                "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x02320400 nid=0x8ecc in Object.wait() [0x0536f000]

                  java.lang.Thread.State: WAITING (on object monitor)

                        at java.lang.Object.wait(Native Method)

                        - waiting on <0x20dd47b0> (a java.lang.ref.Reference$Lock)

                        at java.lang.Object.wait(Object.java:502)

                        at java.lang.ref.Reference.tryHandlePending(Reference.java:191)

                        - locked <0x20dd47b0> (a java.lang.ref.Reference$Lock)

                        at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153)

                 

                "main" #1 prio=5 os_prio=0 tid=0x0226c000 nid=0x93f4 waiting on condition [0x00000000]

                  java.lang.Thread.State: RUNNABLE

                 

                "VM Thread" os_prio=2 tid=0x0231b800 nid=0x9750 runnable

                 

                "VM Periodic Task Thread" os_prio=2 tid=0x054de000 nid=0x9374 waiting on condition

                 

                JNI global references: 695

                 

                Heap

                def new generation  total 39424K, used 7701K [0x10200000, 0x12cc0000, 0x20ca0000)

                  eden space 35072K,  17% used [0x10200000, 0x107ec658, 0x12440000)

                  from space 4352K,  37% used [0x12880000, 0x12a19158, 0x12cc0000)

                  to  space 4352K,  0% used [0x12440000, 0x12440000, 0x12880000)

                tenured generation  total 87424K, used 22391K [0x20ca0000, 0x26200000, 0x42200000)

                  the space 87424K,  25% used [0x20ca0000, 0x2227df38, 0x2227e000, 0x26200000)

                Metaspace      used 15681K, capacity 16349K, committed 16384K, reserved 16768K

                • 5. Re: sql developer hangs on startup
                  Glen Conway

                  When starting SQL Developer, the creation/migration of user settings under AppData\Roaming\SQL Developer\system19.1.0.094.2042 is incomplete -- there should be nearly 200 files, plus an even greater number of folders.  So the SQL Developer startup runs into issues before the user settings initialization completes.  Perhaps the download zip got corrupted, but it looks to me like your installation procedure might have a problem.

                   

                  Normally that means just unzipping into an empty directory so, if sqldeveloper19 is the unzip target, the path to the sqldeveloper.exe in the bin directory would be

                  c:\oracle\sqldeveloper19\sqldeveloper\sqldeveloper\bin>.\sqldeveloper.exe

                  but I see you have

                  c:\oracle\sqldeveloper19\sqldeveloper\bin>.\sqldeveloper.exe

                  It matters how the install directory structure looks relative to that bin directory. So if you installed into oracle, then renamed the top level sqldeveloper folder to sqldeveloper19, that should work fine.  Otherwise, it may depend how you unzipped.  It should look something like this:

                  Capture.JPG

                  • 6. Re: sql developer hangs on startup
                    st*2977432*sa

                    Yes, unzipping as suggested by Glen fixed the issue! But I don't get it. I thought I'd been doing this since v1...

                     

                    This failed process in v19 seems to have worked in the past, if I'm remembering correctly:

                    1. download zip to c:\temp
                    2. extract to c:\temp\xxx
                    3. move the xxx\sqldeveloper directory to c:\oracle
                    4. rename the c:\oracle\sqldeveloper directory to c:\oracle\sqldeveloper19

                     

                    This seems like an unzip, not an install so why does the path matter...

                     

                    Today I did this, and it now works:

                    1. unzipped previously downloaded archive directly to a directory that didn't yet exist: c:\oracle\sqldeveloper19
                    2. The directory structure is as you guessed: C:\oracle\sqldeveloper19\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe

                     

                    That's a lot of "SQLDeveloper" in the path...

                    • 7. Re: sql developer hangs on startup
                      st*2977432*sa

                      From Oracle Support, closing Service Request 3-20609500321 

                       

                      Steve,

                       

                      One cannot use the built-in MS unzip tool. You need to use a 3rd party zip util.. there are many free ones.

                      Not sure if that was your problem, but I have heard of cases in the past related to that scenario.

                       

                      I will close this out for you.

                       

                      :} JB

                       

                       

                      To view the Service Request, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

                      Regards,

                      John Bartee

                      Oracle Support