RE: Identify CPU/PSU patch
Date: Wed, 31 Aug 2011 18:36:05 +0200
PSU patches can easily be identified with opatch lsinventy -bugs_fixed:
[xxxx_at_xxxxx ~]$ opatch lsinventory -bugs_fixed | grep PSU
10248523 11724916 Tue May 17 16:08:01 CEST 2011 DATABASE PSU 18.104.22.168.1 11724916 11724916 Tue May 17 16:08:01 CEST 2011 DATABASE PSU 22.214.171.124.2 (INCLUDES CPUAPR2011) 12311357 12311357 Tue May 17 16:07:34 CEST 2011 GI PSU 126.96.36.199.2 (INCLUDES DATABASE PSU 188.8.131.52.
In principle you can do the same with CPU, but the number of false positives will be mutch higher.
Oracle Database Administrator
tel +32(0)3 451 23 82
--- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: woensdag 31 augustus 2011 18:09 To: oracle-l_at_freelists.org Subject: Identify CPU/PSU patch Hi Does anyone know what is best way to identify as what CPU/PSU patch is applied to the existing Oracle Software. We have 100's of database servers and some new are added on regular basis. In order to make sure that new database got the CPU or PSU Patch applied and so what is best way to get this details. One way is to get this from Opatch and then take the latest patch number and search with metalink to get idea if this is part of which CPU.PSU patch. This is surely cumbersome or not efficient approach. Also cannot use existing database with existing software as it might be missed to apply the patch in the database. TIA Sanjay -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 31 2011 - 11:36:05 CDT