Problem: We want to upgrade our Oracle 11g + ArcSDE 10.1.0 to Oracle 12c + ArcSDE 10.4.1
Steps tried so far:
Can anyone advise what we are doing wrong and what steps we are missing.
Thanks in advance
Seems like the Oracle Full Database Backup/Restore process may not have been done correctly. It is being treated as a Simple database.
(Check if R-clicking on the connection file in ArcCatalog gives you the 'Enable Geodatabase' option)
Also Step-4 is not necessary. Its for simple databases and not Enterprise Geodatabase.
The Create Spatial Type tool adds or upgrades the ST_Geometry SQL type, subtypes, and functions to an Oracle or PostgreSQL database. This allows you to use the ST_Geometry SQL type to store geometries in a database that does not contain a geodatabase. This tool also can be used to upgrade an existing ST_Geometry installation in an Oracle or PostgreSQL database.
The restore of the SDE user was done as part of the backup import. Then the upgrade geodatabase was done from the ArcGIS client on the new DB (Sorry, I think we missed listing that in the steps…). That would have been done between 6 and 7.
So you are saying if we are enterprise geodatabase (which we believe we are) we don’t need ST_Geometry? (or ST_Raster?). We don't have Oracle Spatial, does that make a difference? The original server had the ArcSDE application installed on it, but I believe that is no longer necessary on ArcGIS 10.4.
We believe the upgrade process has been corrupted somewhere so are going to try again from scratch.
It would be good to get a set of documented steps to go from existing Oracle/GIS to new Oracle/GIS. I wonder if we need to upgrade the geodatabase on the existing DB first? Will that mess with our ArcGIS clients who are using older versions of ArcGIS?
I think that point 9. Noticed the new SDE.LAYERS table is empty except for the table directly loaded using copy/paste. and you will need to identify why that table (or maybe other tables in the SDE schema) has been created but not populated during the Oracle Import/Export process...
How are you migrating the data from one database to the new one? Imp/exp? Backup/restore? Do you have a log of the process? Any error or warning during this process?