Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer hangs

user8341305Feb 15 2019 — edited Feb 17 2019

I see a very similar behavior of SQL Developer as the user user12021398 posted at 14.6.2018 21:15 (that thread is archived). He used Windows with OCI, I use Linux with JDBC but the problem is the same (I use the latest version 18.4.0.376.1900) - one problematic db connection blocks whole UI for a very long time (I have no idea how to configure this timeout, but it is many minutes by default), which is extremely annoying when you have more db connections open and just one hangs. Why I cannot use other db connections in this situation and possibly get some notification when that one problematic db connection starts responding? It seems to me that it would be great if you could somehow get rid of calling oracle.javatools.db.AbstractDatabase.isConnectionAlive from the UI thread (AWT-EventQueue-0).

2019-02-15 13:50:56

Full thread dump OpenJDK 64-Bit Server VM (25.191-b12 mixed mode):

"Attach Listener" #198 daemon prio=9 os_prio=0 tid=0x00007fa168001000 nid=0x2435 waiting on condition [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"AliveLockThread.COCRMV" #197 prio=6 os_prio=0 tid=0x00007fa14cd7b800 nid=0x23ed runnable [0x00007fa10b9f9000]

   java.lang.Thread.State: RUNNABLE

    at sun.nio.ch.FileDispatcherImpl.read0(Native Method)

    at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)

    at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)

    at sun.nio.ch.IOUtil.read(IOUtil.java:197)

    at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)

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

    at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:178)

    at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:544)

    at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:234)

    at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:174)

    at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:122)

    at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:100)

    at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:86)

    at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:762)

    at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:427)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:394)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)

    at oracle.jdbc.driver.T4CTTIoping.doOPING(T4CTTIoping.java:54)

    at oracle.jdbc.driver.T4CConnection.doPingDatabase(T4CConnection.java:4970)

    - locked <0x00000000d30d0410> (a oracle.jdbc.driver.T4CConnection)

    at oracle.jdbc.driver.PhysicalConnection.pingDatabase(PhysicalConnection.java:5434)

    at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy.pingDatabase(Unknown Source)

    at oracle.javatools.db.ora.OracleDatabaseImpl.isConnectionAliveImpl(OracleDatabaseImpl.java:496)

    at oracle.javatools.db.AbstractDatabase$AliveTester.run(AbstractDatabase.java:494)

    - locked <0x00000000d30cc4e8> (a oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy)

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

   Locked ownable synchronizers:

    - None

"Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.TimedSoftReference]" #193 daemon prio=1 os_prio=0 tid=0x00007fa14d00d800 nid=0x23dc in Object.wait() [0x00007fa11c995000]

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

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

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

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

   Locked ownable synchronizers:

    - None

"RaptorTaskThread15" #181 prio=5 os_prio=0 tid=0x00007fa110042000 nid=0x13e6 waiting on condition [0x00007fa13ede8000]

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

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

    - parking to wait for  <0x00000000cf7f61d0> (a java.util.concurrent.SynchronousQueue$TransferStack)

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

    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

    at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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

   Locked ownable synchronizers:

    - None

"Image Animator 2" #122 daemon prio=3 os_prio=0 tid=0x00007fa14ce54000 nid=0x2ef sleeping[0x00007fa10b5f8000]

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

    at java.lang.Thread.sleep(Native Method)

    at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670)

    at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:247)

    at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269)

    at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205)

    at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169)

   Locked ownable synchronizers:

    - None

"SwingWorker-pool-5-thread-1" #117 daemon prio=5 os_prio=0 tid=0x00007fa14cb23800 nid=0x2e9 waiting on condition [0x00007fa184f71000]

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

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

    - parking to wait for  <0x00000000d3339dd0> (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.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)

    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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

   Locked ownable synchronizers:

    - None

