Oracle EBS R12.2 certification with Oracle Database 23ai on Database Cloud Services for Commercial Cloud

 Dear All,

In this post i am going to share the below information.

Oracle E-Business Suite Release 12.2 (EBS 12.2) certification with Oracle Database 23ai 

on Database Cloud Services for Commercial Cloud.

>>>   Oracle E-Business Suite (EBS) Release 12.2 is now certified with Oracle Database 23ai for on-premises Exadata Database Machine , Oracle Exadata Software version 24.1 (ExaOL8X) or later.

Ø  As an EBS 12.2 on-premises Exadata customer, once your system meets all of the necessary prerequisites you may upgrade to Oracle Database 23ai, specifically Release Update 23.5.

Oracle recently Announced that Oracle E-Business Suite (EBS) Release 12.2 is now certified for Commercial Cloud with Oracle Database 23ai (DB 23ai) on the following database cloud services:

     Ø  Oracle Base Database Service

     Ø  Oracle Exadata Database Service on Dedicated Infrastructure 

     Ø    Oracle Exadata Database Service on Cloud@Customer

As an EBS 12.2 customer running on one of these database cloud services in a commercial cloud region, once your system meets all of the necessary prerequisites you may upgrade to Oracle Database 23ai, specifically Release Update 23.5.

EBS 12.2.14 Certifications :

Note : check the certification information from the below link.  https://support.oracle.com/epmos/faces/CertifyHome

                                  

Ø  The latest long term release of Oracle Database is currently DB 23ai. The previous long term release of Oracle Database was Oracle Database 19c.

What's the Latest Information Regarding Support for EBS Databases?

     Most EBS customers have by now completed upgrades to Oracle Database 19c (DB 19c). If you are still running an older Oracle Database release, you should make plans to upgrade to DB 19c as soon as possible.

ØThose who are using older than 19C you have to upgrade your databases to 19C.

or perform an export/import from 12cR1/11gR2.

Ø DB 19c is the only database release with a direct upgrade path to DB 23ai and Oracle provides you Error Correction Support.

Notes : Oracle E-Business Suite Release 12.2 End of Error Correction Support for Oracle Database 12c Release 12.1.0.2 and 11g Release 11.2.0.4 (MOS Note 3051860.1), 

Release Schedule of Current Database Releases (MOS Note 742060.1)

What Can You Do Now to Get Your EBS Environment Ready for Oracle Database 23ai? 

Ø Upgrade to Oracle Database 19C : 

 Prior to upgrading to oracle 23ai your database should be 19C. bcz there no direct upgrades for lower than 19C. ( export and imports will support for 12cr1/11gr2***) 

Ø Be on the EBS Error Correction baseline or later : 

 The Error correction support baseline is EBS 12.2.7 for DB 23ai, all EBS Products you are running must be at the 12.2.7 or higher. (MOS Note 1195034.1)

Ø Perform the EBS System Schema Migration :  

      The EBS System Migration delivers enhancements that remove dependencies on database features that are desupported with oracle database 23ai.

     Performing the EBS System Schema Migration which includes applying the EBS System Schema Migration Completion Patch is a prerequisite for upgrading your EBS database to DB 23ai. 

MOS Note 2755875.1 , MOS Note 2758999.1

Ø Prepare your EBS Database: 

         In order to upgrade to DB 23ai, all EBS products you are running must be at the 12.2.7 release level or later. One step you can take now to get your EBS 12.2 environment ready for the upcoming certification with DB 23ai is to be on the EBS Error Correction Baseline or later. Our recommendation is that you update to the latest EBS 12.2 RUP which is currently 12.2.14.

i) Enabled Unified Auditing : Traditional auditing is desupported with Database 23ai, unified Auditing is enabled by default, for more details see MOS Note – 2777404.1

ii) Converts Case insensitive PDB Name : Case sensitive PDB names are desupported with EBS and Database 23ai for more details See MOS Note – 2782130.1

Additional Prerequisites for EBS R12.2 Database 23ai :

Ø Update to a future database upgrade code level for AD and TXK : AD and TXK are being enhanced with new features and for compatibility with Oracle Database 23ai.

