{"id":565,"date":"2008-07-09T14:31:49","date_gmt":"2008-07-09T18:31:49","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/"},"modified":"2008-07-09T14:31:49","modified_gmt":"2008-07-09T18:31:49","slug":"upgrade-oracle-apps-11i-to-r1212i-1204-key-points","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/","title":{"rendered":"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) – Key Points"},"content":{"rendered":"

This post covers overview\/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12\/12i (12.0.4).
\n\u00a0\u00a0 This post is useful to understand upgrade from Apps DBA point of\u00a0view<\/strong> and\u00a0does NOT<\/strong> cover any functional steps in upgrade process.<\/p>\n

For step by step Oracle R12\/12i upgrade process follow R12 Upgrade Guide here <\/a>\u00a0\u00a0and R12 Installation Guide Here<\/a><\/p>\n

If you want to know what is changed in R12 (like technical difference between 11i & R12 Click Here<\/a> or new TOP INST_TOP click here<\/a>\u00a0)<\/p>\n

If you are already on R12 (12.0.0, 12.0.1, 12.0.2 or 12.0.3) and wish to upgrade to 12.0.4\u00a0 Check Steps Here<\/a>\u00a0<\/p>\n

Key points with regard to upgrade<\/u><\/strong><\/p>\n

– You can upgrade to R12\/12i (12.0.4)\u00a0ONLY<\/strong> from release 11.5.8, 11.5.9.X or 11.5.10.X (For any previous release like 11.5.7 , upgrade them to 11.5.10.2 first)<\/p>\n

– You can upgrade database to version 10.2.X during upgrade (11.5.8, 11.5.9.X, 11.5.10.X) or BEFORE<\/strong> R12 upgrade (only for 11.5.9.X and 11.5.10.X)<\/p>\n

.
\nUpgrade is broadly divided in to three steps<\/strong>
\n—<\/strong>Preupgrade Step (lay down file system for R12 using rapidwiz\/RapidInstall)
\n—<\/strong>Upgrade Step (Upgrade database to 10gR2 (if not already upgraded), apply R12.AD.A on R12 APPL_TOP and apply 12.0.4 patch database portion only)
\n—<\/strong>Post Upgrade step (Run rapidwiz\/RapidInstall one more time to configure and start services on R12)<\/p>\n

.<\/p>\n

A. Pre-Upgrade Process<\/font><\/u><\/strong>
\n1.<\/strong>Layout file system for R12 using rapidwiz with option as upgrade.<\/p>\n

Run rapidwiz from R12 software >> Select option “Upgrade to Oracle Applications Release 12<\/strong>”\u00a0 (Check Figure)<\/p>\n

\"R12<\/a><\/p>\n

In Select Upgrade Action screen select “Create Upgrade File System<\/strong>” (Check Figure)
\n\"Upgrade<\/a><\/p>\n

Follow further screens and installer will install R12 file system (This step\u00a0will NOT configure and start services in R12, It will only install R12 files<\/font>)<\/p>\n

Note* There are other preupgrade steps as well like migrate backup, TUMS (optional), OATM, convert to multi org, gather stats and functional preupgrade steps (Detailed step by step upgrade doc coming soon …)<\/p>\n

B. Upgrade Process<\/font><\/u><\/strong>
\n2.<\/strong>Migrate database to 10gR2 – This step is required if you have not upgraded your database with 11i itself. Use ORACLE_HOME (10.2 on database tier) which came as part of R12 upgrade (Create Upgrade file system above in preupgrade step)<\/p>\n

\u00a0Also check following Metalink Notes<\/p>\n

403339.1 – <\/strong>Oracle 10g R2 Database preperation Guidelines for Oracle E-Business Suite R12 Upgrade
\n396009.1 –<\/strong> Database initialization parameters for Oracle apps R12<\/p>\n

3.<\/strong> Put your Apps into database in to maintenance mode<\/strong>
\n4.<\/strong>Run adpatch 6604842 <\/strong>(on R12 appl_top, environment variable at this stage should point to R12 APPL_TOP and ORACLE_HOME in application tier should point to FORMS (10.1.2) in R12<\/font>)\u00a0to upgrade AD product of R12 to 12.0.4 (Patch 6604842\u00a0is available as R12.AD.A)<\/p>\n

5.<\/strong> Run 12.0.4 patch 6394500<\/strong>(u6394500.drv ) which is under $AU_TOP\/patch\/115\/driver (on R12\/12.0.4 APPL_TOP). Note* You have to apply this patch on 12.0.4\u00a0 APPL_TOP<\/font>.<\/p>\n

Apply this with nocopyportion<\/strong> and nogenerateportion<\/strong>as copy and generate portion is already available as part of R12 install done above in preupgarde step.<\/font><\/p>\n

Apply\/Upgrade to 12.0.4 using<\/p>\n

adpatch options=nocopyportion,nogenerateportion<\/strong><\/p>\n

6.<\/strong>\u00a0 Disable maintenance mode<\/p>\n

C. Post Upgrade Process<\/u><\/strong>
\nDatabase and database listener should be up at this stage.<\/p>\n

7.<\/strong> Run Rapid Install one more time (with different option check figure<\/strong>) to configure and start services on R12\/12i.<\/p>\n

Run rapidwiz one more time
\nSelect option “Upgrade to Oracle Applications Release 12<\/strong>”\u00a0 (Check Figure)<\/p>\n

\"R12<\/a><\/p>\n

In Select Upgrade Action screen select “Configure Upgraded Release 12 Instance<\/strong>” (This select is different from selection in Pre-Upgrade Step<\/font>)<\/p>\n

\"R12<\/a><\/p>\n

\u00a0 Change file name as shown in figure to your new $APPL_TOP\/admin\/$CONTEXT_NAME.xml (R12)<\/p>\n

There are other finishing tasks which are out of scope of this post like backup, reset password, setup client machines (java plugin), printers, workflow notification mailer and various functional steps<\/p>\n

Related\u00a0 Docs<\/u><\/strong><\/p>\n

399362.1<\/strong> E-Business Suite Release 12 Upgrade Sizing and Best Practices
\n396009.1<\/strong> Database Initialization Parameter for Oracle Applications R12<\/p>\n

Stay tuned for more on Oracle Apps R12\/12i upgrade from release 11i<\/font><\/strong>
\n\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

This post covers overview\/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12\/12i (12.0.4). \u00a0\u00a0 This post […]<\/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":[35,43],"tags":[],"class_list":["post-565","post","type-post","status-publish","format-standard","hentry","category-r12","category-upgrade"],"yoast_head":"\nUpgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -<\/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\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -\" \/>\n<meta property=\"og:description\" content=\"This post covers overview\/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12\/12i (12.0.4). \u00a0\u00a0 This post […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-07-09T18:31:49+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/\",\"name\":\"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG\",\"datePublished\":\"2008-07-09T18:31:49+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) – Key Points\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & 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":"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -","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\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -","og_description":"This post covers overview\/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12\/12i (12.0.4). \u00a0\u00a0 This post […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/","article_published_time":"2008-07-09T18:31:49+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/","name":"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) - Key Points -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG","datePublished":"2008-07-09T18:31:49+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/upgrade_r12_1.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/09\/upgrade-oracle-apps-11i-to-r1212i-1204-key-points\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade Oracle Apps 11i to R12\/12i (12.0.4) – Key Points"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & 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\/565","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=565"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/565\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}