Collection of EBS upgrade information for Oracle Database 19c

This was the question I received the most often during the Virtual Classroom webinars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.

Recap – EBS and Oracle 19c

In September 2019, right before Oracle Open World, we announced the certification of EBS with Oracle 19c:

The big challenge for you here clearly was and is the requirement to migrate your EBS database into a PDB when you upgrade to Oracle 19c. You can have still non-CDBs with Oracle 19c – but not with your EBS database. It will become a single tenant. And you may have seen other restrictions by the time of the announcement. For instance, Oracle Multitenant indeed is not supported yet. Especially the section about the database features not being supported in the blog post of the EBS team triggered a lot of questions:

  • Active Data Guard
  • Data Guard
  • Data Masking
  • Database Vault
  • Transportable Database and Transportable Tablespaces for data migration processes

I stopped counting how often I had discussions with EBS customers about these limitations since then. If you have questions about the support for Data Guard and TTS for EBS with 19c, please read below.

Collection of EBS upgrade information for Oracle Database 19c

In MOS, a lot of EBS notes get displayed. And almost all of them are VERY long. But clearly, the notes to start with are:

Oddly enough, the tool to upgrade the database is DBUA. And there are a lot of extra steps necessary.

In addition, you may want to check these notes – and most likely they are linked from the interoperability notes as well:

And while I was reading back and forth in the EBS MOS Note jungle, I found this note here:

I can just confirm that it is really useful.

Furthermore, the EBS team has a blog series of Quarterly EBS Upgrade Recommendations which I found very helpful, too:

Data Guard and EBS with Oracle 19c

As I explained above, the original EBS 19c blog post mentioned no support for DG and ADG (Actice Data Guard). But interestingly you can find these notes:

which explains that you of course can have a physical standby with EBS in Oracle 19c with the CDB architecture. You can even use ADG for reporting purposes. So there must have been a change I haven’t noticed regarding the certification of DG and ADG. Well …

RAC and EBS with Oracle 19c

Here you find also several notes on MOS, such as:

EBS Migration to Oracle 19c

I guess, these notes may be helpful:

The OGG Note is an interesting one as it basically says: The OGG team does not certify for a specific application. So it is in the hands of the EBS team to tell you whether you can use OGG with EBS. Well … again …

And there is more information available for OGG with EBS:

But how about Transportable Tablespaces?

I can’t tell you as I was unable to find out any further details. Even MOS Note: 1377213.1 – R11i / R12: Oracle E-Business Suite Upgrades and Platform Migration didn’t reveal anything about Oracle 19c support or the reasons why TTS was not supported for 19c migrations. If you have more information, please share with me via the comments section.

Further Links and Information

–Mike

Share this: