{"id":24,"date":"2012-03-14T07:30:00","date_gmt":"2012-03-14T07:30:00","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/2012\/03\/14\/check-which-oracle-psu-are-installed\/"},"modified":"2015-11-17T20:27:24","modified_gmt":"2015-11-17T19:27:24","slug":"check-which-oracle-psu-are-installed","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2012\/03\/14\/check-which-oracle-psu-are-installed\/","title":{"rendered":"Check which Oracle PSU are installed"},"content":{"rendered":"<p>With latest version of OPatch:<\/p>\n<div style=\"font-family: &quot;Trebuchet MS&quot;,sans-serif;\">\n<p>$ORACLE_HOME\/OPatch\/opatch lsinventory -bugs_fixed | grep -i &#8216;DATABASE PSU&#8217;<\/p><\/div>\n<p>\n<b>or<\/b><\/p>\n<p><span style=\"font-size: x-small;\"><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\">set lines 255<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\ncol action_time for a40<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\ncol action for a8<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\ncol namespace for a7<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\ncol version for a11<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\ncol comments for a40<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\nselect substr(ACTION_TIME,1,40) action_time,substr(ACTION,1,8) action,substr(NAMESPACE,1,7) namespace,<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\nsubstr(VERSION,1,11) version,ID,substr(COMMENTS,1,40) comments,BUNDLE_SERIES<\/span><br style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\" \/><span style=\"font-family: &quot;Courier New&quot;,Courier,monospace;\"><br \/>\nfrom registry$history; <\/span><\/span><\/p>\n<p>To install latest OPatch, after download (make sure you only have OPatch zip for the correct Oracle version: 10.2, 11.1, 11.2):<\/p>\n<ul style=\"font-family: &quot;Trebuchet MS&quot;,sans-serif;\">\n<li>mv $ORACLE_HOME\/OPatch $ORACLE_HOME\/OPatch.old<\/li>\n<li>unzip p6880880* -d $ORACLE_HOME<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>With latest version of OPatch: $ORACLE_HOME\/OPatch\/opatch lsinventory -bugs_fixed | grep -i &#8216;DATABASE PSU&#8217; or set lines 255 col action_time for a40 col action for a8 col namespace for a7 col version for a11 col comments for a40 select substr(ACTION_TIME,1,40) action_time,substr(ACTION,1,8) action,substr(NAMESPACE,1,7) namespace, substr(VERSION,1,11) version,ID,substr(COMMENTS,1,40) comments,BUNDLE_SERIES from registry$history; To install latest OPatch, after download (make sure [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,6,18,19],"tags":[],"class_list":{"0":"post-24","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-opatch","7":"category-oracle","8":"category-patchset-update","9":"category-psu","10":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/24\/revisions"}],"predecessor-version":[{"id":168,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/24\/revisions\/168"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}