Connect Desktop 10.1 to Oracle with easy connect

249
1
10-08-2013 08:43 AM
GhassanKarwchan
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

dbserer:1539/devDatabase

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
NidhinKarthikeyan
Occasional Contributor III
Ghassan,

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