Connect Desktop 10.1 to Oracle with easy connect

10-08-2013 08:43 AM
New Contributor III
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

myserver: port/serviceid

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
0 Kudos
1 Reply
Regular Contributor II

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.
0 Kudos