Since the recent update, we are experiencing connection issues via SQLcl and our named connections registered via the extension.
Upon trying to attach a connection for SQLcl, via:
- connection view → right click connection → open SQLcl
- SQL file Run in SQLcl button or keyboard shortcut ctrl+shift+enter
- SQLcl terminal command connect -name connection_name
I have ensured the connection is recognized via command connmgr show connection_name.
The command connmgr test connection_name fails with the error:
Connection Test Failed - ORA-12170: Cannot connect. TCP connect timeout of 20000ms for host tns_name port port_number.
I am able to connect via SQLcl with the full connection string connect username/password@tns_name
We are having no issues connecting through the connect/disconnect options of the connections browser, or the attach connection to worksheet/workbook options.
Is this a known issue and is there any way to allow for the SQLcl connections with the new version?