3 Replies Latest reply on Mar 19, 2015 10:33 PM by Gary Graham-Oracle

    SQL Developer 4.0.3 (32 bit) hangs during Launch on Windows 7

    VenkatY

      Hi - SQL Developer 4.0.3 (32 bit) hangs during Launch on my Windows 7.  Appreciate if one of you could help me with this issue.


      I had to switch to 32 bit version of SQL Developer from 64 bit as i was facing the below error with 64 bit version.

      Status: Failure -Test failed: C:\oracle\product\11.2.0\client\BIN\ocijdbc11.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform

       

      FYI, when i launched the sqldeveloper.exe from the bin folder, i see the below execution path in the command window. Please let me know if you need any information.  Thanks in advance !

       

      java.lang.NullPointerException

              at oracle.ideimpl.extension.ExtensionManagerImpl.findMinimalExtension(Ex

      tensionManagerImpl.java:2335)

              at oracle.ideimpl.extension.ExtensionManagerImpl.getSystemDirectory(Exte

      nsionManagerImpl.java:409)

              at oracle.ide.config.IdeSettings.getConfigURL(IdeSettings.java:732)

              at oracle.ide.config.IdeSettings.load(IdeSettings.java:582)

              at oracle.ide.IdeCore.loadIdeSettings(IdeCore.java:2197)

              at oracle.ide.IdeCore.getSettings(IdeCore.java:576)

              at oracle.ide.Ide.getSettings(Ide.java:359)

              at oracle.ide.IdeMainWindow.getInputMap(IdeMainWindow.java:679)

              at oracle.ide.IdeCore.getIdeInputMap(IdeCore.java:721)

              at oracle.ide.Ide.getIdeInputMap(Ide.java:561)

              at com.oracle.jdeveloper.nbwindowsystem.NbDockableContainer.initInputMap

      (NbDockableContainer.java:437)

              at com.oracle.jdeveloper.nbwindowsystem.NbDockableContainer.<init>(NbDoc

      kableContainer.java:90)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

       

       

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

      orAccessorImpl.java:57)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

      onstructorAccessorImpl.java:45)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

              at org.netbeans.modules.settings.convertors.XMLSettingsSupport.newInstan

      ce(XMLSettingsSupport.java:100)

              at org.netbeans.modules.settings.convertors.XMLPropertiesConvertor.defau

      ltInstanceCreate(XMLPropertiesConvertor.java:228)

              at org.netbeans.modules.settings.convertors.XMLPropertiesConvertor.read(

      XMLPropertiesConvertor.java:99)

              at org.netbeans.modules.settings.InstanceProvider$InstanceCookieImpl.ins

      tanceCreate(InstanceProvider.java:317)

              at org.netbeans.core.windows.persistence.PersistenceManager.getTopCompon

      entPersistentForID(PersistenceManager.java:571)

              at org.netbeans.core.windows.persistence.PersistenceManager.getTopCompon

      entForID(PersistenceManager.java:681)

              at org.netbeans.core.windows.PersistenceHandler.getTopComponentForID(Per

      sistenceHandler.java:489)

              at org.netbeans.core.windows.PersistenceHandler.load(PersistenceHandler.

      java:156)

              at org.netbeans.core.windows.WindowSystemImpl.load(WindowSystemImpl.java

      :81)

              at org.netbeans.core.GuiRunLevel$InitWinSys.run(GuiRunLevel.java:231)

              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)

              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:738)

              at java.awt.EventQueue.access$300(EventQueue.java:103)

              at java.awt.EventQueue$3.run(EventQueue.java:699)

              at java.awt.EventQueue$3.run(EventQueue.java:697)

              at java.security.AccessController.doPrivileged(Native Method)

              at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo

      main.java:76)

              at java.awt.EventQueue.dispatchEvent(EventQueue.java:708)

              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

      ad.java:242)

              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

      java:161)

              at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

      ad.java:150)

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

       

       

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

       

       

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

      UIDefaults.getUI() failed: no ComponentUI class for: oracle.ide.controls.StatusB

      arControl$JDevStatusBar[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,f

      lags=0,maximumSize=,minimumSize=,preferredSize=]

      java.lang.Error

              at javax.swing.UIDefaults.getUIError(UIDefaults.java:732)

              at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:130)

              at javax.swing.UIDefaults.getUI(UIDefaults.java:762)

              at javax.swing.UIManager.getUI(UIManager.java:1013)

              at oracle.bali.ewt.statusBar.StatusBar.updateUI(StatusBar.java:480)

              at oracle.bali.ewt.statusBar.StatusBar.<init>(StatusBar.java:104)

              at oracle.ide.controls.StatusBarControl$JDevStatusBar.<init>(StatusBarCo

      ntrol.java:264)

              at oracle.ide.controls.StatusBarControl.<init>(StatusBarControl.java:48)

       

       

              at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow$13.<init>(NbMainWin

      dow.java:1098)

              at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow.createStatusBar(NbM

      ainWindow.java:1098)

              at oracle.ide.IdeMainWindow.getStatusBar(IdeMainWindow.java:624)

              at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow.getStatusBarStatic(

      NbMainWindow.java:228)

              at com.oracle.jdeveloper.nbwindowsystem.NbStatusBar.getStatusLineElement

      (NbStatusBar.java:23)

              at org.netbeans.core.windows.view.ui.MainWindow$4.run(MainWindow.java:36

      5)

              at org.netbeans.core.windows.view.ui.MainWindow.getStatusLineElements(Ma

      inWindow.java:377)

              at org.netbeans.core.windows.view.ui.MainWindow.decoratePanel(MainWindow

      .java:331)

              at org.netbeans.core.windows.view.ui.MainWindow.initializeComponents(Mai

      nWindow.java:248)

              at org.netbeans.core.windows.view.DefaultView.showWindowSystem(DefaultVi

      ew.java:563)

              at org.netbeans.core.windows.view.DefaultView.windowSystemVisibilityChan

      ged(DefaultView.java:542)

              at org.netbeans.core.windows.view.DefaultView.changeGUI(DefaultView.java

      :187)

              at org.netbeans.core.windows.ViewRequestor.dispatchRequest(ViewRequestor

      .java:275)

              at org.netbeans.core.windows.ViewRequestor.processVisibilityRequest(View

      Requestor.java:264)

              at org.netbeans.core.windows.ViewRequestor.postVisibilityRequest(ViewReq

      uestor.java:201)

              at org.netbeans.core.windows.ViewRequestor.scheduleRequest(ViewRequestor

      .java:121)

              at org.netbeans.core.windows.Central.setVisible(Central.java:140)

              at org.netbeans.core.windows.WindowManagerImpl.setVisible(WindowManagerI

      mpl.java:926)

              at org.netbeans.core.windows.WindowSystemImpl.show(WindowSystemImpl.java

      :105)

              at org.netbeans.core.GuiRunLevel$InitWinSys.run(GuiRunLevel.java:246)

              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)

              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:738)

              at java.awt.EventQueue.access$300(EventQueue.java:103)

              at java.awt.EventQueue$3.run(EventQueue.java:699)

              at java.awt.EventQueue$3.run(EventQueue.java:697)

              at java.security.AccessController.doPrivileged(Native Method)

              at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo

      main.java:76)

              at java.awt.EventQueue.dispatchEvent(EventQueue.java:708)

              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

      ad.java:242)

              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

      java:161)

              at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

      ad.java:150)

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

       

       

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

       

       

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

        • 1. Re: SQL Developer 4.0.3 (32 bit) hangs during Launch on Windows 7
          Gary Graham-Oracle

          You are much better off using 64-bit code.  As an alternative to running 4.0.3 under a 32-bit JDK, try the following alternative installations, after installing the latest available 64-bit JDK from here Java SE Development Kit 7 - Downloads | Oracle Technology Network | Oracle

           

          1. If you do not need to use the OCI/Thick driver for JDBC connections, then disable

          Tools > Preferences > Database > Advanced > Use OCI/Thick driver

           

          2. If you do need to use the OCI/Thick driver, then download and install an 11.2.0.3 or higher Oracle Instant client (64-bit) from

          Instant Client downloads for Microsoft Windows (x64)

          and configure SQL Developer to use it in Tools > Preferences > Database > Advanced > Use Oracle Client

           

          When configuring the instant client, remember to click the Test... button and review the log for an errors / required config steps.

           

          P.S.: if you really want to stay with 32-bit, then first make sure the null pointer exception in findMinimalExtension is not a one-time event.  I have seen an occasional failure similar to that when starting up after switching between SQL Developer versions / JDK versions.

          • 2. Re: SQL Developer 4.0.3 (32 bit) hangs during Launch on Windows 7
            VenkatY

            Hi Gary -

             

            Thanks for the quick response. The Use OCI/Thick driver option is already unchecked when i tried with 64-bit version of SQL Developer with 64-bit JDK. Unfortunately i have to use Oracle Client 32 bit version for my CRM development work.  Is it possible to use 64-bit SQL developer with 32-bit Oracle Client ? If so, could you provide the instructions to make it work ?


            Also, i dont know how to make sure the null pointer exception in findMinimalExtension is not a one-time event. Will you be able to provide instructions or help making any changes ?

             

            Thanks !

            • 3. Re: SQL Developer 4.0.3 (32 bit) hangs during Launch on Windows 7
              Gary Graham-Oracle

              A few points to consider...

              The Use OCI/Thick driver option is already unchecked when i tried with 64-bit version of SQL Developer with 64-bit JDK

              You can only get the ocijdbc11.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform message if OCI/Thick driver option is checked or when using a connection type of Advanced.

              i have to use Oracle Client 32 bit version for my CRM development work

              It is possible to install and use multiple Oracle Homes and/or instant clients.

               

              Is it possible to use 64-bit SQL developer with 32-bit Oracle Client

               

              Only if not using the OCI/Thick driver, whether its usage be explicit or implicit.

               

              i dont know how to make sure the null pointer exception in findMinimalExtension is not a one-time event

               

              Try starting up SQL Developer again if it fails the first time.  Also this could be one of those cases when the user settings migration does not work properly or the settings get corrupted.  You could try removing or renaming the system4.0.3.16.84 directory and trying again.