I am trying to create a database connection from ArcGIS desktop 10.1 to SDE Geodatabase on Oracle server with direct connection using Oracle 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

  • Do you have ArcSDE? – Mapperz Oct 8 '13 at 16:31
  • Yes, I am connecting to ArcSDE I will re-write my question – Ghassan Karwchan Oct 8 '13 at 16:34
  • Assuming your are on Windows (64bit?) resources.arcgis.com/en/help/main/10.1/index.html#//… – Mapperz Oct 8 '13 at 16:40
  • Did you match the case of the service identifier as created? – Vince Oct 9 '13 at 12:22
  • I ended up uninstall oracle client and install it again. and it is working now. I am not sure what was the cause of the problem, but I am highly suspecting it is a bug in ArcGIS desktop 10.1 connection. – Ghassan Karwchan Oct 9 '13 at 16:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.