Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended for a DBA to properly document all applied patches to the software installation. The output of ‘opatch lsinventory’ will give you a list of bug numbers, but it can be awkward to cross reference them with the base bug numbers or specific CPU that was applied. With the addition of logging proper information in dictionary table registry$history we have improved upon this need<\/p>\n
RDBMS Versions 9.2 and higher<\/strong>For 9.2 and up you can simply ask this with “opatch lsinventory” , this will list all installed patches. <\/strong>Alternatively if you want to avoid OPatch you can “grep” the Opatch inventory for the CPU patch numbers by use of\u00a0 a shell script. But since opatch is needed in 9.2 and up to install the CPU patches, it will be always present in 9.2 and up.<\/p>\n RDBMS Verssions prior to 9.2<\/strong>For 8.1.7 and 9.0.1 use of OPatch not possible, however installing a 9.0.1 or 8.1.7 CPU will Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-909","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\n
\nOracle recommend to have latest patch installed .<\/strong>From CPUJan2006 onwards, for the OPatch installed CPU’s it is possible to do the following query:<\/strong>col action for a6
\ncol namespace for a9
\ncol version for a10
\ncol id for 99999999
\ncol comments for a10
\nselect * from registry$history;
\nSQL> SQL> SQL> SQL> SQL> SQL>
\nACTION_TIME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ACTION NAMESPACE VERSION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ID COMMENTS
\n—————————- —— ——— ———- ——— ———-
\n09-MAY-07 07.17.43.371379 AM CPU\u00a0\u00a0\u00a0 SERVER\u00a0\u00a0\u00a0 10.2.0.2.0\u00a0\u00a0 5689957 CPUJan2007<\/p>\n
\ncreate directories and files like %ORACLE_HOME%\\cpu\\CPUOct2005\\patch<component>.log or $ORACLE_HOME\/cpu\/CPUOct2005\/install<timestamp>.log<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"