Ø Apply the Interoperability Patche for EBS Product Compatibility with Oracle Database 23ai.

What's New for EBS with Oracle Database 23ai?

Ø Upgrading from DB 19c to DB 23ai is achieved using the Oracle Database AutoUpgrade utility.

Ø With the certification of Oracle Database 23ai, a new utility called Oracle E-Business Suite Database Parameter Checker (EDBPC) is now available. EDPBC can be run to confirm that you have correctly set your EBS DB 23ai or 19c database initialization parameters according to recommendations in Database Initialization Parameters for Oracle E-Business Suite Release 12 (MOS Note 396009.1). etc 

Note: The Database Upgrade Assistant (DBUA) used to upgrade EBS databases to Database 11gR2, 12cR1, and 19c is now desupported.

 Certified Platforms - On-Premises Exadata Database Machine (Exadata)

        This announcement applies to the certification of EBS 12.2 with DB 23ai for the on-premises Exadata Database Machine (Exadata) running Exadata Software version 24.1 (ExaOL8X) or later. All other on-premises platforms are pending certification.

Certified Database Features and Options::

This list includes items that have been explicitly certified by EBS development.

Ø Active Data Guard , Data Guard Using Logical Host Names

Ø Data Guard Using Physical Server Names 

Ø Data Masking using the EM 13cR5 Data Masking and Subsetting Pack and the EBS 12.2 Data Masking Template

Ø Database Network Access Control Lists 

Ø Database Vault using EBS_SYSTEM

Ø In Place Standby Upgrade

Ø Multitenant architecture (CDB architecture) with a single Pluggable Database (PDB) (single tenant)

Ø Oracle Real Application Clusters (Oracle RAC)

Ø Transparent Data Encryption (TDE) with Online Tablespace Encryption Conversion

Ø Unified Auditing

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 Label Security (OLS)

Ø SecureFile , Virtual Private Database (VPD)*

Note: There are special considerations for EBS 12.2 and the required edition-based redefinition database feature. For VPD, refer to Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Note 1577661.1).

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.

Ø Database Vault using EBS_SYSTEM

Ø Transportable Database for data migration processes

Ø Transportable Tablespaces for data migration processes

Certified Integrations ::

      The Certified Integrations list includes items that have been explicitly certified by EBS Development. 

Ø Oracle APEX

Ø Oracle Application Management Pack Release 13.5.1.0.0

Ø Oracle E-Business Suite Integrated SOA Gateway (ISG)

Ø Oracle E-Business Suite 12.2 with Database 23ai integrated with Oracle Access Manager 12c for single sign-on

Pending Certifications – Integrations:

       This list includes items that require explicit certification and that we currently plan to certify in the future.

Ø Oracle E-Business Suite Release 12.2 with Database 23ai integrated with GoldenGate 23ai on-premises for reporting

Note: If you are using GoldenGate to replicate your EBS database, you must upgrade to GoldenGate 23ai using the microservices architecture as part of your upgrade to DB 23ai.

Upgrading from Oracle Database 19c to 23ai on a Database Service - Reference methods 

     How you upgrade will depend on the cloud service you use to run your database as well as whether you have implemented Oracle Data Guard.

     To upgrade your EBS database on Oracle Base Database Service, follow the instructions in the appropriate My Oracle Support (MOS) document:

 Environments Without Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai on Oracle Base Database Service DB Systems (MOS Note 2999993.1).

Environments With Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai Using Existing Physical Standby on Oracle Base Database Service DB Systems (MOS Note 3020011.1)

To upgrade your EBS database on Oracle Exadata Database Service on Dedicated Infrastructure or Cloud@Customer, 

Environments without Data Guard ::

Ø Upgrading Oracle Database 19c to 23ai for Oracle E-Business Suite Release 12.2 with Oracle Exadata Database Service on Dedicated Infrastructure and Cloud@Customer (MOS Note 2999994.1).

Environments with Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai Using Existing Physical Standby on Oracle Exadata Database Service on Dedicated Infrastructure or Cloud@Customer (MOS Note 3020010.1)

Thanks,

Srini