Problems with Single Instance Upgrades to Oracle Cloud Database 19c on OCC 20.4

The following solutions apply to problems with upgrading single instance database deployments on Oracle Cloud at Customer (OCC) 20.4 to Oracle Database Classic Cloud Service 19c.

My Upgrade Process Failed

In case of any failure in the upgrade process, the database can be reverted back to the state before the upgrade.

Note:

This command will not work after a successful upgrade.

Revert the database upgrade by executing the following command:

dbaascli database upgrade --dbname ORCL --targetHome <old_db_home_path_on_target_vm> --revert

Sample Result:

dbaascli database upgrade --dbname ORCL --targetHome /u01/app/oracle/product/18.0.0/dbhome_1 --revert
 
INFO : Executing script /u01/app/oracle/product/18.0.0/dbhome_1/rdbms/admin/utlrp.sql
INFO : Output shall be spooled to /u01/app/oracle/cfgtoollogs/ORCL/downgrade/
INFO : utlrp.sql executed
INFO : Downgrade completed

I am Not Sure if Datapatch Succeeded or Failed

You can see the below listed examples to determine if datapatch succeeded or failed.

Example of a Successful Datapatch:

Patch 27923415 rollback (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27923415/22239273/27923415_rollback_ORCL_CDBROOT_2021Jan19_18_47_01.log (no errors)
For the following PDBs: CDB$ROOT PDB$SEED PDB1
    Nothing to roll back
    Nothing to apply

Example of a Failed Datapatch:

Patch 28257338 rollback (pdb CDB$ROOT): WITH ERRORS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28257338/22299610/28257338_rollback_ORCL_CDBROOT_2021Jan19_18_48_18.log (errors)
  -> Error at line 2304: script rdbms/admin/prvtrmns.plb
      - Warning: Package Body created with compilation errors.

My Datapatch Process Failed

In case of any failure in the datapatch process, you can retry the datapatch. Ensure that you look into the output file for issues or recommendations that may have caused the failure.

For Example:

Patch 28257338 rollback (pdb CDB$ROOT): WITH ERRORS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28257338/22299610/28257338_rollback_ORCL_CDBROOT_2021Jan19_18_48_18.log (errors)
  -> Error at line 2304: script rdbms/admin/prvtrmns.plb
      - Warning: Package Body created with compilation errors.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_2631_2021_01_19_18_46_00/sqlpatch_invocation.log
for information on how to resolve the above errors.