topic Re: DBMS error[ORA-12154: TNS could not resolve the connect identifier specified No extende error] in ArcGIS Pro Questions

DBMS error[ORA-12154: TNS could not resolve the connect identifier specified No extende error]

SeanMonde — Sat, 13 Jul 2024 15:53:18 GMT

This error comes up while trying to open an EGIS SDE DB while working remotely, even though I do have network connections to the source server. Using ArcPro 3.3 on a WIN 11 machine.

Re: DBMS error[ORA-12154: TNS could not resolve the connect identifier specified No extende error]

George_Thompson — Sun, 14 Jul 2024 14:17:09 GMT

So this does not happen while in the office and only on VPN?

This usually has to do with TNSNAMES not being accessible or configured on the machine.

Have you confirmed that you can TNSPING the Oracle database from that machine?

Open SQLPlus and type the below. Replace (SID) with what you put in the "Instance" field.

tnsping (SID)

https://www.orafaq.com/wiki/Tnsping

Re: DBMS error[ORA-12154: TNS could not resolve the connect identifier specified No extende error]

SeanMonde — Fri, 02 Aug 2024 15:25:56 GMT

Sorry for the late response and thanks for responding! It seems to be happening remotely and in the office. What you say about the TNSNAMES makes sense. Since this is a company machine, our IT department will have to look into it, but thank you for the insight!