Skip to main content
Solved

Cannot connect to ArcSDE 10.6.1 with oracle19c

  • February 3, 2020
  • 2 replies
  • 232 views

koen
Contributor
Forum|alt.badge.img+11
  • Contributor
  • 41 replies

We're upgrading our servers and databases to ArcGIS 10.6, Oracle19c and FME 2019

 

I'm installing the new machine for FME, but 'm unable to connect to our database with the ArcSDE Geodb reader. 

I'm using a sde connection file(which works in ArcCatalog), but when I try to open the Table List I get the follwoing error:

Failed to retrieve feature types.
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[Unknown errorNo extended error.]}

Here's the additional logfile: 

 

My Setup:

Server: 

  • Microsoft Windows Server 2016 Standard
  • FME Desktop 2019.2.2 64-bit
  • ArcGIS Desktop 10.6.1
  • ArcGIS Desktop Background Geoprocessing 10.6.1 (64-bit)
  • Oracle Client 19c
  • Oracle instant client 19.5 64-bit

Database:

  • Oracle 19.c
  • ArcSde 10.6.1

 

Connecting to the database with an Oracle Reader does work.

 

Any idea what the problem could be?

Best answer by david_r

Have you installed the Oracle 19c patch?

https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-oracle.htm

Oracle 19c (64 bit) 19.3.0.0.0— Supported with ArcGIS Pro 2.4.2 and supported with ArcGIS 10.7.1 if you install the ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • 8392 replies
  • Best Answer
  • February 3, 2020

Have you installed the Oracle 19c patch?

https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-oracle.htm

Oracle 19c (64 bit) 19.3.0.0.0— Supported with ArcGIS Pro 2.4.2 and supported with ArcGIS 10.7.1 if you install the ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch

 

 


koen
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 41 replies
  • February 3, 2020

Have you installed the Oracle 19c patch?

https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-oracle.htm

Oracle 19c (64 bit) 19.3.0.0.0— Supported with ArcGIS Pro 2.4.2 and supported with ArcGIS 10.7.1 if you install the ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch

 

 

That solved it. Thanks a lot!