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