DB Dummy|Sharing Experience on Oracle & Informix Databases …

Reference to Metalink Doc 861152.1, to determine PSU version installed in your Oracle Home :-

1) Ensure that opatch version is having version of at least / or higher than :-

10.2.0.4.5 for version 10gR2 Oracle Home

11.1.0.6.5 for version 11gR1 Oracle Home

11.2.0.1.0 for version 11gR2 Oracle Home

2) Verifying PSU version installed in Oracle Home binaries :-

$ opatch lsinv -bugs_fixed | grep -i ‘database psu’
8833297    9952228   Thu Dec 09 12:10:42 WST 2010   DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
9209238    9952228   Thu Dec 09 12:10:42 WST 2010   DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
9352179    9952228   Thu Dec 09 12:10:42 WST 2010   DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
9654987    9952228   Thu Dec 09 12:10:42 WST 2010   DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
9952228    9952228   Thu Dec 09 12:10:42 WST 2010   DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)

3) Verifying if Post Install steps for PSU has been executed against Database :-

SQL> select substr(action_time,1,30) action_time,
  2  substr(id,1,10) id,
  3  substr(action,1,10) action,
  4  substr(version,1,8) version,
  5  substr(BUNDLE_SERIES,1,6) bundle,
  6  substr(comments,1,20) comments
  7* from registry$history;

ACTION_TIME                    ID         ACTION       VERSION      BUNDLE COMMENTS
—————————— ———- ———— ———— —— ——————–
16-NOV-10 02.07.25.629130 PM   5          APPLY        11.1.0.7     PSU    PSU 11.1.0.7.5
16-NOV-10 02.53.11.269553 PM   6452863    CPU                              view recompilation
16-NOV-10 03.11.58.738797 PM   6452863    CPU                              view recompilation

SQL>