Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

46fe8453-b524-45ba-94e4-16a962ca7406Sep 27 2018 — edited Sep 27 2018

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 25 2018
Added on Sep 27 2018
1 comment
1,819 views