"ORA-12154:TNS:could not resolve the connect identifier specified" on Mac in SQL Developer

46fe8453-b524-45ba-94e4-16a962ca7406

Connecting through Oracle SQL Developer(version 18.2.0.183) 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 12.2.0.1.0.

https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

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?

Thanks,

Tom

thatJeffSmith-Oracle

try a direct connection instead of tns

make sure we're reading the right tns

'show tns' - execute f5 in a worksheet