Showing posts with label Find Patch Set Version opatch database oracle. Show all posts
Showing posts with label Find Patch Set Version opatch database oracle. Show all posts

Wednesday, 14 August 2013

Determining the Patch Set Update Version


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 | egrep -i 'PSU|DATABASE PATCH SET UPDATE'

A list will be output, and the highest release version reported is the current PSU installed. In the following example output, 11.2.0.2.6 is the installed Database PSU:

10248523   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.1
11724916   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
12419331   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
12827726   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
13343424   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPUJAN2012)
13696224   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPUAPR2012)


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 'GRID INFRASTRUCTURE PATCH SET UPDATE'

For Enterprise Manager Agent PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER' | grep -i 'AGENT'

For Enterprise Manager OMS PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER' | grep -i 'OMS'

For WebLogic Server PSUs, enter the following commands, where WL_HOME is the path of the WebLogic home:
$ . $WL_HOME/server/bin/SetWLSEnv.sh 
$ java weblogic.version
In the following example output, 10.3.4.0.1 is the installed WebLogic Server PSU.
WebLogic Server 10.3.4.0.1 PSU Patch for Bug11677325 Wed Feb 23 10:52:30 IST 2011
WebLogic Server 10.3.4.0  Fri Dec 17 20:47:33 PST 2010 1384255