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

Query table cisadm.ci_ut_instl to confirm successfully applied a ORMN patch or not.

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

2 thoughts on “How to Check the Successful Installation of a Database Patch Onto ORMB Database”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.