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

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

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

 

Advertisements
This entry was posted in ORMB and tagged , , , . Bookmark the permalink.

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

  1. Pingback: How to Install Database Component of a Patch onto ORMB Database | James Huang Oracle DBA Blog

  2. Pingback: How to Apply Database Component Of a Patch Onto OR|MB Database | James Huang – Databases Consultant

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s