{"id":38,"date":"2006-08-31T13:39:00","date_gmt":"2006-08-31T17:39:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=38"},"modified":"2006-08-31T13:39:00","modified_gmt":"2006-08-31T17:39:00","slug":"upgrade-oracle-apps-11i-with-database-to-10g-r2","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/","title":{"rendered":"Upgrade Oracle Apps 11i with Database to 10g R2"},"content":{"rendered":"<p><a href=\"http:\/\/ads.adgenta.com\/ads\/ads.dll\/click?client=atul_iiit&#038;GUID=09%2F01%2F06+19%3A43%3A00\" target=\"_blank\"><\/a>This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you have not seen previous update on overview of DB upgrade for Apps 11i you can <a href=\"http:\/\/becomeappsdba.blogspot.com\/2006\/08\/oracle-apps-11i-with-database-10g-r2.html\">Click Here<\/a><\/p>\n<p>Upgrading a Oracle Apps 11i Database is Upgrading Usual 10g Database + some additional steps which are specific to Oracle Applications 11i. So if you have already done a database Upgrade you simply need to follow metalink note # 362203.1 <\/p>\n<p><\/p>\n<p><strong>Database upgrade is Two Step process:<\/strong> First Upgrade your software i.e. your files under Database $ORACLE_HOME to provide new executables .<br \/><strong>How to upgrade software<\/strong> from <strong>8i, 9i or 10.1 to 10.2<\/strong> just go to directory where you have downloaded 10.1.2.0.2 database &amp; go to Disk1 &#038; execute .\/runInstaller . This will start Universal Installer &amp; then you have to choose different Oracle_Home to install 10.2 software . (Check oracle database upgrade guide at <a href=\"http:\/\/download-uk.oracle.com\/docs\/cd\/B19306_01\/server.102\/b14238\/preup.htm#i1007718\"><span style=\"font-size:85%;\">http:\/\/download-uk.oracle.com\/docs\/cd\/B19306_01\/server.102\/b14238\/preup.htm#i1007718<\/span><\/a> ) After software Installation you have to install software for companion CD in above ORACLE_HOME i.e. one for 10.2 only.<br \/><strong>Why I need to Install companion CD separately, I never did it earlier ?<\/strong> Oracle recently started shipping Ultra Search as part of companion CD which earlier used to come with database software only <strong>Apply 10.2.0.2 patch 4547817 on top of 10.1.2.0.1<\/strong> base release. For instructions on How to apply patcheset 10.2.0.2 check ReadMe of patch &#038; you again have to apply it via OUI <strong>Upgrade database Metadata<\/strong> Once software is upgraded you have to upgrade Metadata and option you have is via executing sql&#8217;s mentioned in upgrade guide or dbua ( database upgarde assistance tool ). Oracle Universal Installer while upgrading software also prompt you to upgrade database while upgrade software. Depending on your comfort you can choose method to upgrade database. I prefer using manual method i.e. via upgrade sql files. Now apart from upgrading database there are some pre upgrade &amp; post upgrade steps specific to oracle applications 11i &#038; follow them as mentioned in metalink note # 362203.1 some are option &amp; some are compulsory . I want to discuss Native Compilation in Oracle 10 g database but because of time constraints I will discuss it some other time.<\/p>\n<p><\/p>\n<p>From now onwards slowly I will move on Advanced Apps DBA tasks like <\/p>\n<p><\/p>\n<p><strong>Adding extra Node in Applications 11i<\/strong><br \/><strong>Implementing SSL with Apps 11i webserver<\/strong><br \/><strong>Disaster Recovery Implementation<\/strong><br \/><strong>Configuring 10g Application Server with E-Business Suite 11i<\/strong><br \/>Don&#8217;t forget to leave comments and if you have any doubts in Apps 11i mail me at <a href=\"mailto:atul_iiit@yahoo.com\">atul_iiit@yahoo.com<\/a> or post here as comment. <\/p>\n<p><\/p>\n<p>Atul Kumar<br \/>Oracle Apps DBA<\/p>\n<div class=\"blogger-post-footer\">http:\/\/teachMeOracle.com\/forum<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you [&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":[1],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrade Oracle Apps 11i with Database to 10g R2 -<\/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\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/\" \/>\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 with Database to 10g R2 -\" \/>\n<meta property=\"og:description\" content=\"This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-08-31T17:39:00+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\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/\",\"name\":\"Upgrade Oracle Apps 11i with Database to 10g R2 -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-08-31T17:39:00+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Oracle Apps 11i with Database to 10g R2\"}]},{\"@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":"Upgrade Oracle Apps 11i with Database to 10g R2 -","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\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade Oracle Apps 11i with Database to 10g R2 -","og_description":"This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/","article_published_time":"2006-08-31T17:39:00+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\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/","name":"Upgrade Oracle Apps 11i with Database to 10g R2 -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-08-31T17:39:00+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/08\/31\/upgrade-oracle-apps-11i-with-database-to-10g-r2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade Oracle Apps 11i with Database to 10g R2"}]},{"@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\/38","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=38"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}