Fast DBA: DBA_REGISTRY_HISTORY is not updated during upgrade to 12.1.0.2

Problem:

DBA_REGISTRY_HISTORY is not updated during upgrade to 12.1.0.2 or completly blank in Oracle 12.1.0.2.

Solution:

Please refer to Doc ID 19518079.8 or you can use new DBA_REGISTRY_SQLPATCH view that was introduced in Oracle 12.1.0.2.

-- DB VERSION

SQL> select banner from v$version;

BANNER

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

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE 12.1.0.2.0 Production

TNS for Linux: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

-- DBA_REGISTRY_HISTORY

SQL> select * from DBA_REGISTRY_HISTORY ;

no rows selected

-- DBA_REGISTRY_SQLPATCH

SQL> select DESCRIPTION from DBA_REGISTRY_SQLPATCH;

DESCRIPTION

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

Database Patch Set Update : 12.1.0.2.2 (19769480)

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.

Fast DBA