Provide older versions of ST_GEOMETRY .dll in My Esri downloads
Regarding:
We usually get the ST_GEOMETRY.dll file from the ArcGIS Desktop installation directory's database support folder.
I was able to download ArcMap 10.7.1 (since I know from a different ArcGIS environment that ArcMap 10.7.1 and Oracle 18c coincided) and I retrieved the ST_GEOMETRY .dll from the installation directory's database support folder.
But unfortunately, I still get the same error from the Create Spatial Type GP tool:
The database version is not supported. [Success] 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).
I also tried using an old ST_GEOMETRY .dll from an old ArcMap 10.7 installation (2016). But I got the same error with it too.
Regarding:
Not sure if the error is due to the minor version number, but the ArcGIS Desktop website states the supported Oracle 18c (64 bit) version to be 18.3.0.0.0, 18.4.0.0.0. Any chance for you to upgrade to release update 3 or 4 to try?
I'm going to look into that. But I suspect Oracle XE isn't upgradable.
Thanks for your help.
You shall be able to create the Enterprise Geodatabase ArcSDE Repository in your Oracle XE PDB, I never tried myself with Oracle XE because I know the limitations of Oracle XE, even if you manage to create the geodatabase under Oracle XE then the geodatabase might not work as expected, note, you need the st_geometry library only if you plan to run SQL Queries with st_geometry functions, otherwise the geodatabase will continue to work fine without the st_geometry library, an alternative to this is use Oracle SDO to store the data with your Oracle Geodatabase and use SDO functions with SQL, the st_geometry library is compiled for Oracle Standard and Enterprise Editions, thus even if you have the correct version of the st_geometry library that matches your Oracle XE version, the st_geometry library might not work with Oracle XE, I suggest you to install Oracle Standard Edition or Oracle Enterprise Edition, also consider to use Oracle 19c because Oracle 18c (Innovation Release) is deprecated now, and Oracle 21c ( the new Innovation Release) has a very short life spam and short patch cycle, the long term release with a long patch cycle is still 19c.
Release Schedule of Current Database Releases (Doc ID 742060.1)
Oracle Database (RDBMS) Releases Support Status Summary (Doc ID 161818.1)
Esri System Requirements for Oracle:
I hope this helps you.
I queried a different production environment that works with ST_GEOMETRY:
- Oracle 18c
- 10.7.1 enterprise geodatabase
- Full ST_Geometry library is available (not just the spatial type)
But I don't really know what I'm looking at in the result of that query. It mostly mentions 18.0.0.0.0. But does mention 18.3.0.0.0 in one spot.
I wonder what we can learn from that. In that environment, is ArcGIS Pro treating the database as 18.0.0.0.0 or as 18.3.0.0.0? If it's treating the database as 18.0.0.0.0, I wonder why my organization was able to create the spatial type in that environment, but I can't do it in my 18.0.0.0.0 XE environment?
In the error message, there's a path that can be used to check the setup log file.
I believe we can obtain additional information regarding the error message from the log file.