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 or greater
ORA-00722: Feature "SQL identity columns"


Refer to upgrade logfiles for more details:
Unpaused the database.
Failed to execute (UpgradeGDB).
Failed at Fri Sep 08 08:47:17 2017 (Elapsed Time: 1.16 seconds)
Oracle Database:

I am at a loss here. Any help appreciated.