topic eGDB Oracle SDE.VERSION.RELEASE value in Geodatabase Questions

eGDB Oracle SDE.VERSION.RELEASE value

JamesMorrison1 — Thu, 08 Aug 2024 13:33:21 GMT

Hello Everyone

June 2023 I upgraded our TEST instance to the following:

Geodatabase 11.1
ArcGIS Pro 3.1.0
Oracle 19.16.0.0
ST_GEOMETRY
Linux

select * from sde.version

11 1 0 ArcGIS Pro 3.1.0 - 11.1.0.41833 109206 93001

In the RELEASE column is the value 109206 - I would have expected something with an 11+

Question - Other than the sde.version table is there any other way to know the actual release level of your eGDB? Are there certain Oracle objects in the SDE Schema (procedures, tables,...) which would be present in 11.1 but not present in 10.9?

Feedback appreciated.

Re: eGDB Oracle SDE.VERSION.RELEASE value

George_Thompson — Thu, 08 Aug 2024 14:54:52 GMT

Not that I am aware of. Those values are only updated once the upgrade is successful, so I would assume that all the other components in the EGDB are at that version.

That # you mention is not necessarily related to the release version. The "11.1.0.41833" is more important as that is the release information.

You can look in Pro also to see what the version reporting says.

Re: eGDB Oracle SDE.VERSION.RELEASE value

JamesMorrison1 — Thu, 08 Aug 2024 15:04:52 GMT

Thanks George.

Our goal is to upgrade to 11.3 using ArcGIS Pro 3.3 so I was trying to understand what actual release our eGDB.

I assumed 11.1 but was confused by this RELEASE value which looks like 10.9.x

Re: eGDB Oracle SDE.VERSION.RELEASE value

JamesMorrison1 — Wed, 14 Aug 2024 07:42:15 GMT

ESRI Inc replied

Additional Information: The Geodatabase Release is determined by the values in Major/Minor/BugFix and/or Description fields of the sde_version table. The \"release\" column is an internal release number and should not be used. The correct version will also be displayed on the Database Properties dialog under Geodatabase Version.