Value of VERSION column in registry$sqlpatch set to 0 after upgrade to 12cR2

Jul 22, 2019 1:52AM

I just upgraded database from 12cR1 to 12cR2. I found the value of VERSION column in registry$sqlpatch set to 0 after upgrade to 12cR2.

BEFORE UPGRADE =>

select PATCH_ID, ACTION, ACTION_TIME, STATUS, VERSION from registry$sqlpatch;

PATCH_ID ACTION ACTION_TIME STATUS VERSION

---------- --------------- ------------------------------ --------------- --------------------

24732082 APPLY 05-JUL-17 11.00.08.688933 AM SUCCESS 12.1.0.2

27475603 APPLY 23-MAY-18 11.36.50.583962 AM SUCCESS 12.1.0.2

27338041 APPLY 23-MAY-18 11.36.50.771398 AM SUCCESS 12.1.0.2

27475603 ROLLBACK 24-SEP-18 02.28.36.401254 PM SUCCESS 12.1.0.2

27923320 APPLY 24-SEP-18 02.28.36.405818 PM SUCCESS 12.1.0.2

27547329 APPLY 24-SEP-18 02.28.36.782418 PM SUCCESS 12.1.0.2

AFTER UPGRADE =>

select PATCH_ID, ACTION, ACTION_TIME, STATUS, VERSION from registry$sqlpatch;

PATCH_ID ACTION ACTION_TIME STATUS VERSION

---------- --------------- ------------------------------ ------------------------- --------------------

24732082 APPLY 05-JUL-17 11.00.08.688933 AM SUCCESS 0

Database Install/Upgrade/Opatch (MOSC)