We are trying to downgrade our 12.1.0.2 upgrade to 11.2.0.4. Following the steps in Doc ID 1516622.1 document and its failing when executing the downgrade script (@$ORACLE_HOME/rdbms/admin/catdwgrd.sql)
Below is the error.
SQL> @$ORACLE_HOME/rdbms/admin/catdwgrd.sql
Session altered.
PL/SQL procedure successfully completed.
Function created.
Function dropped.
The following patches are still installed in the database.
Run 'datapatch -rollback all -force' to uninstall them.
SQL patch ID/UID 19877336/18313828 (Database PSU 1
DBBP bundle patch 161018 (DATABASE BUNDLE PATCH: 1
DECLARE
*
ERROR at line 1:
ORA-20000: All SQL patches must be rolled back before downgrade
ORA-06512: at line 25
Tried executing datapatch -rollback all -force and it still fails with below error.
oracle:ARC11 $ datapatch -rollback all -force
SQL Patching tool version 12.1.0.2.0 on Wed Mar 22 10:29:37 2017
Copyright (c) 2016, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
The following patches will be rolled back:
19877336 (Database PSU 12.1.0.2.2, Oracle JavaVM Component (Jan2015))
24340679 (DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679))
Nothing to apply
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...
Patch 24340679 rollback: WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24340679/20713212/24340679_rollback_ARC1_2017Mar22_10_29_40.log (errors)
Error at line 66643: 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_120343_2017_03_22_10_29_37/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Wed Mar 22 10:30:32 2017