When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs:
Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified No extended error.]
I set up the ArcGIS Server, ArcGIS for Desktop, and Oracle are all installed on one machine. ArcGIS for Server 10.2.2 64bit ArcCatalog 10.2.2 32bit Oracle Instant Client 11.2.0 64bit Oracle Database 11g Enterprise Edition 11.2.0 32bit
I have successfully made the Oracle 11g "Enabled Enterprise Geodatabase" through the ArcCatalog, and it seems nothing wrong.
Database Platfrom: Oracle Instance: orcl Authentication Type: Database authentication User name: gesbar2 password: gesbar2
And I have added the Oracle Instant Client directory to the PATH and environment variable, I am sure that the 64-bit DLL is found before the 32-bit one.
tnsping
to find a connection string which is compatible with both client and the server's listener.