Oracle Geodatabase upgrade issue - Version 11.3

[Felipe]

Hello Community,

I am trying to upgrade an Enterprise Geodatabase from the version 11.1 to the version 11.3, running on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0.

But I am receiving the following error:

Could not upgrade multiple schema or database instance. [The master geodatabase contains user schema geodatabases which should be upgraded separately after the master geodatabase is upgraded.
Id Version Instance
---- ------- -------------------]

It is weird because I am connected with the SDE user and I am sure that it is the master geodatabase schema.

Is there an efficient way to query this error in the database admin tables?
I already upgraded other geodatabases using the same ArcGIS Pro installation, and it worked normally. It discarded the possibility to be a problem with the ArcGIS Pro, Oracle client or Oracle version.

Did somebody had similar issue recently?
Any help would be much appreciated.

Thank you.
KR
Felipe

[VinceAngelo]

User schema geodatabases have been deprecated for more than four years. Are you sure this is even possible?

- V

[Felipe]

Hi @VinceAngelo , thank you for your answer!

Indeed, it is very strange, and the message shows an empty list when I get the error:

More or less 6 months ago, this database has been successfully upgraded from 10.9.1 to 11.1, with no errors:

Do you think the error is coming from some corrupted table?
Thank you!

[VinceAngelo]

I think the deprecation is being enforced by 3.3/10.3.

- V

[MarceloMarques]

Hello @Felipe 

Esri User-Schema Geodatabases in Oracle are deprecated.

Read more in the blog articles below.

ArcSDE User-Schema Geodatabases in Oracle are deprecated

Oracle 23ai (23c) Support for ArcGIS

Enterprise Geodatabase in Oracle CDB & PDB - Best Practices and Recommendations

Regards,