Environment
Client: Windows 10 64bit
Client java version: Version 8 Update 151
Server: Linux 7
Database 12.1
I've upgrade to 17.3 on a Windows 10 PC from a much earlier version and can no longer access the PL/SQL specification or body code for any package (or procedure, function, trigger). I can access table definitions, table data, run sql in worksheets, no problem. On selecting a package, SQL Developer display a spinning icon for sometime and eventually just returns the line "Create or replace" and no more.
17.3 was installed on the Windows laptop with the JDK supplied with the download and configured on installation to use this jdk, not the version of java installed on the laptop.
I can run SQLDeveloper 4 on the linux server with no problem.
The activity log file on the Windows PC shows an error but I'm not clear on what to fix. My guess is that 17.3 and 4 connect to the database slightly differently and some parameter in the database needs to be increased to prevent the connection error for 17.3. The log file is reproduced below:-
SEVERE 128 0 oracle.javatools.buffer.JdkReadWriteLockImplementation$DeadlockScanner Starvation (possible deadlock) detected:
Oracle SQL Developer 17.3.1 279.0537 (279.0537)
Oracle Corporation Java 1.8.0_144-b01
373MB free of 746MB
-------------------------------------------------------------------------------
-- Thread Dump
-------------------------------------------------------------------------------
"SwingWorker-pool-5-thread-1" id=111 RUNNABLE (in native)
at sun.nio.ch.SocketDispatcher.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43)
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 java.lang.Object@64d47e10
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:144)
at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:82)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:139)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:101)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:80)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
- locked oracle.jdbc.driver.T4CConnection@5cb96ca5
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)
at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:657)
at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:647)
at oracle.dbtools.db.DBUtil.assertLock(DBUtil.java:1747)
at oracle.dbtools.db.DBUtil.executeOracleQuery(DBUtil.java:673)
at oracle.dbtools.db.OracleUtil.executeQuery(OracleUtil.java:101)
at oracle.dbtools.raptor.navigator.net.DBURLStreamHandlerFactory.fetchSource(DBURLStreamHandlerFactory.java:269)
at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.createReader(DBURLFileSystemHelper.java:168)
at oracle.ideimpl.net.LazyURLFileSystemHelper.createReader(LazyURLFileSystemHelper.java:365)
at oracle.ide.net.URLFileSystem.createReader(URLFileSystem.java:1707)
at oracle.ide.model.TextNode.createReader(TextNode.java:1126)
at oracle.ide.model.TextNode.loadTextBuffer(TextNode.java:297)
at oracle.ide.model.TextNode.openImpl(TextNode.java:532)
at oracle.ide.db.model.BaseDBObjectTextNode.openImpl(BaseDBObjectTextNode.java:144)
at oracle.dbtools.raptor.navigator.plsql.PlSqlNode.openImpl(PlSqlNode.java:156)
at oracle.ide.model.Node.open(Node.java:1252)
at oracle.ide.model.Node.open(Node.java:1199)
at oracle.ide.model.Node.ensureOpen(Node.java:2650)
at oracle.ide.model.TextNode.acquireTextBuffer(TextNode.java:762)
at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$4$1.doInBackground(NavSelectionListener.java:501)
at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$4$1.doInBackground(NavSelectionListener.java:496)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Locked synchronizers:
- java.util.concurrent.ThreadPoolExecutor$Worker@752d845c
- java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa
- java.util.concurrent.locks.ReentrantLock$NonfairSync@6e2c1560
"AWT-EventQueue-0" id=16 WAITING on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa owned by "SwingWorker-pool-5-thread-1" id=111
at sun.misc.Unsafe.park(Native Method)
- waiting on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:836)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireShared(AbstractQueuedSynchronizer.java:967)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireShared(AbstractQueuedSynchronizer.java:1283)
at java.util.concurrent.locks.ReentrantReadWriteLock$ReadLock.lock(ReentrantReadWriteLock.java:727)
at oracle.javatools.buffer.JdkReadWriteLockImplementation.lock(JdkReadWriteLockImplementation.java:202)
at oracle.javatools.buffer.JdkReadWriteLockImplementation.readLock(JdkReadWriteLockImplementation.java:94)
at oracle.javatools.buffer.ReadWriteLock.readLock(ReadWriteLock.java:188)
at oracle.ide.model.Node.readLock(Node.java:262)
at oracle.ide.model.Node.runUnderReadLock(Node.java:1883)
at oracle.ide.model.TextBufferTracker.getTracker(TextBufferTracker.java:114)
at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:88)
at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:60)
at oracle.ideimpl.markers.MarkableNode.<init>(MarkableNode.java:75)
at oracle.ideimpl.markers.MarkableText.<init>(MarkableText.java:80)
at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:72)
at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:44)
at oracle.ide.adapters.AbstractCachingAdapterFactory.adapt(AbstractCachingAdapterFactory.java:146)
at oracle.ideimpl.adapters.AdapterManagerImpl.adapt(AdapterManagerImpl.java:116)
at oracle.ide.markers.Markable$Adapter.adapt(Markable.java:84)
at oracle.ideimpl.status.markers.StatusMarkerProvider.addStatusIssues(StatusMarkerProvider.java:186)
at oracle.ideimpl.status.markers.StatusMarkerProvider.viewSelectionChanged(StatusMarkerProvider.java:142)
at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)
at oracle.ide.view.ViewDecorator.fireViewSelectionChangedImpl(ViewDecorator.java:69)
at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)
at oracle.ide.view.View.updateSelectionImpl0(View.java:442)
at oracle.ide.view.View.updateSelectionImpl(View.java:427)
at oracle.ide.view.View.updateSelection(View.java:306)
at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1$1.run(NavigatorWindow.java:90)
at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1.viewSelectionChanged(NavigatorWindow.java:96)
at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)
at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)
at oracle.ide.view.View$2.actionPerformed(View.java:349)
at javax.swing.Timer.fireActionPerformed(Timer.java:313)
at javax.swing.Timer$DoPostEvent.run(Timer.java:245)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
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:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
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:201)
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)
Any help would be gratefully received
Thanks
Paul