"status-0" #111 prio=2 os_prio=0 tid=0x00007fa14d025000 nid=0x2d4 waiting on condition [0x00007fa10aef5000]

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

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

    - parking to wait for  <0x00000000d333a348> (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.util.concurrent.DelayQueue.take(DelayQueue.java:211)

    at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)

    at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)

    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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

   Locked ownable synchronizers:

    - None

"WeakDataReference polling" #108 prio=1 os_prio=0 tid=0x00007fa14cf72000 nid=0x2d0 in Object.wait() [0x00007fa10bcfd000]

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

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

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

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

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

    at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)

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

   Locked ownable synchronizers:

    - None

"Background Parser#1" #103 prio=6 os_prio=0 tid=0x00007fa14cd97000 nid=0x2c2 sleeping[0x00007fa13c541000]

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

    at java.lang.Thread.sleep(Native Method)

    at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)

    at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)

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

   Locked ownable synchronizers:

    - None

"TextBufferScavenger" #101 prio=6 os_prio=0 tid=0x00007fa14cd90800 nid=0x2bf in Object.wait() [0x00007fa13c123000]

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

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

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

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

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

    at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)

   Locked ownable synchronizers:

    - None

"oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #96 daemon prio=4 os_prio=0 tid=0x00007fa12802a800 nid=0x291 in Object.wait() [0x00007fa10b8f9000]

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

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

    at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:329)

    - locked <0x00000000d30a6580> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)

   Locked ownable synchronizers:

    - None

"Timer-5" #95 daemon prio=5 os_prio=0 tid=0x00007fa128023800 nid=0x290 in Object.wait() [0x00007fa184ab9000]

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

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

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

    at java.util.TimerThread.mainLoop(Timer.java:526)

    - locked <0x00000000d30d84c8> (a java.util.TaskQueue)

    at java.util.TimerThread.run(Timer.java:505)

   Locked ownable synchronizers:

    - None

"pool-4-thread-1" #86 prio=5 os_prio=0 tid=0x00007fa14c54b800 nid=0x279 runnable [0x00007fa10bbfc000]

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

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

    - parking to wait for  <0x00000000d28be9b8> (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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)

    at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)

    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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

   Locked ownable synchronizers:

    - None

"IconOverlayTracker Timer: null-jdbcNodeInfoType" #85 prio=5 os_prio=0 tid=0x0000000001a9e000 nid=0x271 in Object.wait() [0x00007fa184dba000]

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

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

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

    at java.util.TimerThread.mainLoop(Timer.java:526)

    - locked <0x00000000d287d298> (a java.util.TaskQueue)

    at java.util.TimerThread.run(Timer.java:505)

   Locked ownable synchronizers:

    - None

"Background Parser#0" #53 prio=5 os_prio=0 tid=0x00007fa13437e000 nid=0x3538 sleeping[0x00007fa11d7a4000]

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

    at java.lang.Thread.sleep(Native Method)

    at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)

    at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)

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

   Locked ownable synchronizers:

    - None

"WaitCursor-Timer" #50 prio=6 os_prio=0 tid=0x00007fa14c4bd000 nid=0x3518 in Object.wait() [0x00007fa10b3f6000]

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

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

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

    at java.util.TimerThread.mainLoop(Timer.java:526)

    - locked <0x00000000d146d388> (a java.util.TaskQueue)

    at java.util.TimerThread.run(Timer.java:505)

   Locked ownable synchronizers:

    - None

"InterruptTimer" #41 daemon prio=5 os_prio=0 tid=0x00007fa120005800 nid=0x34ac in Object.wait() [0x00007fa10bffe000]

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

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

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

    at java.util.TimerThread.mainLoop(Timer.java:526)

    - locked <0x00000000d156a4c0> (a java.util.TaskQueue)

    at java.util.TimerThread.run(Timer.java:505)

   Locked ownable synchronizers:

    - None

