Forum Stats

  • 3,769,282 Users
  • 2,252,942 Discussions
  • 7,874,977 Comments

Discussions

4EA1: Not starting on Ubuntu. Unkown protocol sqldev.temp

trent
trent Member Posts: 848 Gold Badge
edited May 22, 2014 4:38PM in SQL Developer

$ lsb_release -a

No LSB modules are available.

Distributor ID: Ubuntu

Description: Ubuntu 13.04

Release: 13.04

Codename: raring

$ java -version

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)

RPM converted with alien (as I have done with all previous versions):

$ sudo alien -dc sqldeveloper-4.0.0.12.27-1.noarch.rpm

sqldeveloper_4.0.0.12.27-2_all.deb generated

$ sqldeveloper


Oracle SQL Developer
Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.


Jul 14, 2013 1:16:17 PM javax.ide.extension.spi.DefaultElementContext resolveResource
SEVERE: jar:/file:/opt/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.migration.application.jar!/META-INF/extension.xml:16: Resource not found: '${SCRATCH_COMMAND_ICON}'.




LOAD TIME : 321java.net.MalformedURLException: unknown protocol: sqldev.temp
  at java.net.URL.<init>(URL.java:413)
  at java.net.URL.<init>(URL.java:302)
  at oracle.ide.net.URLFactory.newURLInternal(URLFactory.java:754)
  at oracle.ide.net.URLFactory.newURL(URLFactory.java:745)
  at oracle.ide.marshal.xml.URL2Dom.toAbsoluteURL(URL2Dom.java:288)
  at oracle.ide.marshal.xml.URL2Dom.toURL(URL2Dom.java:232)
  at oracle.ide.marshal.xml.URL2Dom.toURL(URL2Dom.java:223)
  at oracle.ide.marshal.xml.URL2Dom.toObject(URL2Dom.java:176)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1042)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Object2Dom.initObject(Object2Dom.java:1461)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1052)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.List2Dom.toObject(List2Dom.java:89)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1035)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Object2Dom.initObject(Object2Dom.java:1461)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1052)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Map2Dom.toObject(Map2Dom.java:195)
  at oracle.ide.marshal.xml.Map2Dom.getValueObject(Map2Dom.java:209)
  at oracle.ide.marshal.xml.Map2Dom.toObject(Map2Dom.java:162)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1035)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:295)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:277)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:257)
  at oracle.ide.config.ClientSetting.open(ClientSetting.java:190)
  at oracle.ide.config.ClientSetting.ensureOpen(ClientSetting.java:371)
  at oracle.ide.config.ClientSetting.getData(ClientSetting.java:100)
  at oracle.ideimpl.editor.EditorManagerImpl.getEditorsOptions(EditorManagerImpl.java:1265)
  at oracle.ideimpl.editor.RecentFilesLRU.getLRUList(RecentFilesLRU.java:265)
  at oracle.ideimpl.editor.RecentFilesLRU.getRecentFile(RecentFilesLRU.java:331)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.getMostRecentEditorAddin(NbEditorManager.java:1845)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.bestEditorAddin(NbEditorManager.java:1828)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:318)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditorInFrame(NbEditorManager.java:305)
  at oracle.jdevimpl.help.StartPageController$1.run(StartPageController.java:92)
  at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:727)
  at java.awt.EventQueue.access$200(EventQueue.java:103)
  at java.awt.EventQueue$3.run(EventQueue.java:688)
  at java.awt.EventQueue$3.run(EventQueue.java:686)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:697)
  at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
  at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)
