SQL Developer 19.2 SSH connection fails with Org.apache.sshd.common.SshException: No More Authentication Method
(Doc ID 2575854.1)
Last updated on JANUARY 10, 2024
Applies to:
Oracle SQL Developer - Version 19.1 and laterInformation in this document applies to any platform.
Symptoms
Using SQL developer 19.2 with SSH to connect OCI instance. Connection failed with below error
Error Stack Details:
at org.apache.sshd.client.session.ClientUserAuthService.tryNext(ClientUserAuthService.java:322)
at org.apache.sshd.client.session.ClientUserAuthService.processUserAuth(ClientUserAuthService.java:258)
at org.apache.sshd.client.session.ClientUserAuthService.process(ClientUserAuthService.java:205)
at org.apache.sshd.common.session.helpers.AbstractSession.doHandleMessage(AbstractSession.java:400)
at org.apache.sshd.common.session.helpers.AbstractSession.handleMessage(AbstractSession.java:333)
at org.apache.sshd.common.session.helpers.AbstractSession.decode(AbstractSession.java:1097)
at org.apache.sshd.common.session.helpers.AbstractSession.messageReceived(AbstractSession.java:294)
at org.apache.sshd.common.session.helpers.AbstractSessionIoHandler.messageReceived(AbstractSessionIoHandler.java:63)
at org.apache.sshd.common.io.nio2.Nio2Session.handleReadCycleCompletion(Nio2Session.java:357)
at org.apache.sshd.common.io.nio2.Nio2Session$1.onCompleted(Nio2Session.java:335)
at org.apache.sshd.common.io.nio2.Nio2Session$1.onCompleted(Nio2Session.java:332)
at org.apache.sshd.common.io.nio2.Nio2CompletionHandler.lambda$completed$0(Nio2CompletionHandler.java:38)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.sshd.common.io.nio2.Nio2CompletionHandler.completed(Nio2CompletionHandler.java:37)
at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)
at sun.nio.ch.Invoker$2.run(Invoker.java:218)
at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
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)
Enabled Java Net Logging using 2254049.1 - How to Enable JavaNet Logging for SQLDeveloper and found below exceptions recorded.
Error Stack Details:
aug 08, 2019 1:45:22 PM oracle.ide.extension.HashStructureHook _fireListenerAttachedEvent
SEVERE: Unexpected runtime exception while delivering HashStructureHookEvent
java.lang.IllegalStateException: OracleConnectionType already exists: SSH
at oracle.dbtools.raptor.connections.OracleConnectionType.registerType(OracleConnectionType.java:150)
at oracle.dbtools.raptor.connections.OracleConnectionType.access$100(OracleConnectionType.java:31)
at oracle.dbtools.raptor.connections.OracleConnectionType$Builder.build(OracleConnectionType.java:125)
at oracle.dbtools.raptor.connections.OracleConnectionType$Listener.processDescriptors(OracleConnectionType.java:84)
at oracle.dbtools.raptor.connections.OracleConnectionType$Listener.listenerAttached(OracleConnectionType.java:49)
at oracle.ide.extension.HashStructureHook._fireListenerAttachedEvent(HashStructureHook.java:318)
at oracle.ide.extension.HashStructureHook.addHashStructureHookListener(HashStructureHook.java:242)
at oracle.dbtools.raptor.connections.OracleConnectionType.attachListener(OracleConnectionType.java:141)
at oracle.dbtools.raptor.connections.OracleConnectionType.getConnectionProcessors(OracleConnectionType.java:217)
at oracle.dbtools.raptor.standalone.connection.RaptorConnectionCreator.shouldEncrypt(RaptorConnectionCreator.java:387)
at oracle.jdevimpl.db.adapter.DatabaseProviderStorageFactory.createObject(DatabaseProviderStorageFactory.java:82)
at oracle.jdevimpl.db.adapter.DatabaseProviderStorageFactory.createObject(DatabaseProviderStorageFactory.java:17)
at oracle.dbtools.connections.Storage.createConnection(Storage.java:105)
at oracle.dbtools.connections.Storage.getConnection(Storage.java:97)
at oracle.jdeveloper.db.DatabaseConnections.getReferenceable(DatabaseConnections.java:695)
at oracle.jdeveloper.db.DatabaseConnections.getProperties(DatabaseConnections.java:720)
at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getConnectionProperties(Connections.java:254)
at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getConnectionType(Connections.java:378)
at oracle.dbtools.raptor.utils.Connections.isOracle(Connections.java:1727)
at oracle.dbtools.raptor.navigator.Databases$1.doWork(Databases.java:259)
at oracle.dbtools.raptor.navigator.Databases$1.doWork(Databases.java:251)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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)
Changes
Use SQL Developer 19.2 and connect using SSH Connection Type with existing public private keys.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |