Home > Oracle > How to verify PSU (patch set updates) on Oracle server

How to verify PSU (patch set updates) on Oracle server

Verify if PSU is installed in the ORACLE_HOME

$ opatch lsinv -bugs_fixed | grep PSU

8576156 8833280 Tue Feb 09 16:54:18 MST 2010 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJUL2009)
8833280 8833280 Tue Feb 09 16:54:18 MST 2010 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUOCT2009)

Verify the PSU Post Install steps were run in the DB

select substr(action_time,1,30) action_time,
substr(id,1,10) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(BUNDLE_SERIES,1,6) bundle,
substr(comments,1,20) comments
from registry$history;

ACTION_TIME ID ACTION VERSION BUNDLE COMMENTS
—————————- — —— ——– —— ————–
23-AUG-10 07.28.02.856762 AM 4 APPLY 10.2.0.4 PSU PSU 10.2.0.4.3
23-AUG-10 07.31.48.001892 AM 1 APPLY 10.2.0.4 PSU PSU 10.2.0.4.4

Note: The registry$history will not contain the row showing the PSU Post Install step was executed unless catbundle.sql is executed. This means if the Post Install steps were skipped because the db was upgraded or created after installing the PSU, this row will not exist

Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: