AnsweredAssumed Answered

Upgrade Geodatabase along with Oracle

Question asked by Reda4esri on May 18, 2020
Latest reply on May 18, 2020 by George_Thompson-esristaff

We are Planning to upgrade Oracle Database from 11.2.0.1 to 19.3  & Geodatabase from 10.1 to 10.7.1

  Current environment :-                                           Upgraded Environment:-

 Geodatabase 10.1                                                   Geodatabase 10.7.1

 ArcGIS 10.1                                                              ArcGIS 10.7.1

 Oracle 11.2.0.1                                                          Oracle 19.3

 

The Planned Steps:-

 1. Backup DB using RMAN.

 2. Create a Testing Environment

 3. Upgrade Geodatabse on testing from 10.1 to 10.3  Version     Q ( is 10.3  compatabile with oracle 11.2.0.1 ?)

 4. Create a Full dump file from oracle db 10.3.

 5. Install oracle 19.3.

 6. Import SDE 10.3 schema                Q (is it compatabile with oracle 19.3).

 7. Import Other users schemas.

 8. Upgrade Geodatabase directly to 10.7.1

 8. Test the Results.

 9. if it is ok apply on production environment.

 

Please, help regarding the steps and compatability.

Outcomes