opatchauto sql apply, cdb_registry_sqlpatch

Hi,

After patching a RAC with opatchauto maybe there is an issue if you check the SQL patch was applicated.

The query :

select b.con_id,nvl(b.name,'root') "name",PATCH_ID,PATCH_UID,VERSION,ACTION_TIME, STATUS from cdb_registry_sqlpatch a full outer join v$pdbs b

on a.con_id=b.con_id

order by CON_ID, ACTION_TIME;

only shows the correct results for PDBs on the instance where the SQL-patch was applied.

first  instance (node 1):

        11 PDB_EVTEST             26609817   21483023 12.2.0.1   05.09.17 10:10:53,009493     SUCCESS

        =>missing 11 PDB_EVTEST             27105253   21862470 12.2.0.1   24.01.18 11:53:20,640302     SUCCESS

second/last instance (node 2) (where the SQL Patch was applied)

        11 PDB_EVTEST             26609817   21483023 12.2.0.1   05.09.17 10:10:53,009493     SUCCESS