{"id":211,"date":"2013-10-07T11:11:52","date_gmt":"2013-10-07T16:11:52","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=211"},"modified":"2026-02-07T15:03:36","modified_gmt":"2026-02-07T21:03:36","slug":"mos-docs-to-review-for-ebs-db-upgrade-to-11gr2-latest-patch-release","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2013\/211\/","title":{"rendered":"MOS Docs to Review for EBS DB Upgrade to 11gR2 (Latest Patch Release)"},"content":{"rendered":"<p>If you are considering Oracle database upgrade from 9i\/10g to 11gR2 or applying release patches (11.2.0.1 to 11.2.0.3 or 11.2.0.4), several issues can be avoided by applying the recommended patches and PSU. \u00a0And if you are not on the latest 11gR2 release (11.2.0.3 or 11.2.0.4), I strongly recommend getting there, with the latest PSU possible\u2026 The following are must-review reference documents for upgrading Oracle database to 11gR2, that supports EBS 11i or R12.1.<\/p>\n<ul>\n<li>Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)<\/li>\n<li>Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) (Doc ID 881505.1)<\/li>\n<li>Oracle Recommended Patches &#8212; Oracle Database (Doc ID 756671.1)<\/li>\n<li>Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Doc ID 1147107.1)<\/li>\n<li>Oracle E-Business Suite Recommended Performance Patches (Doc ID 244040.1)<\/li>\n<\/ul>\n<p>Make sure the initialization parameters are setup correctly. You may unset the AQ_TM_PROCESS parameter (alter system reset aq_tm_processes scope=spfile sid=&#8217;*&#8217;;).<\/p>\n<ul>\n<li>Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)<\/li>\n<li>Database Initialization Parameters for Oracle Applications Release 11i (Doc ID 216205.1)<\/li>\n<li>bde_chk_cbo.sql &#8211; EBS initialization parameters &#8211; Healthcheck (Doc ID 174605.1)<\/li>\n<\/ul>\n<p>Running this script before and after upgrade provides a good comparison.<\/p>\n<ul>\n<li>Script to Collect DB Upgrade\/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)<\/li>\n<\/ul>\n<p>It is better to truncate the SYS.AUD$ table with large amount or rows, when upgrading from 10g to 11g. Also, remember to purge recycle bin before upgrade.<\/p>\n<ul>\n<li>How to Pre-Process SYS.AUD$ Records Pre-Upgrade From 10.1 or later to 11gR1 or later. (Doc ID 1329590.1)<\/li>\n<\/ul>\n<p>After upgrade, you might want to proactively take care of these as well\u2026<\/p>\n<ul>\n<li>11i &#8211; 12 Gather Schema Statistics fails with Ora-20001 errors after 11G database Upgrade (Doc ID 781813.1)<\/li>\n<li>EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(&#8216;APPLSYS&#8217;,&#8217;FND_STATTAB&#8217;);<\/li>\n<\/ul>\n<p>Apply the EBS patch to utilize the new 11gR2 statistics gathering features in EBS jobs<\/p>\n<ul>\n<li>Best Practices for Gathering Statistics with Oracle E-Business Suite (Doc ID 1586374.1)<\/li>\n<\/ul>\n<p>Good luck with the database upgrade (or patch release apply)!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are considering Oracle database upgrade from 9i\/10g to 11gR2 or applying release patches (11.2.0.1 to 11.2.0.3 or 11.2.0.4), several issues can be avoided by applying the recommended patches and PSU. \u00a0And if you are not on the latest 11gR2 release (11.2.0.3 or 11.2.0.4), I strongly recommend getting there, with the latest PSU possible\u2026 &#8230; <a title=\"MOS Docs to Review for EBS DB Upgrade to 11gR2 (Latest Patch Release)\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2013\/211\/\" aria-label=\"Read more about MOS Docs to Review for EBS DB Upgrade to 11gR2 (Latest Patch Release)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[133],"tags":[135],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-database-upgrade"],"acf":[],"jetpack-related-posts":[{"id":2049,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2049\/","url_meta":{"origin":211,"position":0},"title":"Oracle Database 12c (12.2.0.1.0) on VirtualBox","author":"Biju","date":"March 31, 2017","format":false,"excerpt":"A new pre-built VirtualBox image is available for download\u00a0 from OTN (updated on March 27, 2017). Once you download, import and configure the VM, you can pretty much do whatever you want. But Roy and Mike have put together a very good lab environment and exercise for you to practice\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2792,"url":"https:\/\/bijoos.com\/oraclenotes\/2023\/2792\/","url_meta":{"origin":211,"position":1},"title":"Oracle Database 19c &#8211; The best Oracle database release to be on now!","author":"biju.thomas","date":"August 12, 2023","format":false,"excerpt":"Recently Oracle announced that the extended support fee for the Oracle database 19c will be waived for the first two years. Good news! Oracle Database 19c will waive the first and second years of Extended Support (EXS, ES) fees.Premier Support (PS) ends on April 30, 2024, and waived Extended Support\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":218,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/218\/","url_meta":{"origin":211,"position":2},"title":"OPatch Options!","author":"Biju","date":"October 24, 2013","format":false,"excerpt":"A friend of mine was working to apply the July 2013 PSU, and had to rollback two one off patch conflicts. Since the instance was cloned from production, OPatch was failing with this error... $ $ORACLE_HOME\/OPatch\/opatch rollback -id 12834800 The patch should be applied\/rolled back in '-all_nodes' mode only. Converting\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1467,"url":"https:\/\/bijoos.com\/oraclenotes\/2014\/1467\/","url_meta":{"origin":211,"position":3},"title":"Oracle Tidbits &#8211; November 2014","author":"Biju","date":"November 30, 2014","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on all weekdays\u00a0in November\u00a02014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2115,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2115\/","url_meta":{"origin":211,"position":4},"title":"Oracle Tidbits &#8211; October 2017 #oratidbit","author":"Biju","date":"November 2, 2017","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in October 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1601,"url":"https:\/\/bijoos.com\/oraclenotes\/2015\/1601\/","url_meta":{"origin":211,"position":5},"title":"Bundle Patch or PSU on Windows","author":"Biju","date":"September 21, 2015","format":false,"excerpt":"Well, honestly, have forgotten working\u00a0on Windows platform administering Oracle databases. Recently, installed Oracle Database 12c on Windows and wanted to apply the latest PSU. Could not find the PSU, but found the BP (Bundled Patch) - hoped it the same and included more than a PSU! Had some challenges installing...\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":2964,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/211\/revisions\/2964"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}