java.net.MalformedURLException: unknown protocol: sqldev.temp
  at java.net.URL.<init>(URL.java:413)
  at java.net.URL.<init>(URL.java:302)
  at oracle.ide.net.URLFactory.newURLInternal(URLFactory.java:754)
  at oracle.ide.net.URLFactory.newURL(URLFactory.java:745)
  at oracle.ide.marshal.xml.URL2Dom.toAbsoluteURL(URL2Dom.java:288)
  at oracle.ide.marshal.xml.URL2Dom.toURL(URL2Dom.java:232)
  at oracle.ide.marshal.xml.URL2Dom.toURL(URL2Dom.java:223)
  at oracle.ide.marshal.xml.URL2Dom.toObject(URL2Dom.java:176)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1042)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Object2Dom.initObject(Object2Dom.java:1461)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1052)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.List2Dom.toObject(List2Dom.java:89)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1035)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Object2Dom.initObject(Object2Dom.java:1461)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1052)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:505)
  at oracle.ide.marshal.xml.Map2Dom.toObject(Map2Dom.java:195)
  at oracle.ide.marshal.xml.Map2Dom.getValueObject(Map2Dom.java:209)
  at oracle.ide.marshal.xml.Map2Dom.toObject(Map2Dom.java:162)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:1035)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:295)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:277)
  at oracle.ide.marshal.xml.Object2Dom.toObject(Object2Dom.java:257)
  at oracle.ide.config.ClientSetting.open(ClientSetting.java:190)
  at oracle.ide.config.ClientSetting.ensureOpen(ClientSetting.java:371)
  at oracle.ide.config.ClientSetting.getData(ClientSetting.java:100)
  at oracle.ideimpl.editor.EditorManagerImpl.getEditorsOptions(EditorManagerImpl.java:1265)
  at oracle.ideimpl.editor.RecentFilesLRU.getLRUList(RecentFilesLRU.java:265)
  at oracle.ideimpl.editor.RecentFilesLRU.getRecentFile(RecentFilesLRU.java:331)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.getMostRecentEditorAddin(NbEditorManager.java:1845)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.bestEditorAddin(NbEditorManager.java:1828)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:318)
  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditorInFrame(NbEditorManager.java:305)
  at oracle.jdevimpl.help.StartPageController$1.run(StartPageController.java:92)
  at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:727)
  at java.awt.EventQueue.access$200(EventQueue.java:103)
  at java.awt.EventQueue$3.run(EventQueue.java:688)
  at java.awt.EventQueue$3.run(EventQueue.java:686)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:697)
  at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
  at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00007f5243119880, pid=13371, tid=139991416346368
#
# JRE version: 7.0_21-b11
# Java VM: Java HotSpot(TM) 64-Bit Server VM (23.21-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  0x00007f5243119880
[error occurred during error reporting (printing problematic frame), id 0xb]


# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /tmp/hs_err_pid13371.log
[thread 139991432742656 also had an error]
#
# If you would like to submit a bug report, please visit:
#   http://bugreport.sun.com/bugreport/crash.jsp
#
/opt/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 611: 13371 Aborted                 (core dumped) ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"


890493randooglejean.omobono

Best Answer

  • user2593758
    user2593758 Member Posts: 1
    Accepted Answer

    I was having the same issue as others, that only sudo would make SQLDeveloper to work. After running a strace on SQLDeveloper with and without sudo, I compared the output of both and identified that the one failing was due to being unable to find some awt libraries. So I started removing environment variables and found out that the culprit is GNOME_DESKTOP_SESSION_ID. Just unset that variable and SQLDeveloper will work fine, at least works fine for me :)

    890493randooglejean.omobono
«1

