AnsweredAssumed Answered

Upgrade of Oracle Geodatabase

Question asked by craygo on Sep 8, 2017
Latest reply on Sep 8, 2017 by craygo
I am trying to upgrade from 10.1 geodatabase to 10.5 when I run the upgrade check it says all is good to upgrade, but when I actually run the upgrade I keep getting an error. Here is the output of the script.

Executing: UpgradeGDB "Database Connections\GISPROD as SDE.sde" PREREQUISITE_CHECK UPGRADE
Start Time: Fri Sep 08 08:47:16 2017
Paused the database for upgrade.
There are no other active connections.
User has privileges required to upgrade.
Connected RDBMS instance is setup for ST_GEOMETRY configuration.
Running Pre-Requisite check (C:\Users\Raymondg\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\GISPROD as SDE.sde).
Instance supports XML type.
Updating server tables and stored procedures.
Could not update server tables and stored procedures. (branches : Error (406)
  DBMS error code: 406
ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
ORA-00722: Feature "SQL identity columns"

 

)
Refer to upgrade logfiles for more details:
C:\Users\Raymondg\AppData\Local\Esri\Desktop10.5\GDBUpgrade.log
C:\Users\Raymondg\AppData\Local\Temp\sde_setup.log
Unpaused the database.
Failed to execute (UpgradeGDB).
Failed at Fri Sep 08 08:47:17 2017 (Elapsed Time: 1.16 seconds)
Oracle Database: 12.1.0.2
OS: SLES 11 SP4

I am at a loss here. Any help appreciated.

Thanks

Ray

Outcomes