"DestroyJavaVM" #38 prio=5 os_prio=0 tid=0x00007fa1a400e800 nid=0x341a waiting on condition [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"Thread-7" #37 daemon prio=5 os_prio=0 tid=0x00007fa139009800 nid=0x3486 in Object.wait() [0x00007fa11d1c4000]

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

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

    - waiting on <0x00000000ce4832e8> (a java.util.LinkedList)

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

    at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482)

    - locked <0x00000000ce4832e8> (a java.util.LinkedList)

   Locked ownable synchronizers:

    - None

"ChangeSetService" #35 daemon prio=1 os_prio=0 tid=0x00007fa1383c2000 nid=0x3480 in Object.wait() [0x00007fa11d8a5000]

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

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

    - waiting on <0x00000000d0efe9d0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)

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

    at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:131)

    - locked <0x00000000d0efe9d0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)

    at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:152)

    at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$000(ChangeSetService.java:60)

    at oracle.jdevimpl.vcs.changeset.ChangeSetService$1.run(ChangeSetService.java:99)

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

   Locked ownable synchronizers:

    - None

"Scheduler" #34 daemon prio=5 os_prio=0 tid=0x00007fa138b2c000 nid=0x345f in Object.wait() [0x00007fa11e5a6000]

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

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

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

    at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)

    - locked <0x00000000cf74d768> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

    at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:548)

   Locked ownable synchronizers:

    - None

"Log Poller" #33 prio=1 os_prio=0 tid=0x00007fa138994800 nid=0x344c waiting on condition [0x00007fa11eca7000]

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

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

    - parking to wait for  <0x00000000cf992340> (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.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)

    at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60)

    at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:333)

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

   Locked ownable synchronizers:

    - None

"TimedCache-Timer" #27 daemon prio=5 os_prio=0 tid=0x00007fa13836c000 nid=0x343f in Object.wait() [0x00007fa13c33f000]

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

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

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

    at java.util.TimerThread.mainLoop(Timer.java:526)

    - locked <0x00000000cee71988> (a java.util.TaskQueue)

    at java.util.TimerThread.run(Timer.java:505)

   Locked ownable synchronizers:

    - None

"Framework Event Dispatcher" #23 daemon prio=6 os_prio=0 tid=0x00007fa14c078000 nid=0x343a in Object.wait() [0x00007fa1843b6000]

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

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

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

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

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

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

   Locked ownable synchronizers:

    - None

"State Data Manager" #22 daemon prio=5 os_prio=0 tid=0x00007fa138206800 nid=0x3439 waiting on condition [0x00007fa1846b7000]

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

    at java.lang.Thread.sleep(Native Method)

    at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.java:297)

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

   Locked ownable synchronizers:

    - None

"Framework Active Thread" #21 prio=5 os_prio=0 tid=0x00007fa1381e9800 nid=0x3438 in Object.wait() [0x00007fa1847b8000]

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

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

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

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

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

   Locked ownable synchronizers:

    - None

"Active Reference Queue Daemon" #17 daemon prio=1 os_prio=0 tid=0x00007fa1a448e800 nid=0x342f in Object.wait() [0x00007fa1853a9000]

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

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

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

    - locked <0x00000000ce550560> (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)

   Locked ownable synchronizers:

    - None

"TimerQueue" #15 daemon prio=5 os_prio=0 tid=0x00007fa1a4323800 nid=0x342d runnable [0x00007fa185dd6000]

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

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

    - parking to wait for  <0x00000000ce898ef0> (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)

   Locked ownable synchronizers:

    - <0x00000000ce898f18> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

