Oracle Database 19c was certified with Oracle EBS R12.2 back in September 2019 which is the long-term release for the 12.2 product family of Oracle databases. With the Oracle Database 19c certification, Oracle EBS 12.2 On-Premises databases are now certified with the CDB architecture (multitenant architecture).
The topics covered in this blog are,
- Background
- EBS R12.2 Architecture Overview
- Overview of Oracle Database 19c
- What’s New For EBS With Oracle Database 19c
- R12.x Support For Database 19c
- Why Upgrade To Database 19c?
- High-Level Upgrade Steps
- FAQs
Background ^
With the launch of database 12c in 2013, Oracle introduced a new architectural concept, called “Multitenant Databases”, where you have one super database (=container; CDB) and one or more sub-databases (= pluggable; PDB).
Note: Read our blog to know more about Multi-Tenant Architecture.
EBS (R12.2) Architecture Overview ^
This Architecture mainly consists of:
- Application Tier
- Database Tier
- Client Tier
Overview Of Oracle Database 19c ^
Oracle Database 19c, is the long-term support release of the Oracle Database 12c and 18c family of products, offering customers Premier and Extended Support through to May 1, 2024, and April 30, 2027, respectively. It is available on Linux, Windows, Solaris, HP/UX and AIX platforms as well as the Oracle Cloud. To know more, check MOS Note 742060.1
Oracle Database 19c offers customers the best performance, scalability, reliability, and security for all their operational and analytical workloads.
Also Read : How To Install Oracle E-Business Suite R12.2.
What’s New For EBS With Oracle Database 19c ^
There are several mandatory architecture updates when you upgrade your Oracle EBS database to Oracle Database 19c. The following is a summary of the key required architectural changes:
- Container Database (CDB) Architecture: With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). As part of the upgrade to Database 19c, you will convert your EBS database to the CDB architecture with a single pluggable database (PDB).
- PL/SQL File Input/Output Directories: With Database 19c, the UTL_FILE_DIR database initialization parameter has been desupported. As part of the upgrade to Database 19c, you must migrate all UTL_FILE_DIR database initialization parameters to database directory objects. EBS development has created a utility to migrate and manage your defined PL/SQL file input/output directories.
- ADG DML Redirection: Previously, you could only update the Global Temp Tables on Active Data Guard standby database. From Oracle 19c, you can also update regular tables.
ADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard.
Also check: ADOP ( R12.2 Online Patching ) in Oracle EBS database (R12) FAQ
R12.x Support For Database 19c ^
- Oracle EBS Database 19c (19.3) has been recently supported for E-business R12.1.3 and R12.2.3 +
- Only Multitenant Architecture is supported
- Only One PDB in a CDB is supported for E-business
- De-Support of UTL_FILE_DIR initialization parameter
- Pluggable Database support
- Oracle Linux 7.5 & above
Why Upgrade To Database 19c? ^
- Oracle Database 11.2.0.4/12.1.0.2 Extended Support Waived Only Till Dec 2020 (To know more about Extended Support Fee Waived for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite, click here)
- All Customers Should Upgrade Their Database By Then To Avoid Extra Cost
- At The Moment Only EBS R12.1.3 & R12.2.3+ Is Supported
- Support For R12.0 And 11i Is Expected On A Later Date
Also read: Everything you need to know about Workflow Notification Mailer
High-Level Upgrade Steps ^
- Configure DB Home for EBS
- If R12.2.x, ensure that no ADOP cycle is active, Upgrade Database to 19c
- Prepare for PDB Conversion & Convert to PDB
- Execute Post PDB Conversion script txkPostPDBCreationTasks.pl
- MOS Doc Id. 396009.1 Modify Database Initialization parameters following
- Run autoconfig on the Application tier
- Rewrite customizations depending on UTL_FILE_DIR
- Rewrite customizations if impacted due to CDB/PDB model
- Start Application services and carry out complete Health Check
I hope you find this blog useful in understanding the 19c Database upgrade process in Oracle EBS database R12 if you have any doubts regarding the 19c database upgrade post in the comment section.
FAQs ^
Q1. Why database upgrade is required?
A. The reason for the upgrade is to ensure that new RDM features, such as a new tab or new connection logs, are properly added to your database. Moreover, if the new version of Remote Desktop Manager modifies your database, then an upgrade is required.
Q2. Is Oracle 12.2 0.2 the same as 18c?
A. Oracle Database 18c is the equivalent of 12.2. 0.2 patchset, so it is part of the 12.2 release cycle.
Q3. What can I expect from Oracle Database 19c?
A. New Features. Oracle Database 19c builds upon the innovations of previous releases like Multitenant, In-Memory, JSON support, Sharding, and many other features that enable Oracle’s Autonomous Database Cloud Services.
Q4. What is G and C in Oracle?
A. g or c for Oracle database stands to reflect the features provided by the version. ‘G‘ stands for Grid which supports grid computing environment. ‘C‘ stands for Cloud which is designed to support a cloud environment.
References MOS
- MOS Doc Id. 1594274.1 Install Oracle Database binaries 19c and apply EBS overlay patches as per
- MOS Doc Id. 2552181.1 Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle EBS Database 19c
- MOS (Doc ID 396009.1) Database Initialization Parameters for Oracle E-Business Suite Release 12
- (MOS Note 2530665.1) Using Oracle Database 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2
- (MOS Note 2554156.1) Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19
- (MOS Note 742060.1) Release Schedule of Current Database Releases.
Related/Further Readings
- [Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet
- Oracle E-Business Suite (Oracle EBS database) 12.2.9 Now Available & Its Upgrade Steps
- Oracle AppsDBA (R12.2) Training: Step by Step Activity Guides/Hands-On Lab Exercise
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
- For Oracle E-Business Suite Release 12.2.9 Readme (Doc ID 2495027.1).
- Oracle E-Business Suite 12.2.10 Now Available
- Oracle E-Business Suite Release 12.2.10 Readme (MOS Note 2666934.1)
Next Task For You
We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.
navyanavvi says
very useful blog
Rahul Dangayach says
Hi Navyanavvi,
Glad you liked our post. Stay Tuned for further more informative blogs
Thanks and Regards
Rahul
Team K21
Shakti Singh says
Hi Varsha,
Very informative.. Would you please let me know if Goldengate replication can be setup with EBS 12.2 and DB 19C ? I have a EBS 12.2 running with 12.1.2 DB and 12C golden gate. I want to upgrade the DB to 19C but I couldn’t find if GG replication can work with EBS 12.2+19C DB. Thanks in advance.
Rahul Dangayach says
Hi Shakti,
Glad you liked it!
Please check below the oracle link:
https://blogs.oracle.com/ebstech/goldengate-12c-certified-with-e-business-suite-122
But, it is not yet certified for database 19c
https://blogs.oracle.com/ebstech/oracle-database-193-now-certified-with-ebs-122
Regards
Rahul
Team K21
Guenther Stuerner says
Is there anywhere a list of db-options which are included in the restricted Oracle databaselicense for EBS ?
Best regards
Günther
Varsha Sharma says
Hi Gunther,
You can check for any kind of update related to EBS & Database on Oracle Suppport.
Please refer to the Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1) for more information on this.
Regards
Varsha
(Team K21)
Guenther Stuerner says
Thank you Varsha!
Try to get it.
besr regards
Guenther
Bhavin says
Hello,
Is Oracle DB 19c(19.7) supported with EBS 12.2.8?
Rahul Dangayach says
Hi Bhavin,
Yes, DB 19.7 is very much supported with EBS R12.2.8.
Regards
Rahul
Team K21
Bhavin says
Thank you Rahul for your prompt response. Very much appreciated! I am trying to find some oracle document with this information which I can share with my team. Will you be kind enough to share that with me?
Haitham says
Hi,
Should we upgrade database from 12c to 19c before applying RUP on top of R12.2.4 or after? Any references?
Rahul Dangayach says
Hi Haitham,
You can go both ways….but recommended is to first upgrade to R12.2.4 and apply RUP and then upgrade to 19c.
Please check the below doc id for reference:
Oracle iProcurement Consolidated Update Patch 22575334:R12.ICX.D for Release R12.2.4+ (Doc ID 2183357.1)
Regards
Rahul
Team K21
Edwin says
Hi Varsha,
For the listner do you bring it up with the CDB Environment file or the PDB Environment file?
Varsha Sharma says
Hi Edwin,
We bring the listner up in the PDB environment after updating it to new orale home (19c).
Regards
Varsha
(Team K21)
Lokchandar E says
Hi Team,
Planning for a 12.2.9 EBS installation with 19c DB. First installing EBS 12.2.0 with 12.1.0.2 DB and upgrade the DB to 19c then apply the 12.2.9 patch. Will this work?? Kindly advice.
Regards,
Lokchandar
Varsha Sharma says
Hi Lokchandar,
Yes, it will work if you first upgrade to db 19c and then upgrade your EBS to R12.2.9.
Regards
Varsha
(Team K21)
Lokchandar says
Thanks Varsha for the quick response.
Regards,
Lokchandar
Siddhartha Sudhir Kulshrestha says
Really useful blog. Might help in our product
Rahul Dangayach says
Hi Siddhartha,
Glad you liked our post. Stay Tuned for further more informative blogs.
Thanks and Regards
Rahul Dangayach
Team K21 Academy
Abdulkarim says
Can I migrate 11g EBS database to 19c non CDB ,EBS application version 12.2.4
Varsha Sharma Sharma says
Hi Abdularim,
Yes, you can upgrade the DB 11.2.0.4 to 19c directly.
Please check below the certification matrix for the same:
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/oracle-database-releases-that-support-direct-upgrade.html#GUID-7AA90913-D8AB-4EBA-944F-31FA01D6BE5D
Thanks and Regards
Varsha
Team K21 Academy
Laine says
Hi!
We are thinking to upgrade 12.2.6/12c to 12.2.9 with 19c
BUT
there is 1,5 year till 19c will be in extended support and again would need to be upgraded..
When 20c will be certified with 12.2.X, do you know ?
Thx!
Rahul Dangayach says
Hi Laine,
Regarding the 20c there is no update from Oracle, about its release, the only way to get it once they officially announce.
Hope this helps
Thanks and Regards
Rahul Dangayach
Team K21 Academy
Omar Imana says
Please let me get clear on this detail. The editioning capability was introduced in 18c or 19c? Which EBS version was mapped to it (R12.2.#) ?
Anne says
Planning to upgrade the database for existing R12.1.3 from 11.2.0.4 to 19c first. Go live. Then update R12.1.3 to R12.2.11 . We can do that – correct ?
Rahul Dangayach says
Hi Anne,
Regarding this please check our blog on the same:
https://k21academy.com/ebscloud44
Hope this helps
Thanks and Regards
Rahul Dangayach
Team K21 Academy
Bash says
Hi
Is it worth to use Oracle VM for EBS database? We are now with physical box and would like to move with OEL VM with DB RAC. The performance will be degraded? Any advise here?
Rahul Dangayach says
Hi Bash,
Assuming that you are moving to OCI VMDB Rac, actually, the performance will be much better than on Prem physical servers.
Hope this helps.
Thanks and Regards
Rahul Dangayach
Team K21Academy