topic Re: Oracle Geodatabase upgrade issue - Version 11.3 in Geodatabase Questions

Oracle Geodatabase upgrade issue - Version 11.3

Felipe — Wed, 08 Jan 2025 16:58:19 GMT

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

Re: Oracle Geodatabase upgrade issue - Version 11.3

VinceAngelo — Wed, 08 Jan 2025 18:13:12 GMT

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

- V

Re: Oracle Geodatabase upgrade issue - Version 11.3

Felipe — Wed, 08 Jan 2025 19:21:52 GMT

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!

Re: Oracle Geodatabase upgrade issue - Version 11.3

VinceAngelo — Wed, 08 Jan 2025 19:58:10 GMT

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

- V

Re: Oracle Geodatabase upgrade issue - Version 11.3

MarceloMarques — Sat, 11 Jan 2025 00:18:17 GMT

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,

Re: Oracle Geodatabase upgrade issue - Version 11.3

Felipe — Tue, 21 Jan 2025 18:56:14 GMT

Hello @MarceloMarques
Thank you for all the information. I have requested new Oracle Database deployment and will start migrating the data.

Best regards,
Felipe