How to Check the Successful Installation of a Database Patch Onto ORMB Database

After applied the database component of a patch, we can run the following sql to check  whether the database component was installed successfully , or skipped because it has been installed before.

Here both ‘22505470’ and ‘9999999″ are ORMB patch id.

SQL> select sr_no,run_status_flg,END_DTTM 
       from cisadm.ci_ut_instl 
      where sr_no in ( '22505470' ) 
        and run_status_flg = '02' and 
   END_DTTM IS Not NULL;

SR_NO    RU  END_DTTM
-------- --- ------------------
22505470 02  20161125-09:20:34

If the database component was not included or was not installed, an empty result set is returned.

SQL> select sr_no,run_status_flg,END_DTTM from cisadm.ci_ut_instl 
      where sr_no in ( '9999999' ) 
        and run_status_flg = '02' 
        and END_DTTM IS Not NULL;

no rows selected