Register Component: Oracle

223
1
02-17-2023 07:56 AM
DanielHerrera
New Contributor

Is there a preferred way to connect using the address and service name fields when registering an Oracle connection?  I have the 64-bit client working on the server, and even added the Oracle instant client - both are working fine when connecting to sqlplus.  When I try to register the Oracle component I'm getting this error:

 

ORA-12154: TNS:could not resolve the connect identifier specified

 

Thanks,

Daniel

0 Kudos
1 Reply
George_Thompson
Esri Frequent Contributor

What are you putting in your connection properties in ArcGIS?

Are you using TNS (<name>) or EZConnect (<server/SID>)?

If using TNS in the connection properties, do you have TNS configured in the client?

I would just go with the 64-bit full client and not the instant client.

--- George T.
0 Kudos