The branch versioning package is missing from ArcGIS Enterprise 10.6.1 geodatabase within the Oracle Database 12c instance which is migrated from the Oracle Database 11g release.

Additional Information

Workaround

Workaround 1: A Desktop client at the same version as the geodatabase may be used to upgrade the geodatabase internals, if the following are true:

1. The message "database internals such as stored procedures can be upgrade" is returned.
2. The 'Upgrade Geodatabase' option is enabled.

Workaround 2: For cases in which 'Upgrade Geodatabase' cannot be run against the geodatabase from the same version ArcGIS client, the following workaround has been successful in updating the 10.6.1 geodatabase internals.Note: The following workaround requires back-end modification of the geodatabase system tables. A full database backup should be confirmed prior to implementing.

1. Connect to the Oracle 12c geodatabase in SQL Plus or SQL Developer and modify the SDE.VERSION table columns to match those of a 10.6.0 geodatabase.
2. In ArcCatalog 10.6.1 connect to the Oracle 12c geodatabase as the SDE user and run Upgrade Geodatabase.
3. In SQL Plus/SQL Developer, connect to the 12c geodatabase as SDE, check for for INVALID objects in the SDE Schema and recompile invalid objects as needed.  
   1. select object_name from user_objects where status <> 'VALID';
   2. exec sys.utl_recomp.recomp_serial('SDE');
4. Test 'Enable Archiving' on a feature class (which leverages the Branch Util package in 10.6.1, 12c GDB), if it fails in ArcMap (error message such as "Failed to enable archiving. Function called out of sequence" is returned), manually rebuild BRANCH_UTIL package.
   1. SQLPLUS sde/password@DatabaseServer/OracleSID
   2. start 'C:\Program Files (x86)\ArcGIS\Desktop10.6\lib\branch_util.sps' SDE;
   3. start 'C:\Program Files (x86)\ArcGIS\Desktop10.6\lib\branch_util.spb' SDE;
   4. grant EXECUTE on sde.branch_util to public;
   5. grant EXECUTE on sde.branch_util to public;
   6. grant EXECUTE on sde.spx_util to public;

Steps to Reproduce