I created PDB (version 19.10) via database link (from PDB version 19.13).
I opened it - and there were a lot of violations in PDB opening (patch mismatches etc.)
I run datapatch -verbose -pdb ... to rollback all the patches from 19.13 and implement patches from 19.10 home.
The output was :
Validating logfiles...done
Patch 33192694 rollback (pdb AAA): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33192694/24442454/33192694_rollback_CDBR_AAA_2022May25_15_18_42.log (errors)
-> Error at line 55: script javavm/install/jvmpsupdi.sql
- SP2-0310: unable to open file "/u01/app/oracle/product/db_1910/javavm/install/jvmpsupdii.sql"
Patch 29213893 rollback (pdb AAA): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29213893/24384541/29213893_rollback_CDBR_AAA_2022May25_15_18_43.log (no errors)
Patch 33430073 rollback (pdb AAA): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33430073/24509446/33430073_rollback_CDBR_AAA_2022May25_15_18_46.log (errors)
-> Error at line 106017: script rdbms/admin/dpload.sql
- ORA-65047: Object SYS.KU$_COLLIST_VIEW is invalid or compiled with errors in root.
- ORA-06512: at "SYS.RECOMP_CATMETA_VIEWS", line 35
- ORA-06512: at line 8
Patch 33192793 rollback (pdb AAA): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33192793/24467360/33192793_rollback_CDBR_AAA_2022May25_15_29_03.log (errors)
-> Error at line 217991: script md/admin/catsem.sql
- ORA-29548: Java system class reported: release of Java system classes in the
- database (19.0.0.0.211019 1.8) does not match that of the oracle executable
- (19.0.0.0.0 1.8)
- ORA-06512: at "SYS.DBMS_JAVA", line 587
- ORA-06512: at line 1
According to the logs, the real cause laid in the absence of $ORACLE_HOME/javavm/install/mpsupdii.sql file, which was in this place in oracle home version 19.13, but it also was in rollback catalog related to rollbacking patch :
gfind -name "*jvmpsupdii*"
./sqlpatch/33192694/24442454/rollback_files/19.1.0.0.0/javavm/install/jvmpsupdii.sql
I just put this file to directory ORACLE_HOME/javavm/install and rerun datapatch without errors. Good Luck !
No comments:
Post a Comment