Friday, August 30, 2013

How to check database PSU version number

You can check database PSU version number using following 2 ways :
1, SQL > select comments, action_time from sys.registry$history;

COMMENTS                                           ACTION_TIME
-------------------------------------------------- ---------------------------------------------------------------------------
PSU 11.1.0.7.6                                     10-SEP-11 09.15.23.962385 PM
view recompilation                                 10-SEP-11 09.21.53.526892 PM
PSU 11.1.0.7.11                                    22-SEP-12 11.59.38.688006 PM


2,  $ opatch lsinventory -bugs_fixed | grep -i -E "(DATABASE PSU|DATABASE PATCH SET UPDATE)"
8833297    13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
9209238    13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
9352179    13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
9654987    13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
9952228    13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
10248531   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11724936   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
12419384   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
12827740   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
13343461   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES 
13621679   13621679  Sat Sep 22 22:52:48 EDT 2012   DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES 

No comments:

Post a Comment