Answers

  • horst.telser
    horst.telser Member Posts: 2
    edited Jul 17, 2013 3:56AM

    I've the same problem.

    If I start it with "sudo sqldeveloper" it works fine. Maybe a permission problem? Who can help?

    horst.telser
  • sopvkore
    sopvkore Member Posts: 2

    Me too.

    Interesting - it seems to run Ok with java-6-oracle (although RN explicitly advises against) and also with java-7-openjdk! About java 7 - I'm on _25 level for both Oracle and openjdk version and Oracle's crashes. Go figure...

    But I didn't have time to test it more thoroughly, for sure it does not crashes JVM on startup and it feels just fine (db connect, queries, browse ...).

  • in sqldevelper.conf I changed the path to jdk to use my OpenJDK version:

    SetJavaHome /usr/lib/jvm/java-7-openjdk-i386/

    And now I can start sqldeveloper with my normal user. When I started it the first time I got the same error, but I was able to work with sqldeveloper. After this first start the error didn't occur anymore. I made several starts!

    Here my OpenJDK/JAVA version I'm using:

    $ /usr/lib/jvm/java-7-openjdk-i386/bin/java -version

    java version "1.7.0_25"

    OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.13.04.2)

    OpenJDK Server VM (build 23.7-b01, mixed mode)

  • 1027757
    1027757 Member Posts: 1

    Using openjdk:

    java version "1.7.0_25"

    OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.13.04.2)

    OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)

    I can't add connection to oracle database (if i try "test connection" the test process remains indefinitely pending).

    If i start jdeveloper 12c with sun jdk 1.6 or with sun jdk 1.7 (using sudo ./jdev to avoid crash) I can succesfully add connection.

    Perhaps the problem is between open JDK and oracle JDBC drive, but I find nothing to solve the problem.

  • ZaferMAktan
    ZaferMAktan Member Posts: 7
    edited Jul 26, 2013 3:13PM

    I have no problem executing SqlDeveloper 3.2.20 by utilizing the Oracle JDK 1.6 (not 1.7 - SqlDeveloper 3.2 is not certified against 1.7).

    I have the following in my .bashrc file for sqldeveloper:

    alias sqldeveloper='/home/zafer/sqldeveloper/sqldeveloper.sh -J-Xmx1024m'

    and the sqldeveloper.sh has the following content:

    #!/bin/bash
    export JAVA_HOME=/home/zafer/jdk1.6.0_38
    export PATH=/home/zafer/jdk1.6.0_38/bin:${PATH}
    cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*

    Hope this proves useful.

    r/ Zafer

    (under Ubuntu 12.04 LTS 64 bit)

  • trent
    trent Member Posts: 848 Gold Badge

    This is for version 4, Early Adopter 1.

    3.2.2 works fine ;-)

  • I have the similar issue on Ubuntu 13.04 with sqldeveloper 4.0.0.12.27-1.noarch, unable to start the sqldeveloper

    I tried the horst.telser solution, run with "sudo sqldeveloper" works fine, able to launch and execute sql queries.


    Thank You horst.telser.

  • 890493
    890493 Member Posts: 13

    I've experienced same issues on Linux Mint 15 (64bit) with Oracle JDK 1.7.0_25 (used alien to convert .rpm) as well as on Fedora 19.
    Jdeveloper 12c which I installed on Fedora 19 behaves the same as Sqldeveloper 4EA1 (could be started only with sudo).

    A friend of mine installed Sqldeveloper 4EA1 on Ubuntu 12.04 LTS with Oracle JDK 1.7.0_25 and he is able to start it without sudo...

  • user2593758
    user2593758 Member Posts: 1
    Accepted Answer

    I was having the same issue as others, that only sudo would make SQLDeveloper to work. After running a strace on SQLDeveloper with and without sudo, I compared the output of both and identified that the one failing was due to being unable to find some awt libraries. So I started removing environment variables and found out that the culprit is GNOME_DESKTOP_SESSION_ID. Just unset that variable and SQLDeveloper will work fine, at least works fine for me :)

    890493randooglejean.omobono
  • trent
    trent Member Posts: 848 Gold Badge

    Well, I just upgraded to EA2, and the issue persists.

    user2593758's solution seems to work - nice find.

    sudo vim /usr/local/bin/sqldeveloper
    
    unset -v GNOME_DESKTOP_SESSION_ID
    /opt/sqldeveloper/sqldeveloper.sh
    
This discussion has been closed.