https://blogs.oracle.com/ebstech/oracle-database-193-now-certified-with-ebs-122
[Contributing Author: Nirzari Raichura]
[04-Nov-2019 Update: Corrected minimum requirements for RHEL as reflected in certification information in MOS and per MOS Note 2605726.1]
We are pleased to announce that Oracle Database 19.3 is now certified with Oracle E-Business Suite Release 12.2 on-premises. As an Oracle E-Business Suite 12.2 on-premises customer, you may now start planning your upgrade to Oracle Database 19c.
Database support implications may also be reviewed in this database patching and support article. The latest support information for Oracle E-Business Suite Release 12.2 and Release 12.1 with Database 12.1.0.2 or Database 11.2.0.4 may be reviewed in this extended support article.
What's New for EBS with Oracle Database 19c
There are several mandatory architecture updates when you upgrade your Oracle E-Business Suite 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). The steps required to perform the conversion to the CDB architecture are provided in the following document:
- Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (MOS Note 2552181.1)
It is important for you to pay particular attention to the following points:
- A CDB with one PDB (single tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c.
- A CDB with multiple PDBs (multitenant) is not currently certified for Oracle E-Business Suite.
- A non-CDB architecture is not planned to be certified or supported for EBS with Database 19c.
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. For more information, refer to the following document:
- Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (MOS Note 2525754.1)
What is Included in this Announcement?
1. Certified Platforms
The Certified Platforms list includes items that have been explicitly certified by EBS development.
Linux x86-64
- Oracle Linux 7.4 Update 4 (7.4) or later
- Red Hat Enterprise Linux 7.5 Update 5 (7.5) or later
- SUSE Linux Enterprise Server 12 SP3 or later
Oracle Solaris (SPARC systems, 64-bit)
- Oracle Solaris 11.4 or later
- Oracle Solaris 11.3 or later
2. Supported Database Features and Options
The Supported Database Features and Options list includes items that are supported but not explicitly certified by EBS. Our general policy is that the Oracle Database generic documentation applies to these features and options, even if we haven't certified them specifically.
- Advanced Compression
- Database In-Memory
- Database Partitioning
- Native PL/SQL Compilation
- Oracle Application Express (APEX)
- SecureFiles
- Virtual Private Database (VPD)*
*Note: When deploying VPD there are special considerations with Oracle E-Business Suite 12.2 and edition-based redefinition.
3. Certified Database Features and Options
The Certified Database Features and Options list includes items that have been explicitly certified by EBS development.
- Container Database (CDB) Architecture (multitenant architecture) with a single Pluggable Database (PDB) (single tenant)
- Export/Import
- Oracle Real Application Clusters (Oracle RAC)
- Transparent Data Encryption (TDE) with Online Tablespace Encryption Conversion
4. Certified Integrations
The Certified Integrations list includes items that have been explicitly certified by EBS development.
- Oracle E-Business Suite 12.2 with Database 19c Integrated with Oracle Access Manager for Single Sign-on
What Remains to be Certified?
This section includes all items that are pending certification. You may subscribe to this blog for the latest in certification announcements.
1. Pending Certifications - Deployments
The Pending Certifications - Deployments list includes items that require explicit certification and that we currently plan to certify in the future.
- Oracle E-Business Suite Integrated SOA Gateway (ISG) is not currently certified with E-Business Suite Release 12.2 on Database 19c. If you are using or planning to use ISG, you should not perform an upgrade to Database 19c until the certification of Oracle E-Business Suite 12.2 with Database 19c for ISG is announced.
- Oracle Application Management Pack for Oracle E-Business Suite, Release 13.1.1.1.0 with Oracle Enterprise Manager 13c Release 3
2. Pending Certifications - Platforms
The Pending Certifications - Platforms list includes items that require explicit certification and that we currently plan to certify in the future.
- IBM AIX on Power Systems
- HP-UX Itanium
- IBM: Linux on System z
- Microsoft Windows x64 (64-bit)
3. Pending Certifications - Database Features and Options
The Pending Certifications - Database Features and Options list includes items that require explicit certification and that we currently plan to certify in the future.
- Active Data Guard
- Data Guard
- Data Masking
- Database Vault
- Oracle Label Security (OLS)
- Transportable Database and Transportable Tablespaces for data migration processes
4. Pending Certifications - Integrations
The Pending Certifications - Integrations list includes items that require explicit certification and that we currently plan to certify in the future.
- EBS 12.2 with Database 19c Integrated with GoldenGate
- Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (MOS Note 2552181.1)
- Database Initialization Parameter Settings for Oracle E-Business Suite Release 12 (MOS Note 396009.1)
- Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (MOS Note 2525754.1)
- Using Oracle Database 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (MOS Note 2530665.1)
- Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c (MOS Note 2554156.1)
- Using Fast Online Conversion to Enable Transparent Data Encryption (TDE) for Oracle E-Business Suite (MOS Note 2559570.1)