{"id":2792,"date":"2023-08-12T12:30:07","date_gmt":"2023-08-12T17:30:07","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2792"},"modified":"2026-02-07T15:03:33","modified_gmt":"2026-02-07T21:03:33","slug":"oracle-database-19c-the-best-oracle-database-release-to-be-on-now","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2023\/2792\/","title":{"rendered":"Oracle Database 19c &#8211; The best Oracle database release to be on now!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Recently Oracle announced that the extended support fee for the Oracle database 19c will be waived for the first two years. <\/p>\n\n\n\n<blockquote class=\"twitter-tweet\"><p lang=\"en\" dir=\"ltr\">Good news! Oracle Database 19c will waive the first and second years of Extended Support (EXS, ES) fees.<br>Premier Support (PS) ends on April 30, 2024, and waived Extended Support (ES) fees will be in effect from May 1, 2024, until April 30, 2026. <a href=\"https:\/\/t.co\/baLOX7XyrF\">pic.twitter.com\/baLOX7XyrF<\/a><\/p>&mdash; Biju Thomas (@biju_thomas) <a href=\"https:\/\/twitter.com\/biju_thomas\/status\/1690136126277971968?ref_src=twsrc%5Etfw\">August 11, 2023<\/a><\/blockquote> <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script>\n\n\n\n<p class=\"wp-block-paragraph\">I wanted to take a moment to document the best MOS notes that help customers to upgrade their older version of Oracle databases to the 19c long-term version. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11.2.0.4 and 19c are similar releases before a major architecture change (<em>PDB architecture was introduced in 12.1 and traditional architecture deprecated. In 23c traditional architecture is unsupported<\/em>). You can see in the chart above that 11.2.0.4 had four years of waived extended support, 2 years of extended support, 2 years of market-driven support, and now has upgrade support from CSS (<em>Customer Success Services, which used to be known as ACS<\/em>). I think it is only prudent for customers to jump on 19c and stay there for a while &#8211; 19c is a good database release to be on. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>19c Database Upgrade &#8211; Self-Guided Assistance with Best Practices (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/SearchDocDisplay?_adf.ctrl-state=145qgkpd0f_187&amp;_afrLoop=558017738601264\">Doc ID 1919.2<\/a>)<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is the best MOS note for upgrade planning and learning about the 19c upgrade. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"416\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image.png?resize=1024%2C416&#038;ssl=1\" alt=\"\" class=\"wp-image-2793\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image.png?resize=1024%2C416&amp;ssl=1 1024w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image.png?resize=300%2C122&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image.png?resize=768%2C312&amp;ssl=1 768w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image.png?w=1454&amp;ssl=1 1454w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Oracle Database Patches to Consider for 19c (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=558378235827991&amp;id=2781612.2&amp;_adf.ctrl-state=145qgkpd0f_624\">Doc ID 2781612.2)<\/a><\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-2.png?resize=1024%2C462&#038;ssl=1\" alt=\"\" class=\"wp-image-2795\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-2.png?resize=1024%2C462&amp;ssl=1 1024w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-2.png?resize=300%2C135&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-2.png?resize=768%2C346&amp;ssl=1 768w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-2.png?w=1198&amp;ssl=1 1198w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Primary Note for Database Proactive Patch Program (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=558540548827420&amp;id=888.1&amp;_afrWindowMode=0&amp;_adf.ctrl-state=145qgkpd0f_807\">Doc ID 888.1<\/a>)<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"358\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-3.png?resize=723%2C358&#038;ssl=1\" alt=\"\" class=\"wp-image-2796\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-3.png?w=723&amp;ssl=1 723w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-3.png?resize=300%2C149&amp;ssl=1 300w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Oracle Database 19c Important Recommended One-off Patches (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=559055155486056&amp;id=555.1&amp;_adf.ctrl-state=145qgkpd0f_856\">Doc ID 555.1<\/a>)<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The RU and MRPs will include only the patches that are standby-first and RAC-rolling enabled. There are many critical patches that may need to go on your databases. This note is an absolute must for all DBAs to review and apply. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"956\" height=\"196\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-4.png?resize=956%2C196&#038;ssl=1\" alt=\"\" class=\"wp-image-2797\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-4.png?w=956&amp;ssl=1 956w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-4.png?resize=300%2C62&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-4.png?resize=768%2C157&amp;ssl=1 768w\" sizes=\"auto, (max-width: 956px) 100vw, 956px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And finally, check out the new features in Oracle Database 19c using the interactive &amp; easy to search APEX tool &#8211; <a href=\"https:\/\/apex.oracle.com\/database-features\/\">Oracle Database Features and Licensing.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">None of upgrade learning and planning is complete without reading and watching <a href=\"https:\/\/mikedietrichde.com\/\">Mike Dietrich&#8217;s Blog <\/a>About Oracle Database Upgrades. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Upgrade to Oracle 19c\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/videoseries?list=PLIUJ4jBaPQxwuyZy1T5UHA1ayAgCBGyEK\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle Database 19c <a href=\"https:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/architecture-diagrams\/19\/database-technical-architecture.html\">Technical Architecture<\/a><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"902\" height=\"463\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-5.png?resize=902%2C463&#038;ssl=1\" alt=\"\" class=\"wp-image-2798\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-5.png?w=902&amp;ssl=1 902w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-5.png?resize=300%2C154&amp;ssl=1 300w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-5.png?resize=768%2C394&amp;ssl=1 768w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle Real Application Clusters 19c<a href=\"https:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/architecture-diagrams\/19\/rac\/main.html\"> Technical Architecture<\/a><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"460\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?resize=597%2C460&#038;ssl=1\" alt=\"\" class=\"wp-image-2799\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?w=597&amp;ssl=1 597w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2023\/08\/image-6.png?resize=300%2C231&amp;ssl=1 300w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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 (ES) fees will be in &#8230; <a title=\"Oracle Database 19c &#8211; The best Oracle database release to be on now!\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2023\/2792\/\" aria-label=\"Read more about Oracle Database 19c &#8211; The best Oracle database release to be on now!\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","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,98],"class_list":["post-2792","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-database-upgrade","tag-oracle-19c"],"acf":[],"jetpack-related-posts":[{"id":2441,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2441\/","url_meta":{"origin":2792,"position":0},"title":"Oracle Tidbits: June 2019 #OraTidbit","author":"biju.thomas","date":"June 30, 2019","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter, during weekdays in June 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit Oracle Data Pump in #db19c has a new transform parameter OMIT_ENCRYPTION_CLAUSE that causes Data Pump to suppress any encryption\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":2558,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2558\/","url_meta":{"origin":2792,"position":1},"title":"Oracle Tidbits &#8211; March 2020 #OraTidbit","author":"biju.thomas","date":"March 31, 2020","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in March 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c.#OraTidbit #db20c Traditional auditing\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":2900,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/2900\/","url_meta":{"origin":2792,"position":2},"title":"Upgrading Oracle Autonomous AI Database with Cross-Region Data Guard from 19c to 26ai","author":"biju.thomas","date":"February 5, 2026","format":false,"excerpt":"I hear the Autonomous Database upgrade from 19c to 26ai is as easy as a click of a button. Let's see what is involved and how long it takes. As part of ongoing platform modernization efforts, upgrading to the latest long-term support release is essential. I initiated the upgrade of\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\/2026\/02\/ChatGPT-Image-Feb-5-2026-06_47_33-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-5-2026-06_47_33-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-5-2026-06_47_33-PM.png?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-5-2026-06_47_33-PM.png?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-5-2026-06_47_33-PM.png?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2534,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2534\/","url_meta":{"origin":2792,"position":3},"title":"Oracle Tidbits &#8211; December 2019 #OraTidbit","author":"biju.thomas","date":"December 31, 2019","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit DBA_AUTO_STAT_EXECUTIONS view in #db19c displays information about automatic\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":2595,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2595\/","url_meta":{"origin":2792,"position":4},"title":"Oracle TidBits &#8211; July 2020 #OraTidBit","author":"biju.thomas","date":"July 31, 2020","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during weekdays in July 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All\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":2431,"url":"https:\/\/bijoos.com\/oraclenotes\/2019\/2431\/","url_meta":{"origin":2792,"position":5},"title":"Oracle Tidbits: May 2019 #oratidbit","author":"biju.thomas","date":"May 31, 2019","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter, during weekdays in May 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #orcldb Starting with Oracle Grid Infrastructure 19c, the installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade\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":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2792","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2792"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2792\/revisions"}],"predecessor-version":[{"id":2800,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2792\/revisions\/2800"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}