My Oracle Support Banner

SQLCL Tnsping Command Always Reports A Time Of "-2ms" (Doc ID 2313678.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle SQL Developer - Version 4.2.0 and later
Information in this document applies to any platform.


java version "1.8.0_121
Oracle SQLDeveloper Command-Line (SQLcl) version:
Windows 10 64-bit

SQLcl tnsping command always reports a time of "-2ms". This occurs regardless of whether or not the supplied tns alias is valid, with no error message being reported in either case.

Works in SQLCL as expected.

Steps to reproduce the issue
SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version:

Available TNS Entries

SQL> tnsping mydb

SQL> tnsping bogus

SQL> connect <user>@mydb
Password? (**********?) ***********




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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