My Oracle Support Banner

SQL Developer 19.2 SSH connection fails with Org.apache.sshd.common.SshException: No More Authentication Method (Doc ID 2575854.1)

Last updated on AUGUST 28, 2019

Applies to:

Oracle SQL Developer - Version 19.1 and later
Information 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:

org.apache.sshd.common.SshException: No more authentication methods available
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.