{"id":7556,"date":"2020-03-27T12:04:45","date_gmt":"2020-03-27T12:04:45","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/upgrade-oracle-ebs-12-2-database-to-oracle-database-19c\/"},"modified":"2026-11-03T19:28:44","modified_gmt":"2026-11-03T19:28:44","slug":"upgrade-oracle-ebs-12-2-database-to-oracle-database-19c","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/upgrade-oracle-ebs-12-2-database-to-oracle-database-19c\/","title":{"rendered":"Upgrade Oracle EBS 12.2 database to Oracle Database 19c"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>This post explores the steps to configure Oracle\u00ae E-Business Suite (EBS)&nbsp;12.2 with Oracle Database 19c.<\/p>\n<p>Oracle recently certified Oracle Database 19c with EBS 12.2. When you upgrade an&nbsp;Oracle EBS database from version 12c (12.1.0.2) or 11.2.0.4 to Database 19c, the&nbsp;database architecture changes to a container database (CDB) architecture. If you&nbsp;upgrade the EBS database from previous versions to 19, the upgrade process must<br \/>\nconvert the EBS database to CDB architecture with a single pluggable database&nbsp;(PDB).<\/p>\n<p><strong>Database 19c multitenant architecture<\/strong><\/p>\n<p>The Database 19c multitenant architecture enables an Oracle database to function<br \/>\nas a multitenant CDB. You should be familiar with the following terms:<\/p>\n<ul>\n<li><strong>CDB<\/strong>: Includes zero, one, or many customer-created PDBs.<\/li>\n<li><strong>PDB<\/strong>: A portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a non-CDB.<\/li>\n<li><strong>Container<\/strong>: A logical collection of data or metadata within the multitenant architecture.<\/li>\n<\/ul>\n<p>\nThe following figure shows possible containers in a CDB and demonstrates that a CDB can support multiple PDBs in Database 19c:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26433-body-Picture1_2.png\" alt=\"oracle 12 to 19 pic 1\" \/><\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/cncpt\/img\/admin112.png](https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/cncpt\/img\/admin112.png\"><em>Image Source<\/em><\/a>&nbsp;<\/p>\n<p>However, Oracle EBS currently supports only a single PDB in a CDB and does not certify a CDB with multiple PDBs.<\/p>\n<p><strong>Upgrade an EBS database to Database 19c<\/strong><\/p>\n<p>\n<strong>Refer to the following notes to upgrade an EBS database to 19c:<\/strong><\/p>\n<ul>\n<li><strong>Interoperability Notes<\/strong>: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)<\/li>\n<li><strong>Oracle 19c<\/strong>: Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c (Doc ID 2539778.1)<\/li>\n<\/ul>\n<p><strong>&nbsp;Before the database installation<\/strong><\/p>\n<p>\n1. Verify the current software component versions before upgrading the database to 19c. Make sure your current database release supports a direct upgrade. You must apply all missing patches to EBS.<\/p>\n<p>2. Run <strong>txkOnPremPrePDBCreationTasks.pl<\/strong>&nbsp;in the source <strong>Oracle Home&nbsp;<\/strong>directory to generate files that you need after the database upgrade to&nbsp;initialize CDB parameters.<\/p>\n<p><strong>Database installation<\/strong><\/p>\n<p>1. Download Oracle Database 19c(19.3) media from <a href=\"\/\/www.oracle.com\/database\/technologies\/oracle19c-linux-downloads.html\">here<\/a>&nbsp;and install the 19c database software. Choose the <strong>Set Up Software Only&nbsp;<\/strong>option.<\/p>\n<p>2. Apply additional 19c Relational Database Management System (RDBMS) patches to 19c <strong>Oracle Home<\/strong>.<\/p>\n<p>3. Create a CDB using the Database Configuration Assistant (DBCA). Create an empty container database (CDB) without a PDB.<\/p>\n<p>4. Run <strong>txkGenCDBTnsAdmin.pl<\/strong>&nbsp;in 19c the <strong>Oracle Home<\/strong>&nbsp;directory to generate the required Transparent Network Substrate (TNS) files. Do not create or start a listener.<\/p>\n<p><strong>Database upgrade<\/strong><\/p>\n<p>Versions after Oracle Database 18c do not support the `UTL_FILE_DIR` database&nbsp;initialization parameter. Instead, the later versions use database directory&nbsp;objects to specify the locations used for PL\/SQL file I\/O. A directory object&nbsp;specifies an alias for a directory on the server file system. Starting with&nbsp;Oracle Database 19c, Oracle EBS introduced new `<em>apps.v$parameter<\/em>` and&nbsp;apps.<em>v$parameter2<\/em>` views in the APPS schema. These views provide a supplemental&nbsp;<em>UTL_FILE_DIR<\/em>&nbsp;parameter, which you can reference in the same way that you reference the former <em>UTL_FILE_DIR<\/em>&nbsp;database initialization parameter. As part&nbsp;of the upgrade, you need to migrate your previous `<em>UTL_FILE_DIR<\/em>` database&nbsp;initialization parameter settings to the new parameter.<\/p>\n<p>1. Run&nbsp;<strong>txkCfgUtlfileDir.pl<\/strong>&nbsp;in <em>getUtlFileDir<\/em>&nbsp;mode to retrieve the&nbsp;directory path values from the source <em>UTL_FILE_DIR<\/em> database initialization parameter.<\/p>\n<p>2. Later, run <strong>txkCfgUtlfileDir.pl<\/strong>&nbsp;in<em> `setUtlFileDir`<\/em> mode to store the&nbsp;directory-path values in the database.<\/p>\n<p>3. Upgrade the source database to 19c by following Chapter 2 of the&nbsp;<strong>Oracle Database Upgrade Guide 19c using Database Upgrade Assistant (DBUA)<\/strong>. To perform the upgrade manually, follow <strong>Metalink Note 2539778.1 &#8211; Oracle 19c &#8211; Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c<\/strong>.<\/p>\n<p><strong>After the database upgrade<\/strong><\/p>\n<p>1. Run <em>adgrants<\/em>.<\/p>\n<p>2. Compile invalid objects.<\/p>\n<p><strong>Convert the database to multitenant architecture<\/strong><\/p>\n<p>At this point, there are two databases associated with the 19c Oracle home:<\/p>\n<ul>\n<li>The CDB database<\/li>\n<li>The non-CDB database<\/li>\n<\/ul>\n<p>The EBS database is the non-CDB database that the upgrade migrates to the PDB and plugs into the CDB.<\/p>\n<p>1. Update the initialization parameters for the CDB, or the freshly installed 19c database, to accommodate the EBS database as a PDB.<\/p>\n<p>2. Check for any PDB violations before plugging in the EBS database as PDB to CDB.<\/p>\n<p>3. Run <strong>txkCreatePDB.pl<\/strong>&nbsp;and <strong>txkPostPDBCreationTasks.pl<\/strong>&nbsp;to convert the EBS database to a PDB and plug the PDB into the CDB. You can make the PDB data file location the same as the source data file location.<\/p>\n<p>4. Ensure that you update all common and release-specific database initialization parameters for Oracle 19c by following the <strong>My Oracle Support Knowledge&nbsp;Document 396009.1, Database Initialization Parameter Settings for Oracle E-Business Suite Release 12<\/strong>&nbsp;documentation.<\/p>\n<p><strong>Application-tier steps<\/strong><\/p>\n<p>1. Run <em>`autoconfig`<\/em> on the application tier.<\/p>\n<p>2. Review the links present in the database before the start of the upgrade and<br \/>\n&nbsp; &nbsp;create corresponding database links in the upgraded database.<\/p>\n<p>3. Start the application services and perform a sanity test.<\/p>\n<p><strong>&nbsp;Unsupported EBS products<\/strong><\/p>\n<p>Because EBS Release 12.2 on Oracle Database 19c does not support the following&nbsp;EBS products at this time, EBS Release 12.2 customers who plan to upgrade the&nbsp;database to Oracle Database 19c might need to check for alternative products or&nbsp;functionality:<\/p>\n<ul>\n<li>Oracle Enterprise Data Warehouse (EDW)<\/li>\n<li>Oracle Enterprise Planning and Budgeting (EPB)<\/li>\n<li>Demand Signal Repository (DDR)<\/li>\n<li>Oracle E-Business Suite Integrated SOA Gateway (ISG)<\/li>\n<\/ul>\n<p><strong>&nbsp;Conclusion<\/strong><\/p>\n<p>This blog post provides an overview of multitenant architecture with container&nbsp;and pluggable databases. By using the outlined steps, database administrators&nbsp;can configure Oracle EBS 12.2 with the Oracle Database 19c. The upgrade process&nbsp;converts your EBS database to CDB architecture with a single pluggable database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Upgrade Oracle EBS 12.2 database to Oracle Database 19c<\/p>\n","protected":false},"author":2,"featured_media":7558,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26433","content_type":"blog","created_by":"10130","authored_on":"2024-01-01T13:04:45+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Upgrade Oracle EBS 12.2 database to Oracle Database 19c. Adapt to the new container database architecture.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26433-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle, Oracle E-Business Suite","product":"","publisheddate":"2020-03-27T12:04:45","rxt_solutions":"Enterprise Resource Planning (ERP), Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Upgrade Oracle EBS 12.2 database to Oracle Database 19c | Rackspace Technology","field_topics":"","field_slug":"upgrade-oracle-ebs-12-2-database-to-oracle-database-19c","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7556","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7556"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7556\/revisions"}],"predecessor-version":[{"id":9531,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7556\/revisions\/9531"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7558"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}