Thursday, June 9, 2011

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

No comments:

Windows (powershell) counterparts of Linux commands

You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...