"AWT-EventQueue-0" #13 prio=6 os_prio=0 tid=0x00007fa1a431e800 nid=0x342c in Object.wait() [0x00007fa185ed5000]

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

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

    at oracle.javatools.db.AbstractDatabase.isConnectionAlive(AbstractDatabase.java:547)

    - locked <0x00000000faf11868> (a oracle.javatools.db.AbstractDatabase$AliveTester)

    at oracle.javatools.db.AbstractDatabase.isConnectionAlive(AbstractDatabase.java:376)

    at oracle.javatools.db.AbstractDatabase.getConnection(AbstractDatabase.java:243)

    at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1185)

    at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1169)

    at oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.<init>(DBCommandRunnerTask.java:451)

    at oracle.dbtools.worksheet.commands.scriptrunner.task.StatementRunnerTask.<init>(StatementRunnerTask.java:35)

    at oracle.dbtools.worksheet.commands.scriptrunner.StatementRunnerProvider.getTask(StatementRunnerProvider.java:38)

    at oracle.dbtools.worksheet.commands.scriptrunner.DBCommandRunnerProvider.doAction(DBCommandRunnerProvider.java:53)

    at oracle.dbtools.worksheet.editor.Worksheet$WorksheetController.handleEvent(Worksheet.java:583)

    at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)

    at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1159)

    at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)

    at oracle.ide.ceditor.keymap.IdeKeymapHelper.invokeAction(IdeKeymapHelper.java:160)

    at oracle.javatools.editor.keys.MultiKeyHandler.keyPressed(MultiKeyHandler.java:336)

    at java.awt.AWTEventMulticaster.keyPressed(AWTEventMulticaster.java:250)

    at java.awt.AWTEventMulticaster.keyPressed(AWTEventMulticaster.java:249)

    at java.awt.Component.processKeyEvent(Component.java:6497)

    at javax.swing.JComponent.processKeyEvent(JComponent.java:2832)

    at java.awt.Component.processEvent(Component.java:6316)

    at java.awt.Container.processEvent(Container.java:2239)

    at java.awt.Component.dispatchEventImpl(Component.java:4889)

    at java.awt.Container.dispatchEventImpl(Container.java:2297)

    at java.awt.Component.dispatchEvent(Component.java:4711)

    at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954)

    at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835)

    at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103)

    at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974)

    at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800)

    at java.awt.Component.dispatchEventImpl(Component.java:4760)

    at java.awt.Container.dispatchEventImpl(Container.java:2297)

    at java.awt.Window.dispatchEventImpl(Window.java:2746)

    at java.awt.Component.dispatchEvent(Component.java:4711)

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

    at java.awt.EventQueue.access$500(EventQueue.java:97)

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

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

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

    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)

    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)

    at java.awt.EventQueue$4.run(EventQueue.java:733)

    at java.awt.EventQueue$4.run(EventQueue.java:731)

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

    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)

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

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

    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)

   Locked ownable synchronizers:

    - <0x00000000d3708698> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

"AWT-Shutdown" #14 prio=5 os_prio=0 tid=0x00007fa1a431d000 nid=0x342b in Object.wait() [0x00007fa185fd8000]

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

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

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

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

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

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

   Locked ownable synchronizers:

    - None

"AWT-XAWT" #12 daemon prio=6 os_prio=0 tid=0x00007fa1a4319000 nid=0x342a runnable [0x00007fa1860d9000]

   java.lang.Thread.State: RUNNABLE

    at sun.awt.X11.XToolkit.waitForEvents(Native Method)

    at sun.awt.X11.XToolkit.run(XToolkit.java:568)

    at sun.awt.X11.XToolkit.run(XToolkit.java:532)

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

   Locked ownable synchronizers:

    - None

"Java2D Disposer" #10 daemon prio=10 os_prio=0 tid=0x00007fa1a42f8800 nid=0x3429 in Object.wait() [0x00007fa18c135000]

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

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

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

    - locked <0x00000000ce5cd828> (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)

   Locked ownable synchronizers:

    - None

