Connecting through Oracle SQL Developer(version 184.108.40.206) using wallet files we are getting the following error “ORA-12154:TNS:could not resolve the connect identifier specified “when we test the connection via Advanced connection type in SQL Developer. We are using “jdbc:oracle:oci:/@NAME”. We are able to connect using SQLPLUS using “sqlplus /@NAME”. This is on a Mac(High Sierra) with the Instant Client Version 220.127.116.11.0.
We have the TNSNAMES.ora and SQLNET.ora files configured and the wallet is set and working fine with SQLPLUS.
Is there anything we should look at to troubleshoot this further? Or any workarounds you might suggest?
try a direct connection instead of tns
make sure we're reading the right tns
'show tns' - execute f5 in a worksheet