eGDB Oracle SDE.VERSION.RELEASE value

[JamesMorrison1]

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.

[George_Thompson · Accepted solution]

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.

[JamesMorrison1]

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

[JamesMorrison1]

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.