"Service Thread" #8 daemon prio=9 os_prio=0 tid=0x00007fa1a40cd800 nid=0x3426 runnable [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"C1 CompilerThread2" #7 daemon prio=9 os_prio=0 tid=0x00007fa1a40c2000 nid=0x3425 waiting on condition [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"C2 CompilerThread1" #6 daemon prio=9 os_prio=0 tid=0x00007fa1a40c0800 nid=0x3424 waiting on condition [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"C2 CompilerThread0" #5 daemon prio=9 os_prio=0 tid=0x00007fa1a40bd800 nid=0x3423 waiting on condition [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"Signal Dispatcher" #4 daemon prio=9 os_prio=0 tid=0x00007fa1a40bc000 nid=0x3422 runnable [0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

    - None

"Finalizer" #3 daemon prio=8 os_prio=0 tid=0x00007fa1a4088800 nid=0x3421 in Object.wait() [0x00007fa18cf6b000]

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

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

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

    - locked <0x00000000ce89eea0> (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)

   Locked ownable synchronizers:

    - None

"Reference Handler" #2 daemon prio=10 os_prio=0 tid=0x00007fa1a4085800 nid=0x3420 in Object.wait() [0x00007fa18d06c000]

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

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

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

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

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

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

   Locked ownable synchronizers:

    - None

"VM Thread" os_prio=0 tid=0x00007fa1a407c000 nid=0x341f runnable

"GC task thread#0 (ParallelGC)" os_prio=0 tid=0x00007fa1a4023800 nid=0x341b runnable

"GC task thread#1 (ParallelGC)" os_prio=0 tid=0x00007fa1a4025800 nid=0x341c runnable

"GC task thread#2 (ParallelGC)" os_prio=0 tid=0x00007fa1a4027000 nid=0x341d runnable

"GC task thread#3 (ParallelGC)" os_prio=0 tid=0x00007fa1a4029000 nid=0x341e runnable

"VM Periodic Task Thread" os_prio=0 tid=0x00007fa1a40d3800 nid=0x3427 waiting on condition

JNI global references: 1495

Comments

top.gun

See the following:

Oracle Database Software Downloads | Oracle Technology Network | Oracle

Previous Database Release Software

Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set. Similarly, for 11.1 request 11.1.0.6 which must be applied before installing 11.1.0.7. Patch sets can be downloaded from the Patches and Updates tab on My Oracle Support.

user10686033

When I go to

edelivery.oracle.com

and do a search with 10.2.0.5

I only get

Enterprise Manager Grid Control 10.2.0.5.0

Dude!

Oracle 10g database is no longer available from any legal or public Oracle sources. You have to contact Oracle sales or support.

Zoltan Kecskemethy

See e.g. this old thread

Also 10.2.0.x is not supported on Linux 6 - so likely getting hold of the media will be the easy part ;-)

Rasheed_

Directly you cannot start 10g installation on rhel 6 , before install

Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 6 ) with the following:

redhat-4

After installation you can reset it back .(Its just for skipping installer version check skip)

Srini Chavali-Oracle 
Rasheed_ wrote:




Directly you cannot start 10g installation on rhel 6 , before install




Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 6 ) with the following:


redhat-4




After installation you can reset it back .(Its just for skipping installer version check skip)

Can you point to a doc where this is the supported method ?

Rasheed_

Workaround #2: On Oracle Linux 5 and Red Hat Enterprise Linux 5, the installation will pass the operating system prerequisite checks if you change each Oracle Linux 5 and Red Hat Enterprise Linux 5 to Oracle Linux 4 and Red Hat Enterprise Linux 4 in the /etc/redhat-release file. Ensure that you replace the original values in the /etc/redhat-release file after the Oracle installation is complete.



From below oracle doc link


https://docs.oracle.com/cd/B19306_01/relnotes.102/b15659/toc.htm

Dude!

That applies to EL 5, but not EL 6. EL 6 is way too far ahead regarding software per-requisites. I'm not saying it cannot be done, but it is not supported and has a few other challenges. Perhaps in the case of the OP, the best way is to run 10g under EL 6 inside VirtualBox using OL 5.

1 - 9

Post Details

Added on Feb 15 2019
#sql-developer
4 comments
3,060 views