Provide older versions of ST_GEOMETRY .dll in My Esri downloads

1839
15
04-20-2023 10:07 AM
Status: Already Offered
Labels (1)
Bud
by
Notable Contributor

If I understand correctly, only the latest version of the ST_GEOMETRY .dll is available in My Esri downloads.

For example, the version of ST_GEOMETRY for Oracle isn't compatible with older versions of Oracle such as 18c:

The database version is not supported. Error: Oracle version 18.0.0.0.0 not supported.
See the setup log in the following location for additional error information:
Could not setup Esri spatial type.
Failed to execute (CreateSpatialType).

Could older versions of ST_GEOMETRY be made available in My Esri?

Thanks.

15 Comments
Bud
by

@VaibhavS 

Thanks. There doesn't seem to be a lot of info in sde_setup.log:

[09:32:50.998] SGA_Param - Open_Cursors: 300
[09:32:51.020] Default value of Open_Cursors: (300) can cause cursor starvation!
[09:32:51.020]
ST_Geometry is not installed.[09:32:51.020] Instance initialized for ((sde)) . . .

[09:32:51.076] Error: Oracle version 18.0.0.0.0 not supported.

[09:32:51.079] ERROR setting up St_Geometry, Error = -494
JustinMuise

@Bud - What version of ArcGIS Pro are you using?

The -494 error in the log file maps to "SE_UNSUPPORTED_DATABASE_VERSION" which makes me believe you are in a configuration that does not support Oracle 18: (https://help.arcgis.com/en/geodatabase/10.0/sdk/arcsde/api/capi/returncodes_incl.htm).

For example, Oracle 18 is not supported with ArcGIS Pro 3.0 or above: 
https://enterprise.arcgis.com/en/system-requirements/11.0/windows/database-requirements-oracle.htm


Bud
by

@JustinMuise I'm using ArcGIS Pro 3.1.1.

MarceloMarques

@Bud -  Oracle Deprecated 18c and new versions of ArcGIS Pro (Pro 3.1.1) are not certified and are not supported on18c, give a try with 19c. I hope this helps.

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

 

ShannonShields
Status changed to: Already Offered

ST_Geometry libraries are available for download on My Esri with each version of Pro that is available. At 11.1 they are also available for separate download for ArcGIS Enterprise. For Oracle, ST_Geometry libraries are built for specific ArcGIS releases. For PostgreSQL they are built for each supported PostgreSQL release supported with that ArcGIS release. If the version of Oracle or PostgreSQL is no supported with the ArcGIS release, an older ST_Geometry library is not going to  change this.

For more information on supported Oracle releases see: https://enterprise.arcgis.com/en/system-requirements/latest/linux/database-requirements-oracle.htm

For information on configuring the ST_Geometry libraries for use in an Oracle geodatabase see: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/configure-oracle-extpr...