Oracle E-Business Suite Database Upgrade to 19c

Release of Oracle DB 19c certification

event='10946 trace name context forever, level 8454144'

Interoperability documentation

Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)

Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1)

• Don't skip the step of exporting your existing utl_file_dir info using the Oracle Note - Document 2525754.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. the Oracle EBS team complicated the process of adding or removing a directory to the utl_file_dir list in 19c quite a bit. If you think you can skip this step, and were considering setting new dirs after your 19c upgrade, you'll be in for a surprise. You won't be able to add any new directories, unless you first do a export / import from your older 11g/12cR1 database to 19c following note 2525754.1.
• Another gotcha is the NLS character set of the CDB. By default when you install CDB as part of the 19c notes, it creates it with the AL16UTF16 national character set. This is incompatible with most modern EBS databases which use the UTF-8 character set. So, remember to set the CDB to use AL32UTF8 during the install. Follow note 1968706.1 for more information on this compatibility issue.
• And a final gotcha is the absence of autoconfig on the database node. The interop notes say to copy appsutil code base to DB node, but have no mention of how to enable autoconfig on the new 19c database. In our case, we had to build a new DB context xml file using adbldxml.pl. Still, we noticed it wasn't picking all the CDB/PDB values properly and we ended up fixing those manually. Enabling autoconfig on DB Oracle home is quite important, as this DB autoconfig populates the DB topology in the FND tables. This is in turn used by apps autoconfig to generate tnsnames/jdbc strings on apps nodes. Without the DB home autoconfig setup, the apps side will be a big mess.