PSU, pathches infor can't display

damthanhlong

Dear All
We add Oracle by GUI these information work well, but PUS pathches infor can't show as below.
Our oracle is 12C. Please help us
Many thanks.

damerva

Hello,

run these queries, and send us the output

select&nbsp; to_char(action_time,'yyyy-mm-dd') "DATE",<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; action,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; namespace,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version,id,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; comments<br>&nbsp; from&nbsp; sys.registry$history<br>&nbsp; order by action_time;

select&nbsp; to_char(action_time,'yyyy-mm-dd') "DATE",<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; patch_id,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; action,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; description<br>&nbsp; from&nbsp; sys.registry$sqlpatch<br>&nbsp; order by action_time;

edit: run them on the affected database as the same user you use for monitoring. Most likely "lpar2rrd" or "lpar2rrd_check"

damthanhlong

Many thanks damerva