My Oracle Support Banner

[OCI] : Without Datapatch Execution Patching Says Success : No Patch Details In CDB_REGISTRY_SQLPATCH (Doc ID 2671130.1)

Last updated on MAY 25, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

OCI DB system.  After Applying DB Patches either Jan 2020 or Oct 2019, user can see the Patch from OPatch inventory, but don't see the same from DB registry CDB_REGISTRY_SQLPATCH.

There is a mismatch. looking for the cause.

SQL> !hostname -f;/u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch/opatch lsinv | grep -i description

cxxxe4.nxxxxezj.vcxxxwx.oraclevcn.com
ARU platform description:: Linux x86-64
Patch description: "Database Bundle Patch : 12.1.0.2.200114 (30364137)"  <<<<<<<Patch description: "OCW PATCH SET UPDATE 12.1.0.2.200114 (30304402)"
Patch description: "Database PSU 12.1.0.2.180717, Oracle JavaVM Component (JUL2018)"

SQL> select con_id,patch_id, action, action_time, description from cdb_registry_sqlpatch order by action_time;

CON_ID PATCH_ID ACTION ACTION_TIME DESCRIPTION
-----------------------------------------------------------------------------------------
  1 27923320 APPLY 17-JUL-18 07.48.47.548814 PM Database PSU 12.1.0.2.180717, Oracle JavaVM Component (JUL2018)
  1 27547374 APPLY 17-JUL-18 07.48.49.420673 PM DATABASE BUNDLE PATCH 12.1.0.2.180717
  1 28239892 APPLY 17-JUL-18 07.48.50.672632 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 20493163 21117072
  3 27923320 APPLY 17-JUL-18 07.48.50.706908 PM Database PSU 12.1.0.2.180717, Oracle JavaVM Component (JUL2018)
  3 27547374 APPLY 17-JUL-18 07.48.52.588207 PM DATABASE BUNDLE PATCH 12.1.0.2.180717
  3 28239892 APPLY 17-JUL-18 07.48.54.486636 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 20493163 21117072
  1 28239892 ROLLBACK 23-APR-19 10.24.47.615591 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 20493163 21117072
  1 28731800 APPLY 23-APR-19 10.24.47.633124 PM DATABASE BUNDLE PATCH 12.1.0.2.190115
  1 29149318 APPLY 23-APR-19 10.24.47.682228 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190115 FOR BUGS 18382302 21117072
  3 28239892 ROLLBACK 23-APR-19 10.24.47.929242 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 20493163 21117072
  3 28731800 APPLY 23-APR-19 10.24.47.948299 PM DATABASE BUNDLE PATCH 12.1.0.2.190115
  3 29149318 APPLY 23-APR-19 10.24.47.999506 PM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190115 FOR BUGS 18382302 21117072
  1 29149318 ROLLBACK 14-MAY-19 04.01.09.148923 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190115 FOR BUGS 18382302 21117072
  1 29141038 APPLY 14-MAY-19 04.01.09.170228 AM DATABASE BUNDLE PATCH 12.1.0.2.190416
  3 29149318 ROLLBACK 14-MAY-19 04.01.09.368887 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190115 FOR BUGS 18382302 21117072
  3 29141038 APPLY 14-MAY-19 04.01.09.382646 AM DATABASE BUNDLE PATCH 12.1.0.2.190416
  1 29366865 APPLY 14-MAY-19 04.24.03.099305 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190416 FOR BUGS 21117072 23182225
  3 29149318 ROLLBACK 14-MAY-19 04.24.03.264155 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190115 FOR BUGS 18382302 21117072
  3 29366865 APPLY 14-MAY-19 04.24.03.317216 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190416 FOR BUGS 21117072 23182225
  1 29366865 ROLLBACK 01-OCT-19 12.06.24.375741 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190416 FOR BUGS 21117072 23182225
  3 29366865 ROLLBACK 01-OCT-19 12.06.24.573216 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190416 FOR BUGS 21117072 23182225
  1 29496791 APPLY 01-OCT-19 12.18.19.221605 AM DATABASE BUNDLE PATCH 12.1.0.2.190716
  3 29496791 APPLY 01-OCT-19 12.18.19.360716 AM DATABASE BUNDLE PATCH 12.1.0.2.190716
  1 29857136 APPLY 01-OCT-19 12.32.50.590955 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190716 FOR BUGS 29366865
  3 29857136 APPLY 01-OCT-19 12.32.50.862506 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190716 FOR BUGS 29366865
  1 29857136 ROLLBACK 03-DEC-19 06.04.59.058517 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190716 FOR BUGS 29366865
  3 29857136 ROLLBACK 03-DEC-19 06.04.59.260030 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.190716 FOR BUGS 29366865
  1 29972716 APPLY 03-DEC-19 06.11.55.995568 AM DATABASE BUNDLE PATCH 12.1.0.2.191015
  3 29972716 APPLY 03-DEC-19 06.11.56.076330 AM DATABASE BUNDLE PATCH 12.1.0.2.191015
  1 30290077 APPLY 03-DEC-19 06.32.43.245043 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439
  3 30290077 APPLY 03-DEC-19 06.32.43.554080 AM MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.