I am running a single instance database version 12.1.0.2 on Rhel 6.7.
I applied the 12.1.0.2.160119 (21948354) database patch set update, and followed instructions exactly as per the patchset instructions, including to run the datapatch -verbose after applying the opatch patchset.
Everything looks perfectly successful.
Validating logfiles...
Patch 21948354 apply: SUCCESS
logfile: /oracle/product/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_SSSAOPSD_2016May04_07_10_37.log (no errors)
SQL Patching tool complete on Wed May 4 07:10:43 2016
Next, I check the registry$history view in each database on this server, and they are empty.
There is no history of patches applied.
So, next, per the instructions, I checked dba_registry_sqlpatch for each database, and they show the patch has been applied with status SUCCESS.
| PATCH_ID |
PATCH_UID VERSION |
FLAGS |
ACTION |
STATUS |
--------- --------------- -------------------- ---------- --------------- ---------
| 21948354 |
19553095 12.1.0.2 |
NB |
APPLY |
SUCCESS |
So, then, confirming the opatch lsinventory, it shows everything applied successfully too.
| Patch 21948354 |
: applied on Wed May 04 07:07:35 CDT 2016 |
Unique Patch ID: 19553095
Patch description: "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
So, question is: why doesn't registry$history show patches applied.