Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

trentJul 13 2013 — edited May 22 2014

$ 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[@]}"

This post has been answered by user2593758 on Sep 12 2013
Jump to Answer

Comments

horst.telser

I've the same problem.

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

sopvkore

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 ...).

horst.telser

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

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

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

This is for version 4, Early Adopter 1.

3.2.2 works fine ;-)

J.J-Oracle

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

890493

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
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 :)

Marked as Answer by trent · Sep 27 2020
trent

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

890493

Hi,

Your solution works for me also. SqlDeveloper 4.0EA1 and JDeveloper 12c are working perfectly now (on my Fedora 19).

Thank you for sharing this.

Regards,

Boris

This worked for me as well on Fedora 19.  I don't need to run as root to start jdeveloper.  I just need to run:

unset -v GNOME_DESKTOP_SESSION_ID

./jdev

and then it boots up as it should.

JDK 1.7 40

Fedora 19

Archy_Goodwin

This solution worked in Ubuntu 13.04 with JDK 1.7.0_45. My sqldeveloper.sh:

#!/bin/bash

unset -v GNOME_DESKTOP_SESSION_ID

cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*

Thank you!

1062138

I'm having the same issue.

cat /etc/lsb-release

DISTRIB_ID=Ubuntu

DISTRIB_RELEASE=13.04

DISTRIB_CODENAME=raring

DISTRIB_DESCRIPTION="Ubuntu 13.04"

java -version

java version "1.7.0_45"

Java(TM) SE Runtime Environment (build 1.7.0_45-b18)

Java HotSpot(TM) 64-Bit Server VM (build 24.45-b08, mixed mode)

SQL Developer Version 4.0.0.13

unset -v GNOME_DESKTOP_SESSION_ID

Also helps me

bruno.antunes

Problem is still present on final release of SQLDeveloper 4 using Oracle Java SE 7 update 45. Tested on openSUSE 13.1  using Gnome Desktop

Also reported on this thread, performing "unset -v GNOME_DESKTOP_SESSION_ID" before launching SQLDeveloper workarounds the problem.

JaredT

Problem still persistent.  Linux Mint 16 (Petra)

SQLDeveloper 4.0.1

Oracle Java SE 7 update 51

java version "1.7.0_51"

Java(TM) SE Runtime Environment (build 1.7.0_51-b13)

Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

The workaround "unset -v GNOME_DESKTOP_SESSION_ID" does not seem to be working.  sudo is the only working solution for me at this point.

trent

Since the prob was persisting, I've opted just to install OpenJDK and use that for SQL Developer. So Oracle JDK is whats linked to /usr/bin/java, then I updated ~/.sqldeveloper/product.conf and have the line:

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

It seems to work fine with OpenJDK as sopvkore suggested earlier.

JaredT

I also gave up on the Oracle JDK.

I did the same steps trent did with one addition.  I didn't like the terminal window being left visible, so I installed terminator and hid the terminal window:

sudo apt-get install terminator

sudo vi /usr/bin/sqldeveloper

change line:

XTERM_OPTS="-e"

to read

XTERM_OPTS="-He"

user6747841

Another way to do this fairly cleanly is to use a .desktop file.  Here's my .desktop file for launching SQL Developer:

[Desktop Entry]
Version=1.0
Name=Oracle SQL Developer
GenericName=SQL Client
Comment=Develop SQL code
MimeType=text/english;text/plain;text/sql;text/x-sql;
Exec=env -u GNOME_DESKTOP_SESSION_ID /opt/sqldeveloper/sqldeveloper.sh %F
TryExec=/opt/sqldeveloper/sqldeveloper.sh
Icon=/opt/sqldeveloper/icon.png
Type=Application
Terminal=false
Categories=Utility;Development;TextEditor;

You would just need to adjust the path for the application above.  The 'env' command unsets the environment variable GNOME_DESKTOP_SESSION_ID before launching.

1 - 19
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 19 2014
Added on Jul 13 2013
19 comments
15,232 views