Upgrade Oracle to 19.3

2578
10
Jump to solution
09-09-2022 05:41 PM
forestknutsen1
MVP Regular Contributor

We want to upgrade Oracle to 19.3

Our current environment looks like this 

  • ArcGIS Enterprise 10.8.1
  • Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
  • ArcGIS Desktop/Geodatabase 10.6.1 with the "Support for Oracle 19c Patch" installed

forestknutsen1_0-1662769886289.pngforestknutsen1_1-1662769919848.png

I don't think I need to patch ArcGIS Enterprise as it is at 10.8.1, so it looks like I have all the Esri patches installed that I will need.

So, the plan is right now to:

  1. Setup a new test server with an empty Oracle 19c (64 bit) 19.3.0.0.0 database
  2. Add the shapelib file to the server and set it's path in the new database
  3. Export everything from our production database with the export data pump
  4. Import everything into the new 19c database

Does this sound reasonable?

https://desktop.arcgis.com/en/system-requirements/10.6/database-requirements-oracle.htm

https://support.esri.com/en/download/7734

 

 

Tags (1)
0 Kudos
10 Replies
forestknutsen1
MVP Regular Contributor

Got it thanks!

0 Kudos