{"id":151,"date":"2012-06-18T14:28:57","date_gmt":"2012-06-18T14:28:57","guid":{"rendered":"http:\/\/oraerp.com\/blog\/?p=151"},"modified":"2013-12-28T03:57:58","modified_gmt":"2013-12-28T09:57:58","slug":"e-business-suite-r12-2-no-more-downtime","status":"publish","type":"post","link":"http:\/\/oraerp.com\/blog\/e-business-suite-r12-2-no-more-downtime\/","title":{"rendered":"E-business Suite R12.2 \u2013 No More Downtime"},"content":{"rendered":"<p style=\"text-align: justify;\">The takeout from last <a href=\"https:\/\/blogs.oracle.com\/stevenChan\/entry\/atg_live_webcast_june_14\">ATG Live Webcast June 14<\/a> was \u2018no more downtime\u2019 in Oracle EBS R12.2 for patching and transformation of term \u2018Downtime\u2019 to \u2018Cut Over\u2019. In R12.2 downtime will be measured in minutes not hours or days. It is a customary thought process to wait for suitable time when to apply new patch, how to get approval for business applications downtime and usually you will get a slot on weekend nights.<\/p>\n<p style=\"text-align: justify;\">Let\u2019s review how we will be going to get possibility of \u2018no more downtime\u2019 in R12.2. \u00a0we all know EBS downtime is a major concern and this outages interfere with core business activity:<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Reluctance to upgrade to take advantage of new feature<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Barrier to staying current with recommended patches<\/p>\n<p style=\"text-align: justify;\">Now let\u2019s understand commonly what force us to go for production down time; 1-Major Release upgrades, 2-Maintenance Rollups (RUPs), 3-Critical Patch Updates (CPUs). 4-Legislative and Regulatory updates<\/p>\n<p style=\"text-align: justify;\">EBS will remain online during patching through Online Patching; <a href=\"http:\/\/oraerp.com\/blog\/a-journey-from-oracle-e-business-suite-r12-1-to-r12-2\/\" target=\"_blank\">refer earlier post<\/a> to get basic idea.\u00a0In 12.2 all patching operations are online so its mean &#8211; EBS will remain available to users during patching operations, &#8211; HR Legislative updates can be applied during a payroll run &amp; Users can enter expense reports while Payables is being patched<\/p>\n<p style=\"text-align: justify;\">Online patching will use the latest features of Oracle\u2019s Integrated Stack like &#8211; Edition Based Redefinition (EBR) &amp; &#8211; Web Logic Server<\/p>\n<p><strong>Patches will be applied to a Copy of Production<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/Patches.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-154\" title=\"Patches\" alt=\"\" src=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/Patches.png?resize=300%2C140\" width=\"300\" height=\"140\" srcset=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/Patches.png?resize=300%2C140 300w, https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/Patches.png?resize=1024%2C478 1024w, https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/Patches.png?w=1411 1411w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>EBS will use both the file system and the database to store the code and data that make up the application &#8211; <strong>Copy the Code, NOT the Data<\/strong><\/p>\n<p>\u2013 \u00a0 \u00a0 \u00a0Where is Code<\/p>\n<ul>\n<li>Stored both on the File system &amp; In the Database<\/li>\n<li>Any code object changed in a patch is copied<\/li>\n<\/ul>\n<p>\u2013 \u00a0 \u00a0 \u00a0Where is Data<\/p>\n<ul>\n<li>Stored both on the File system &amp; In the Database<\/li>\n<li>Application data is NOT copied by a patch<\/li>\n<\/ul>\n<p><strong>\u201cDowntime\u201d will be redefined as \u201cCutover\u201d. <\/strong>Cutover is the time taken to switch users from the production system to the newly patched copy.<\/p>\n<p>-Cutover changes the unit of measure for downtime &amp; will be measured in minutes <strong>NOT<\/strong> hours or days.<\/p>\n<p>-Cutover time is very predictable &amp; the time taken to bounce the Middle Tiers<\/p>\n<p><strong>Downtime Limited to Short Cutover<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/shortcutover.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-156\" title=\"shortcutover\" alt=\"\" src=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/shortcutover.png?resize=300%2C148\" width=\"300\" height=\"148\" srcset=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/shortcutover.png?resize=300%2C148 300w, https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/shortcutover.png?resize=1024%2C506 1024w, https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/shortcutover.png?w=1358 1358w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>Patching Occurs on a Copy of following:<\/strong><\/p>\n<p><strong><\/strong>File system: a-All patches are applied to the secondary file system b-Synchronization of the file systems is managed by the patching tools<\/p>\n<p>Database: A separate copy is maintained of all database code objects that are changed by a patch<\/p>\n<p><strong>Downtime Patches<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>No <\/strong>online Users<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Wall clock time <strong>very important<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Consumes <strong>all<\/strong> <strong>resources<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Upgrade designed to run as <strong>fast as possible<\/strong><\/p>\n<p><strong>Online Patches<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Users remain <strong>online <\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Wall clock time is <strong>no longer an overriding concern <\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Online Users <strong>share resources<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Data upgrades designed to <strong>not affect <\/strong>the running application<\/p>\n<p>In 12.1.3 Single File System &#8211; Patches applied while system is down &amp; another method is Optional staged APPL_TOP<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Patches applied to staged file system while the system is online<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 System is off line to apply database updates<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Staged APPL_TOP provided the basis for the 12.2 design<\/p>\n<p>You can refer My Oracle Support note for further details (Using a Staged Applications System (APPL_TOP) to Reduce Patching Downtime in Oracle E-Business Suite Release 12 [ID 734025.1])<\/p>\n<p><strong>EBS 12.2 will be installed with 3 file systems<a href=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/threefile.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-158\" title=\"threefile\" alt=\"\" src=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/threefile.png?resize=300%2C227\" width=\"300\" height=\"227\" srcset=\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/threefile.png?resize=300%2C227 300w, https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2012\/06\/threefile.png?w=811 811w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 FS-1 (Production file system)\u00a0 &#8211; Used by the current users of the system<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 FS-2 (Copy of Production file system) &#8211; Used by the patching tools<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 FS-NE (Non Editioned file system) &#8211; Stores data that is stored on the file system (Data import and export files, Report output &amp; Log files)<\/p>\n<p>All three file systems serve a single database. The file system in use by the running application is never patched. All patches are applied to secondary file system<\/p>\n<p><strong>Edition-Based Redefinition (EBR)<\/strong> <strong>11g R2<\/strong><\/p>\n<p><strong><\/strong>What it will do?<\/p>\n<p>Enables the online upgrade of the database tier and allows an application to efficiently store multiple copies of its application definition in the same database. It will also provide an isolation mechanism that allows pre-upgrade and post-upgrade schemas to co-exist.<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Changes to database objects are made in the isolation of an \u201c<strong>Edition<\/strong>\u201d<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Changes to database objects do not effect the running Application<\/p>\n<p>You can also <a href=\"http:\/\/oraerp.com\/blog\/a-journey-from-oracle-e-business-suite-r12-1-to-r12-2\/\" target=\"_blank\">refer earlier post<\/a> to get more info about Edition Based Redefinition.<\/p>\n<p>What is Database Editions?<\/p>\n<p>Our code chooses <strong>The Edition<\/strong> that it connects to, if it will connect to <strong>Run Edition <\/strong>(1-Used by Online Users, 2-Never changed by a Patch). Patch Edition (1-Used by the Patching Tools 2-Changes do no affect the running Application)<\/p>\n<p>Online Patching will Interacts with 3 different Edition Types<\/p>\n<p><strong>Run<\/strong> <strong>Edition<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 The edition currently in use by the running application<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 This is always the default database edition<\/p>\n<p><strong>Patch<\/strong> <strong>Edition<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 The edition currently in use by the patching tools<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 This edition is only present when patching is in progress<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 Always the direct child of the Run Edition.<\/p>\n<p><strong>Old<\/strong> <strong>Edition(s)<\/strong><\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 There maybe zero or more Old Editions<\/p>\n<p>\u2013\u00a0\u00a0\u00a0\u00a0\u00a0 When the Patch Edition is promoted to production the previous Run Edition is now regarded as an Old Edition<\/p>\n<p>\u2013 \u00a0 \u00a0\u00a0\u00a0Only retained until a full cleanup operation is run<\/p>\n<p>Other posts on Oracle E-business suite R12.2:<\/p>\n<p><a title=\"Permanent Link to A Journey from Oracle E-Business Suite R12.1 to R12.2\" href=\"http:\/\/oraerp.com\/blog\/a-journey-from-oracle-e-business-suite-r12-1-to-r12-2\/\">A Journey from Oracle E-Business Suite R12.1 to R12.2<\/a><\/p>\n<div id=\"fb-root\"><\/div><script src=\"http:\/\/connect.facebook.net\/en_US\/all.js#xfbml=1\"><\/script><fb:like href=\"http:\/\/oraerp.com\/blog\/e-business-suite-r12-2-no-more-downtime\/\" send=\"true\" layout=\"standard\" width=\"450\" show_faces=\"true\" font=\"arial\" action=\"like\" colorscheme=\"light\"><\/fb:like>","protected":false},"excerpt":{"rendered":"<p>The takeout from last ATG Live Webcast June 14 was \u2018no more downtime\u2019 in Oracle EBS R12.2 for patching and transformation of term \u2018Downtime\u2019 to \u2018Cut Over\u2019. In R12.2 downtime will be measured in minutes not hours or days. It is a customary thought process to wait for suitable time when to apply new patch, [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[15],"tags":[],"class_list":["post-151","post","type-post","status-publish","format-standard","hentry","category-r12-2"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1Rb79-2r","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":12,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":404,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/posts\/151\/revisions\/404"}],"wp:attachment":[{"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oraerp.com\/blog\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}