{"id":54,"date":"2006-09-25T09:50:00","date_gmt":"2006-09-25T13:50:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=54"},"modified":"2007-10-16T11:38:37","modified_gmt":"2007-10-16T15:38:37","slug":"reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/","title":{"rendered":"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch"},"content":{"rendered":"<p>At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was huge bunch of patches (I know everybody has to apply lot of patches initially) and we were applying patches individually one by one. Our team lead came &amp; asked us how come you are still applying patches speed up &amp; finish it early (You can&#8217;t afford this much downtime for patching) . One of my colleague replied look we are not doing anything its Server (Unix Machine) which is applying patches &amp; we can&#8217;t do much . My TL said give attention <strong>what adpatch is doing &amp; try to remove redundant steps<\/strong> which are repeated with each patch.<\/p>\n<p>that&#8217;s where we really started looking at we realized that<br \/>\nIn each patch adpatch is<br \/>\n1. Asking basic questions like , Default APPL_TOP, Log file name, ORACLE_HOME, apps password, system password<br \/>\n2. Compiling database at end of some patches<br \/>\n3. Compiling JSP at end of most of patches<br \/>\n4. Running maintain MRC Multiple reporting Currency in installation where MRC was configured.<br \/>\n5. It was by default taking number of workers as twice the CPU + 1<br \/>\n6. There was some thing called <strong>batchsize<\/strong><\/p>\n<p>Then I looked at metalink to find if there is anyway I can reduce repeated tasks and came across defaults file which I am going to discuss in subsequent pages.<br \/>\nOther thing I came across is merging patched via admrgpch I&#8217;ll discuss about this after defaults file may be tomorrow<br \/>\nYou can also play with batchsize &amp; number of workers to reduce patch timing<\/p>\n<p><strong>Using Defaults file with adpatch (Non Interactive)<\/strong><br \/>\n<strong>How to create defaults file ?<\/strong><br \/>\nadpatch defaultsfile=$APPL_TOP\/admin\/$SID\/defaults.txt ( You can keep this txt file in any location of your choice)<br \/>\nNow abort autopatch section at point where it asks for patch directory by ctrl +c or ctrl+d<br \/>\nNow check if this file exists<br \/>\nYou have to do above steps only once in an environment to create defaults file.<\/p>\n<p><strong>How to apply patches in future ?<\/strong><br \/>\nNow any future patches you apply non interactive using defaults file like<br \/>\nadpatch defaultsfile=$APPL_TOP\/admin\/$SID\/defaults.txt logfile=654321.log patchtop=\/patches\/654321 driver=u654321.drv interactive=no<\/p>\n<p>You will see that it will apply patch by itself using defaults file , adpatch will pick APP_TOP, ORACLE_HOME information, system password and apps password from defaults file.<\/p>\n<p>This will save lot of time &amp; you can reduce your patch timing usign defaults file .<\/p>\n<p><strong><span style=\"color: #cc0000\">More on how to reduce patch time in coming posts &#8230;<\/span><\/strong><\/p>\n<p class=\"blogger-post-footer\">http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was [&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-54","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>Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -<\/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\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -\" \/>\n<meta property=\"og:description\" content=\"At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-09-25T13:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-10-16T15:38:37+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\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/\",\"name\":\"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-09-25T13:50:00+00:00\",\"dateModified\":\"2007-10-16T15:38:37+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch\"}]},{\"@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":"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -","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\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/","og_locale":"en_US","og_type":"article","og_title":"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -","og_description":"At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/","article_published_time":"2006-09-25T13:50:00+00:00","article_modified_time":"2007-10-16T15:38:37+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\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/","name":"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-09-25T13:50:00+00:00","dateModified":"2007-10-16T15:38:37+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/25\/reduce-patch-timing-in-apps-defaults-file-nocompilejsp-nocompiledb-merge-patch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch"}]},{"@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\/54","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=54"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}