Forum Stats

  • 3,784,135 Users
  • 2,254,897 Discussions
  • 7,880,705 Comments

Discussions

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

46fe8453-b524-45ba-94e4-16a962ca7406
edited Sep 27, 2018 11:12AM in SQL Developer

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

Tagged:

Answers

This discussion has been closed.