0

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2

Our new server is setup and ready for testing. It is at SDE 10.3.1 on Oracle 12c. However when ArcGIS Desktop existing clients try to connect to it they are getting an error:

Failed to connect to database. Underlying DBMS error [unknown Error No extended error]

.

I had thought that newer versions of SDE were backwards compatible with older ArcGIS desktop clients. Is there a connection setting that has to change? The connection settings we are using work fine with ArcGIS desktop 10.3.1 :

Connection we are trying to use

| improve this question | |
  • 1
    You have the directionality wrong -- Newer CLIENTS can usually connect to older SERVERS, not old clients to new servers. ArcGIS 10.1 was released long, long before Oracle 12c was released, and does not support 12c. You should always upgrade client nodes first, then the servers. – Vince Aug 24 '15 at 22:59
  • @Vince I think that link you sent me is for SDE support for Oracle, not client support. I know I've seen it documented that ArcGIS Desktop versions support new SDE databases. Let me see if I can dig it up. – Dowlers Aug 24 '15 at 23:15
  • Oh and we are planning on upgrading the clients to 10.3.1 at the same time. thankfully, I'm just hoping to have the editors test one or two things first. I'd upgrade them first but we ran into a strange bug with ArcObjects spatial queries giving wrong results. – Dowlers Aug 24 '15 at 23:20
  • @Vince OK I think I figured it out. From this: desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-oracle/… it looks like 10.1 client only support SDE 10.3.1 on Oracle 10 or 11. Thanks for your help as always – Dowlers Aug 24 '15 at 23:36
2

According to this compatibility document ArcGIS 10.1 can connect to Oracle SDE 10.3.1 only if it is oracle 10 or 11.

The underlying DBMS must be Oracle 10g or 11g. See the ArcGIS 10.1 system requirements for supported versions.

| improve this answer | |
  • The "ArcGIS 10.1 system requirements for supported versions" is the link I provided. – Vince Aug 25 '15 at 1:04
  • I think I got confused by the system requirements document. I read it as database requirements for SDE 10.1, not for ArcGIS desktop client support. I always thought ArcGIS desktop desktop client support was controlled by the RDBMS client. – Dowlers Aug 25 '15 at 16:45
  • Direct Connect is a server capability, run on the client. Server requirements dictate Direct Connect compatibility. Forward compatibility is only working here because there have been no significant changes to the server. – Vince Aug 25 '15 at 16:56
-2

Here are few web-links which might be helpful:

http://www.arcgis.com/home/item.html?id=6997e32c54bd40ca8cahttp://ianbroad.com/arcgis-toolbox-create-unique-id-arcpy/13e1fdaf5948b

http://support.esri.com/technical-article/000011137

| improve this answer | |
  • 1
    Please refrain from only using links in your answer--those go stale quickly. Give a description on what to do to solve the problem. – MaryBeth Jun 23 '16 at 20:34
  • Yes. First link is dead, 2nd link is irrelevant – TazAstroSpacial Oct 18 '17 at 23:36

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.