Home > tips > How to check PSU version number

How to check PSU version number


After applying 11.2.0.2.2 PSU patch,I want to check to see the version number as 11.2.0.2.2 but, it was not shown in places:

1st the statement while connecting to database or ASM via sqlplus like:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production

2nd v$instance

3rd v$version

4th impdp

So what?

In MOS I bumped into a note regarding with the PSU versions after then.
Patch Set Updates for Oracle Products [ID 854428.1] [ID 854428.1]

Patch Set Updates are referenced by their 5-place version number.
The following OPatch commands are a simple way to determine the latest PSU installed in the Oracle Home.

For Database PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i “DATABASE PSU”

For CRS (Cluster Ready Services) PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i “TRACKING BUG” | grep -i PSU

For GI (Grid Infrastructure) PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i “gi psu”

At last I also checked this information from below link, while looking for keyword “5-place version number”.
http://forums.oracle.com/forums/thread.jspa?messageID=4250078&tstart=0

Advertisements
  1. Manuel
    July 6, 2012 at 2:24 pm

    Since 11.2.0.2.5 this command is the correct one:
    opatch lsinventory -bugs_fixed | grep -i -E “(DATABASE PSU|DATABASE PATCH)”

  2. January 8, 2014 at 10:07 pm

    You can also use the following SQL for the same:
    select comments Last_patch from dba_registry_history order by action_time desc
    /
    – Kirill Loifman, http://www.dadbm.com

  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

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: