Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsping returns -2ms for everything under SQLcl 4.2.0

AdricFeb 13 2017 — edited Oct 3 2017

I'm using SQLcl 4.2.0 on Linux, and it's reporting "ping:-2ms" anytime the tnsping command is used. It doesn't even seem to matter if the connection name I provide is even valid... no error message is ever seen. Here's a quick example:

$ sqlcl test/XXXXXXXXXXXX@mydb

SQLcl: Release 4.2.0 Production on Mon Feb 13 11:29:10 2017

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

[TEST@mydb ] SQL> disconnect

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

[@ ] SQL> tnsping mydb

ping:-2ms

[@ ] SQL> tnsping invalid_entry

ping:-2ms

Is this a known issue? And if so, are there any workarounds?

Comments
Post Details
Added on Feb 13 2017
11 comments
1,803 views