arcgis-10.2arcgis-desktopenterprise-geodatabaseoracle-dbms
I have Installed Arcgis Desktop 10.2 and Oracle 11G and Arcsde 10.2 and oracle Client
When I am Creating a Enterprise Geodatabase it is giving me this error:
ORA-12154: TNS:could not resolve the connect identifier specified
No extended error.
Failed to execute (CreateEnterpriseGeodatabase).
SQL-Server 2012 support was introduced at ArcGIS 10.1 SP1. You must also have the required SQL-Server 2012 client library install (and its dependent .Net Framework 4.x components) on the ArcGIS 10.1 SP1 client.
Discussion on the "need to install ArcSDE" is more of a philosophical issue (vice technical), but you can read more about it in the Esri Forums.
Check the tnsnames.ora file in the location c:\app\user\product\10.x.x\client\network\admin\tnsnames.ora
(if there is more than 1 products you may have to do it to both or 'de-install' oracle and then re-install the full client.)
There should be the database connections listed
DBANAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDRESS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBSERVICE)
)
)
Best Answer
Assuming your RDBMS install is 64-bit, and your Client install is 32-bit, then the issue could be an incorrect or incomplete tnsnames.ora file in whichever was installed last. I always make sure to propagate the same comprehensive tnsnames.ora to all my Oracle installs. You can diagnose SQL*Net connection failures with 'tnsping' and/or google the ORA error and review the dozens of potential causes for this error.