nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database Upgrade to 19c or beyond

MisbahIrfan

Hi,

We plan to upgrade existing Geodatabases (10.1) that are sitting in Oracle 11gR2 (11.2.0.3). We plan to go to arcGIS 10.8 with Oracle 19c (19.12.0). Are there any folks who have successfully upgraded to latest patchset 19.8 or beyond and are running the stack smoothly? Are there are pitfalls? Are there things to watch before or at migration? My plan to create the empty databases with schemas and roles to manage GIS data, then create the SDE instances via desktop, and finally migrate the data via desktop from old to new DBs.

I'll appreciate if you can exchange your experience with this migration.

Also, can we use Oracle 21c?

Find more posts tagged with

Databases

Geodatabase Administration

Services

Accepted answers

All comments

George_Thompson

I will say that there is a lot to unpack on this migration / upgrade. The biggest thing would be to have an ArcGIS client that could connect to both Oracle versions. ArcGIS 10.8.1 "may" be able to connect to both, but minimum supported version of Oracle for 10.8.1 is 11.2.0.4 (https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-oracle.htm).

We do not support Oracle 21c as of 10.8.1, so it would not be a good version to target. As for support of 19.12, it would be the same as 19.8 which is supported unless otherwise documented.

Once you can connect to both version of the enterprise geodatabase, the copy/paste in ArcGIS client should do the trick.

Is your older 10.1 geodatabase versioned?

Asrujit_SenGupta

Or use a File Geodatabase in between...

Copy data from the 10.1 gdb to a File GDB --> Copy data from the File GDB to the 10.8.x gdb when its ready.

yockee

Hi, I am in the middle of upgrading as well : SDE (from 10.5 to 10.9) and oracle (from 12 to 19)

What about objects inside eGDB like Subtype, Domain, relationship class. Will they get copied into FGDB ?

And what about indexes, triggers and stored procedure, will they have to be rewritten on to the new DB ?

Thanks

George_Thompson

The EGDB functions (Subtype, Domain, relationship classes, etc.) should be copied into the fGDB when using Copy / Paste. Indexes should come over all.

Any database functionality (triggers, stored procedures, etc.) will not be copied into the fGDB as they are not supported there.

You will need to rebuild / recreate those once you have the Oracle 19c Enterprise Geodatabase ready.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.