My Oracle Support Banner

SQLcl Returns Exception Error Running TNSPING Database Name (Doc ID 2906916.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Oracle SQLcl - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

SQLcl Returns Exception Error Running TNSPING Database Name

Exception Error:

SQLCLi> tnsping <DBNAME>
Exception in thread "main" java.lang.NoSuchMethodError: oracle.net.ns.NSProtocol.connect(Ljava/lang/String;Ljava/util/Properties;Loracle/jdbc/driver/DMSFactory$DMSNoun;)V
at oracle.dbtools.raptor.newscriptrunner.commands.PingCmd.ping(PingCmd.java:111)
at oracle.dbtools.raptor.newscriptrunner.commands.PingCmd.handleEvent(PingCmd.java:58)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:437)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:237)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:356)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:239)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1145)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1327)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:339)

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
Cause
Solution


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