DBsystem: Issues with upgrading to 18.6.0.190416

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

Advertisements
%d bloggers like this: