1 Reply Latest reply on Sep 27, 2018 3:12 PM by thatJeffSmith-Oracle

    "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