{"id":55,"date":"2006-09-26T12:08:00","date_gmt":"2006-09-26T16:08:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=55"},"modified":"2007-10-16T11:37:34","modified_gmt":"2007-10-16T15:37:34","slug":"reducing-patch-timing-contd","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/","title":{"rendered":"Reducing Patch Timing Contd&#8230;"},"content":{"rendered":"<p>Yesterday we looked at how to use default file so that you can reduce repetative questions asked in adpatch session each time its initiated like APPL_TOP, ORACLE_HOME confirmation. Lets check what else you can do to reduce patch time ( All these tricks &amp; tips to reduce patch time is useful if you are applying lots of patches may be five or more )<\/p>\n<p>With lot of patches adpatch compile database objects &amp; compile JSP&#8217;s in end so if you are applying 10 patches &amp; out of those six patches execute compile database in end so adpatch will compile database six time which is waste of resource in terms of time. If you instruct adpatch not to compile of JSP &amp; Database objects &amp; do it in last manually this will reduce lot of your patch timing . So lets see how to do it .<\/p>\n<p>If you are not clear with patch basics here are my previous posts<br \/>\n<a href=\"http:\/\/becomeappsdba.blogspot.com\/2006\/08\/oracle-apps-patch-basics.html\">Apps Patch Basics<\/a><br \/>\n<a href=\"http:\/\/becomeappsdba.blogspot.com\/2006\/08\/oracle-apps-patch-basics-ii.html\">Apps Patch Basics Part II<\/a><br \/>\n<a href=\"http:\/\/becomeappsdba.blogspot.com\/2006\/08\/how-to-apply-apps-patch-using-adpatch.html\">How to Apply Apps Patch using ADPATCH<\/a><\/p>\n<p>Yesterday I told that you can use defaults file like<\/p>\n<p><strong>adpatch defaultsfile=$APPL_TOP\/admin\/$SID\/defaults.txt logfile=654321.log patchtop=\/patches\/654321 driver=u654321.drv interactive=no<\/strong><\/p>\n<p>so if you don&#8217;t want adpatch to compile database &amp; jsp with each execution of adpatch you can use options nocompiledb &amp; nocompilejsp<\/p>\n<p>adpatch defaultsfile=$APPL_TOP\/admin\/$SID\/defaults.txt <strong>options=nocompilejsp,nocompiledb<\/strong> logfile=654321.log patchtop=\/patches\/654321 driver=u654321.drv interactive=no<\/p>\n<p>Once your patching is complete and you have applied all patches you can compile jsp &amp; database once.<\/p>\n<p><strong>How to compile database objetcs ?<\/strong><br \/>\nUse adadmin compile database option else<br \/>\nUse utlrp.sql script on database tier at $ORACLE_HOME\/rdbms\/admin<\/p>\n<p><strong>How to compile JSP in Apps ?<\/strong><br \/>\nUse perl script <strong>ojspCompile.pl<\/strong> under $JTF_TOP\/admin\/scripts like<br \/>\nperl ojspCompile.pl &#8211;compile<\/p>\n<p><span style=\"font-size: 130%\"><strong>Merge Patches to reduce patch timing<\/strong><br \/>\n<\/span>Another option to reduce patch timing is to use ad tool <strong>admrgpch<\/strong>, so lets say you have 10 patches to apply you can merge 10 patches &amp; create single patch and apply that single patch. (<span style=\"font-size: 85%\"> Sometime applying patches after merging may fail because of conflict in driver file so check first on test server<\/span>)<\/p>\n<p>create a directory lets say <strong>source_directory<\/strong> &amp; put all patches which you want to merge in that &amp; create another directory where your final single patch will come lets say <strong>destination_directory <\/strong>then use<\/p>\n<p><strong>admrgpch source_directory destination_directory <\/strong><br \/>\nIf there is any error in merging patch by default it will be in directory from where you are initiating admrgpch by name <strong>admrgpch.log<\/strong><br \/>\nApply patch from target directory via normal adpatch way.<\/p>\n<p>If you are Upgrading your apps instance lets say from 11.5.8 or 11.5.9 to 11.5.10 you can use <strong>stagged APPL_TOP<\/strong> (d<span style=\"font-size: 85%\">different from shared APPL_TOP<\/span>)<br \/>\n<strong><span style=\"color: #cc0000\">More on stagged APPL_TOP coming in near future &#8230;.<\/span><\/strong><\/p>\n<p class=\"blogger-post-footer\">http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday we looked at how to use default file so that you can reduce repetative questions asked in adpatch session [&hellip;]<\/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":[33],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-patching"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reducing Patch Timing Contd&#8230; -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reducing Patch Timing Contd&#8230; -\" \/>\n<meta property=\"og:description\" content=\"Yesterday we looked at how to use default file so that you can reduce repetative questions asked in adpatch session [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-09-26T16:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-10-16T15:37:34+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/\",\"name\":\"Reducing Patch Timing Contd&#8230; -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-09-26T16:08:00+00:00\",\"dateModified\":\"2007-10-16T15:37:34+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reducing Patch Timing Contd&#8230;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reducing Patch Timing Contd&#8230; -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/","og_locale":"en_US","og_type":"article","og_title":"Reducing Patch Timing Contd&#8230; -","og_description":"Yesterday we looked at how to use default file so that you can reduce repetative questions asked in adpatch session [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/","article_published_time":"2006-09-26T16:08:00+00:00","article_modified_time":"2007-10-16T15:37:34+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/","name":"Reducing Patch Timing Contd&#8230; -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-09-26T16:08:00+00:00","dateModified":"2007-10-16T15:37:34+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/26\/reducing-patch-timing-contd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Reducing Patch Timing Contd&#8230;"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}