Getting some issues applying 18.6.0.19.1416 over a running 18.2 dbsystem from the OCI Console.
Patching was showing successful from the OCI COnsole, but the PDB was started with restricted access, and datapatch showed the following error:
Adding patches to installation queue and performing prereq checks…done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
29613182 (MERGE ON DATABASE RU 18.6.0.0.0 OF 27710072 29250317)
For the following PDBs: XXX
No interim patches need to be rolled back
Patch 29301631 (Database Release Update : 18.6.0.0.190416 (29301631)):
Apply from 18.2.0.0.0 Release_Update 1804041635 to 18.6.0.0.0 Release_Update 1903190102
The following interim patches will be applied:
29613182 (MERGE ON DATABASE RU 18.6.0.0.0 OF 27710072 29250317)
Error: prereq checks failed!
patch 29613182:
Is not successfully installed in CDB$ROOT but is to be applied to XXX.
This will cause a patch mismatch between XXX and CDB$ROOT and prevent
the PDB from opening unrestricted. Please use the allow_pdb_mismatch option if this is really intended.
I went ahead and rollback 29613182 with OPatch
Once 29613182 was rollbacked, now datapatch returned the following error
Validating logfiles…done
Patch 29301631 apply (pdb XXX): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29301631/22832106/29301631_apply_OSC_XXX_2019May23_07_47_45.log (errors)
-> Error at line 73817: script rdbms/admin/prvtbsch.plb
- 4498/3 PL/SQL: Statement ignored
-> Error at line 73818: script rdbms/admin/prvtbsch.plb
- 4498/3 PLS-00306: wrong number or types of arguments in call to
-> Error at line 73821: script rdbms/admin/prvtbsch.plb
- 4532/3 PL/SQL: Statement ignored
-> Error at line 73822: script rdbms/admin/prvtbsch.plb
- 4532/19 PLS-00302: component 'ADD_JOB_EMAIL_NOTIFICATION_PH3' must be
Workaround was to recompile the sys.dbms_scheduler package body.
SQL> alter session set container=xxx;
Session altered.
SQL> show errors package body dbms_scheduler
Errors for PACKAGE BODY DBMS_SCHEDULER:
LINE/COL ERROR
4498/3 PL/SQL: Statement ignored
4498/3 PLS-00306: wrong number or types of arguments in call to
'ADD_JOB_EMAIL_NOTIFICATION'
4532/3 PL/SQL: Statement ignored
4532/19 PLS-00302: component 'ADD_JOB_EMAIL_NOTIFICATION_PH3' must be
declared
SQL> alter package sys.dbms_scheduler compile;
Package altered.
SQL> show errors package body dbms_scheduler
No errors.
SQL>
Now datapatch complete with no error:
And 29613182 can be reapplied, this time manually, with OPatch
... Patching component oracle.rdbms.rsf, 18.0.0.0.0… Patching component oracle.rdbms.dbscripts, 18.0.0.0.0… Patching component oracle.rdbms.rman, 18.0.0.0.0… Patching component oracle.rdbms, 18.0.0.0.0… Patch 29613182 successfully applied.
And datapatch could complete successfully:
...
Adding patches to installation queue and performing prereq checks…done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED XXX
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
29613182 (MERGE ON DATABASE RU 18.6.0.0.0 OF 27710072 29250317)
Validating logfiles…done
Patch 29613182 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29613182/22853182/29613182_apply_OSC_CDBROOT_2019May23_08_08_29.log (no errors)
Patch 29613182 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29613182/22853182/29613182_apply_OSC_PDBSEED_2019May23_08_08_46.log (no errors)
Patch 29613182 apply (pdb XXX): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29613182/22853182/29613182_apply_OSC_XXX_2019May23_08_08_46.log (no errors)
SQL Patching tool complete on Thu May 23 08:09:05 2019