I am trying to create a database connection from ArcGIS desktop 10.1 to Oracle server using easy connect syntax So, from ArcCatalog I use "Add database connection" then I chose Oracle in database platform
then in the instance I write down
so I write
but it gives me ora-12154 TNS:could not resolve the connect identifier
I thought by using the easy connect I don't have to worry about TNS names
Install 32 bit Oracle client, configure it, and connect to the database.
Be sure the sqlnet.ora file on the client is configured to allow the use of Easy Connect and the Oracle server is configured to allow Easy Connect syntax. Also note that if your Oracle instance is not listening on the default Oracle port number, you must use connection syntax that includes the port number.