This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Feb 13, 2013 5:39 AM by 946869 RSS

DMSConsole error when connecting with Sql Developer 3

946869 Newbie
Currently Being Moderated
It's been over a month, and we can't get SQL Developer 3 to do anything useful.


Our older Sql Developer 1.5.5 is connecting ok.


We have no CLASSPATHs defined, and all of the other Sql/Oracle tools are running fine, including Pl/Sql Developer. And we have no problem coding Java apps in Intellij, and executing them.


The DMS Jar

ojdbc6dms.jar


is located in

c:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper_3\sqldeveloper\lib\


It's a class not found error, whenever we try any defined connection (imported from sql developer 1.1.5):

Error connecting

oracle/dms/console/DMSConsole

Stack Trace:

java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole
...
  • 1. Re: DMSConsole error when connecting with Sql Developer 3
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    Can you try starting from the beginning?

    Download v3.2.20_09

    Start it.

    Try a new connection.

    What happens?

    Sorry you've been struggling with this for so long. I'm sure we can get you up and running quickly.
  • 2. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    That's the build that we have. You mean, install it in a different folder than the one we have now? Ok, will try, thanks.
  • 3. Re: DMSConsole error when connecting with Sql Developer 3
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    I'm sorry, you said v3, I took that to mean v3.0.


    Are you running 32 or 64 bit windows? What version of the JDK do you have installed?

    And yes, try extracting to a new directory. In general, don't extract new SQLDev on top of existing 'installs.' Not that that's what you did, but something to avoid.
  • 4. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    Same thing, regarding the connections.

    However, 2 differences: 1) This time, it didn't ask to import a prior versions configuration, and 2) This time, I downloaded and copied the SQL Developer version, which includes its own jre.


    But, same result.
  • 5. Re: DMSConsole error when connecting with Sql Developer 3
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    Can you answer my questions? It will make diagnosing your issue much easier.
  • 6. Re: DMSConsole error when connecting with Sql Developer 3
    Gary Graham Expert
    Currently Being Moderated
    Sounds like you may have too many JDBC drivers to choose from. Below is summary of how to collect some debugging info. Note optional step (3) especially. If you use that approach, then SQL Developer will pick the JDBC driver that ships with it (in the ...\sqldeveloper\jdbc directory).
    //Example for Windows
    1. Open a command line console. Adjust the properties so the console buffer size is at least 500 lines.
    2. CD to your installation bin directory ( ...\sqldeveloper\sqldeveloper\bin).
    3. set ORACLE_HOME=%CD%   (This is optional - if you want to ensure use of the jdbc driver that ships with SQL Developer)
    4. Launch sqldeveloper.exe (not sqldeveloperW.exe) so any debug messages appear in the console
    5. Run your test case and when it hangs, do a Ctrl-Break from the console to get a full thread dump  (This is optional)
    Hope this helps,
    Gary
  • 7. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    Not sure how to make sense of all this. Also, the Oracle_home is already set to a folder; should this be modified in the local session, whenever sqldeveloper runs?

    TCC 14.03.59 Windows 7 [Version 6.1.7601]
    Copyright 2013 JP Software Inc. All Rights Reserved
    Registered to xxxxxx - 1 System License

    alias /r alias.lst
    rem set /r envir.lst
    [C:\Program Files (x86)\JPSoft\TCMD14]cd c:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin\

    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]set oracle_home
    c:\app\ChildeDE\product\11.2.0

    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]sqldeveloper
    Registered TimesTen
    2013-02-08 07:46:36
    Full thread dump Java HotSpot(TM) Client VM (20.10-b01 mixed mode):

    "Keep-Alive-Timer" daemon prio=8 tid=0x3eada800 nid=0x1454 waiting on condition [0x436cf000]
    java.lang.Thread.State: TIMED_WAITING (sleeping)
    at java.lang.Thread.sleep(Native Method)
    at sun.net.www.http.KeepAliveCache.run(KeepAliveCache.java:149)
    at java.lang.Thread.run(Thread.java:662)

    "IconOverlayTracker Timer" prio=6 tid=0x3eadb000 nid=0xb60 in Object.wait() [0x437cf000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x13c660d0> (a java.util.TaskQueue)
    at java.lang.Object.wait(Object.java:485)
    at java.util.TimerThread.mainLoop(Timer.java:483)
    - locked <0x13c660d0> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "WaitCursor-Timer" prio=6 tid=0x3ead9800 nid=0xc2c in Object.wait() [0x42a6f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x139dfa98> (a java.util.TaskQueue)
    at java.lang.Object.wait(Object.java:485)
    at java.util.TimerThread.mainLoop(Timer.java:483)
    - locked <0x139dfa98> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "Timer queue for AWT thread" daemon prio=6 tid=0x3ead9000 nid=0x13cc in Object.wait() [0x4296f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x13285dc8> (a java.lang.Object)
    at java.lang.Object.wait(Object.java:485)
    at ice.util.awt.TimedAWTExecutor.nextElem(TimedAWTExecutor.java:108)
    - locked <0x13285dc8> (a java.lang.Object)
    at ice.util.awt.TimedAWTExecutor.runScheduler(TimedAWTExecutor.java:130)
    at ice.util.awt.TimedAWTExecutor$1.run(TimedAWTExecutor.java:19)

    "BaseTreeExplorer.NodeOpeningExecutor" prio=6 tid=0x3ead8c00 nid=0xffc waiting on condition [0x4220f000]
    java.lang.Thread.State: WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x132988e8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
    at java.util.concurrent.locks.LockSupport.park(LockSupport.java:156)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1987)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:399)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:662)

    "pool-2-thread-1" prio=6 tid=0x3ead8400 nid=0x11e4 waiting on condition [0x420cf000]
    java.lang.Thread.State: WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x13298a20> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.park(LockSupport.java:156)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:422)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:323)
    at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:857)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:662)

    "Scheduler" daemon prio=6 tid=0x3ead7c00 nid=0x4b4 in Object.wait() [0x41f8f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x13298b40> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
    at java.lang.Object.wait(Object.java:485)
    at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
    - locked <0x13298b40> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
    at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:444)

    "Thread-9" daemon prio=6 tid=0x3ead7800 nid=0x74 in Object.wait() [0x4134f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x1305bc78> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
    - locked <0x1305bc78> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
    at org.tmatesoft.svn.core.javahl.SVNClientImplTracker.run(SVNClientImplTracker.java:65)
    at java.lang.Thread.run(Thread.java:662)

    "TimerQueue" daemon prio=6 tid=0x3ead7000 nid=0x131c in Object.wait() [0x41a4f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x12ff6f80> (a javax.swing.TimerQueue)
    at javax.swing.TimerQueue.run(TimerQueue.java:232)
    - locked <0x12ff6f80> (a javax.swing.TimerQueue)
    at java.lang.Thread.run(Thread.java:662)

    "IconOverlayTracker Daemon" prio=6 tid=0x3ead6c00 nid=0x17e0 waiting on condition [0x415cf000]
    java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x12f90b18> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:196)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2025)
    at java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:424)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:945)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:662)

    "Thread-7" daemon prio=6 tid=0x3ead6400 nid=0x1158 runnable [0x4148f000]
    java.lang.Thread.State: RUNNABLE
    at sun.print.Win32PrintServiceLookup.notifyPrinterChange(Native Method)
    at sun.print.Win32PrintServiceLookup.access$100(Win32PrintServiceLookup.java:32)
    at sun.print.Win32PrintServiceLookup$PrinterChangeListener.run(Win32PrintServiceLookup.java:302)

    "ChangeSetService" prio=2 tid=0x3fc06400 nid=0x1034 in Object.wait() [0x4124f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x128656f0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
    at java.lang.Object.wait(Object.java:485)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:178)
    - locked <0x128656f0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:199)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$200(ChangeSetService.java:56)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService$2.run(ChangeSetService.java:138)
    at java.lang.Thread.run(Thread.java:662)

    "Image Fetcher 2" daemon prio=8 tid=0x400d1c00 nid=0xe08 in Object.wait() [0x40eff000]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80708> (a java.util.Vector)
    at sun.awt.image.ImageFetcher.nextImage(ImageFetcher.java:114)
    - locked <0x11f80708> (a java.util.Vector)
    at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:167)
    at sun.awt.image.ImageFetcher.run(ImageFetcher.java:136)

    "TimedCache-Timer" daemon prio=6 tid=0x3d82fc00 nid=0x224 in Object.wait() [0x3ee8f000]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f804c8> (a java.util.TaskQueue)
    at java.util.TimerThread.mainLoop(Timer.java:509)
    - locked <0x11f804c8> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "JarIndex Timer" daemon prio=6 tid=0x3d809000 nid=0xe80 in Object.wait() [0x3ec4f000]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80580> (a java.util.TaskQueue)
    at java.util.TimerThread.mainLoop(Timer.java:509)
    - locked <0x11f80580> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "AWT-EventQueue-0" prio=6 tid=0x3d7fb000 nid=0x1208 in Object.wait() [0x3e68e000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80638> (a java.awt.EventQueue)
    at java.lang.Object.wait(Object.java:485)
    at java.awt.EventQueue.getNextEvent(EventQueue.java:509)
    - locked <0x11f80638> (a java.awt.EventQueue)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:236)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
    at java.awt.Dialog$1.run(Dialog.java:1044)
    at java.awt.Dialog$3.run(Dialog.java:1096)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Dialog.show(Dialog.java:1094)
    at java.awt.Component.show(Component.java:1591)
    at java.awt.Component.setVisible(Component.java:1543)
    at java.awt.Window.setVisible(Window.java:843)
    at java.awt.Dialog.setVisible(Dialog.java:984)
    at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
    at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
    at oracle.javatools.dialogs.ExceptionDialog.reallyShowExceptionDialog(ExceptionDialog.java:294)
    at oracle.javatools.dialogs.ExceptionDialog.showExceptionDialog(ExceptionDialog.java:229)
    at oracle.dbtools.raptor.navigator.TypeContainerFilter$ExceptionDialogRunnable.run(TypeContainerFilter.java:241)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:666)
    at java.awt.EventQueue.access$400(EventQueue.java:81)
    at java.awt.EventQueue$2.run(EventQueue.java:627)
    at java.awt.EventQueue$2.run(EventQueue.java:625)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:636)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

    "Image Fetcher 3" daemon prio=8 tid=0x3d7fa000 nid=0x7c0 in Object.wait() [0x3e54f000]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80708> (a java.util.Vector)
    at sun.awt.image.ImageFetcher.nextImage(ImageFetcher.java:114)
    - locked <0x11f80708> (a java.util.Vector)
    at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:167)
    at sun.awt.image.ImageFetcher.run(ImageFetcher.java:136)

    "AWT-Windows" daemon prio=6 tid=0x3d7d8400 nid=0x7a8 runnable [0x3e40f000]
    java.lang.Thread.State: RUNNABLE
    at sun.awt.windows.WToolkit.eventLoop(Native Method)
    at sun.awt.windows.WToolkit.run(WToolkit.java:293)
    at java.lang.Thread.run(Thread.java:662)

    "AWT-Shutdown" prio=6 tid=0x3d7d7c00 nid=0x1380 in Object.wait() [0x3e2cf000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80818> (a java.lang.Object)
    at java.lang.Object.wait(Object.java:485)
    at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:265)
    - locked <0x11f80818> (a java.lang.Object)
    at java.lang.Thread.run(Thread.java:662)

    "Java2D Disposer" daemon prio=10 tid=0x3d7d1800 nid=0x1218 in Object.wait() [0x3e18f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f808b0> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
    - locked <0x11f808b0> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
    at sun.java2d.Disposer.run(Disposer.java:127)
    at java.lang.Thread.run(Thread.java:662)

    "Low Memory Detector" daemon prio=6 tid=0x02514000 nid=0xc94 runnable [0x00000000]
    java.lang.Thread.State: RUNNABLE

    "C1 CompilerThread0" daemon prio=10 tid=0x02512400 nid=0x106c waiting on condition [0x00000000]
    java.lang.Thread.State: RUNNABLE

    "Attach Listener" daemon prio=10 tid=0x02511000 nid=0x11e0 runnable [0x00000000]
    java.lang.Thread.State: RUNNABLE

    "Signal Dispatcher" daemon prio=10 tid=0x0250e000 nid=0x13bc waiting on condition [0x00000000]
    java.lang.Thread.State: RUNNABLE

    "Finalizer" daemon prio=8 tid=0x024dd000 nid=0x13b8 in Object.wait() [0x3d06f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80b08> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
    - locked <0x11f80b08> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
    at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

    "Reference Handler" daemon prio=10 tid=0x024db800 nid=0x17a0 in Object.wait() [0x3cf6f000]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x11f80b98> (a java.lang.ref.Reference$Lock)
    at java.lang.Object.wait(Object.java:485)
    at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
    - locked <0x11f80b98> (a java.lang.ref.Reference$Lock)

    "main" prio=6 tid=0x0254bc00 nid=0x17e4 waiting on condition [0x00000000]
    java.lang.Thread.State: RUNNABLE

    "VM Thread" prio=10 tid=0x024d7000 nid=0x1570 runnable

    "VM Periodic Task Thread" prio=10 tid=0x0252b400 nid=0x9e4 waiting on condition

    JNI global references: 3529

    Heap
    def new generation total 39424K, used 15384K [0x04a30000, 0x074f0000, 0x11f80000)
    eden space 35072K, 43% used [0x04a30000, 0x059360e0, 0x06c70000)
    from space 4352K, 0% used [0x06c70000, 0x06c70000, 0x070b0000)
    to space 4352K, 0% used [0x070b0000, 0x070b0000, 0x074f0000)
    tenured generation total 87424K, used 33812K [0x11f80000, 0x174e0000, 0x2ca30000)
    the space 87424K, 38% used [0x11f80000, 0x14085328, 0x14085400, 0x174e0000)
    compacting perm gen total 63232K, used 63214K [0x2ca30000, 0x307f0000, 0x3ca30000)
    the space 63232K, 99% used [0x2ca30000, 0x307ebab8, 0x307ebc00, 0x307f0000)
    No shared spaces configured.
  • 8. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    Just tried setting ORACLE_HOME to point to the sqldeveloper bin folder. Same result.
  • 9. Re: DMSConsole error when connecting with Sql Developer 3
    Gary Graham Expert
    Currently Being Moderated
    From your post that included the full thread dump, it looks like your set <env_variable> syntax is a bit off...
    set oracle_home c:\app\ChildeDE\product\11.2.0
    Try using set ORACLE_HOME= and definitely point at the bin directory.

    Edited by: Gary Graham on Feb 8, 2013 9:13 AM
    And if that does not work, you might try looking at which extensions you have enabled. I noticed the Keep-Alive in the full thread dump.
  • 10. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    No, no. I typed SET ORACLE_HOME by itself, in order to return the current setting. Whenever you type SET (environment variable) <ENTER>, the operating system returns the current setting.

    Anyway, I tried pointing it at the sqldeveloper bin folder, with

    SET ORACLE_HOME=%CD%

    , but still no luck.


    [C:\Program Files (x86)\JPSoft\TCMD14]cd c:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin\

    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]SET ORACLE_HOME=%CD%

    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]sqldeveloper.exe

    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]SET ORACLE_HOME

    (This is where it returns the current setting of ORACLE_HOME)
    C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin


    [C:\app\ChildeDE\product\11.2.0\client_2\sqldeveloper03\sqldeveloper\sqldeveloper\bin]
  • 11. Re: DMSConsole error when connecting with Sql Developer 3
    Gary Graham Expert
    Currently Being Moderated
    OK, sorry about that. Anyway, taking a step back, note that ...

    1. DMSConsole.class is not contained in ojdbc6dms.jar. It is found in dms.jar (DB installation's oc4j\lib directory)
    2. SQL Developer began shipping ojdbc6dms.jar with the 3.x releases. We never shipped dms.jar.
    3. SQL Developer code base never directly references DMSConsole (I only checked 3.2.20.09.87)
    4. JDeveloper IDE framework that our code is based on may reference it, but the only instance I could (easily) find was
    oracle.dms.instrument.DMSConsole
    not
    oracle.dms.console.DMSConsole
    Here is a website you might find useful if you wish to check on which jar file(s) a given class may be found in:
    http://www.findjar.com/class/oracle/dms/console/DMSConsole.html

    At this point, the only recommendation I can make would be to avoid placing new SQL Developer installs under your old ORACLE_HOME directory.

    -Gary-
  • 12. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    Huh. I installed it in c:\Programs\sqldeveloper\sqldeveloper, then tried both

    1) Setting the CLASSPATH to C:\Oracle\Middleware_11_1_2_3_0\oracle_common\modules\oracle.dms_11.1.1\dms.jar


    , and

    2) Taking out the CLASSPATH altogether,


    and continue to get the same result.

    This is a mystery. dms.jar clearly has the class; I confirmed it's in there.


    Ok, will do a little more detective work.


    One question: Is there a way to directly set the CLASSPATHs, PATHs, or Jars that SqlDeveloper uses? I searched in the SqlDeveloper help file for Command Line parameters, like the ones used in the sqldeveloper.bat file, but can't seem to locate the docs.
  • 13. Re: DMSConsole error when connecting with Sql Developer 3
    946869 Newbie
    Currently Being Moderated
    Got it. Here are the steps:

    1. Execute the SqlDeveloper.bat, instead of SqlDeveloper.exe


    2. Your imported connections will be gone. Recreate those manually.

    3. Exit SqlDeveloper

    4. Copy dms.jar to the SqlDeveloper bin folder, same folder as SqlDeveloper.exe and SqlDeveloper.bat (this is temporary, will copy it to a lib folder later).


    5. Edit the SqlDeveloper.bat.


    6. Change the classpath option in the SqlDeveloper.bat file, from

    -classpath ../../ide/lib/ide-boot.jar

    to

    -classpath ./dms.jar;c:\oracle\middleware\oracle_common\modules\oracle.odl_11.1.1\*;../../ide/lib/ide-boot.jar

    7. Whenever running SqlDeveloper, execute SqlDeveloper.bat, rather than SqlDeveloper.exe.



    Gary, thanks for the assistance. Jeff, sorry I just realized that I missed your question, but thanks for trying to help. Resolved.


    Regards,

    Edited by: 943866 on Feb 11, 2013 7:00 AM
  • 14. Re: DMSConsole error when connecting with Sql Developer 3
    Gary Graham Expert
    Currently Being Moderated
    Glad you found a workaround, but do not be surprised if other negative issues present themselves. There is something about your environment that is not right -- you should not have to jump through hoops like this to get SQL Developer to work.

    -Gary-
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points