3.8 Upgrade to Oracle Database 19c (19.8)

To use Oracle LSH, you must use Oracle Database 19c. You can upgrade to Oracle Database 19c from Oracle Database 11.2.0.4 or perform a full installation.

Note:

For details on upgrading your Oracle Database to 11.2.0.4 before upgrading to 19c, follow the procedures in My Oracle Support document 1058763.1, Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2.

Before you proceed with upgrading or installing Oracle Database 19c, remove the residual Oracle Warehouse Builder (OWB) management objects:

1. Download Oracle LSH 3.0 Patch 31136807.
2. Unzip patch 31136807 (DO NOT APPLY PATCH).
3. Go to PATCH_Folder/31136807/cdr/patch/115/sql.
4. Connect to the database as APPS user and run the cdrdropmgmt.sql script. You see the following message:

   This script will drop all the residual MGMT$ objects created by OWB To continue, press upper-case Y and Return key. Press any other key to abort:

5. Enter Y.

   Here is a sample of the type of output you see:

   ****************** WITHIN THE DROP MANAGEMENT OBJECTS SCRIPT ******************
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_CHECKDBAPRIVS
   DROP TABLE CDR_W4D_1054C9F.MGMT$REORG_CHECKPOINT
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_COPYDATA
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_DELETEJOBTABLEENTRY
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_DROPDBLINKS
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_ERROREXIT
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_ERROREXITORAERROR
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_MOVELONG
   DROP FUNCTION CDR_W4D_1054C9F.MGMT$REORG_MOVELONGCOMMAND
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_SENDMSG
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_SETSTEP
   DROP PROCEDURE CDR_W4D_1054C9F.MGMT$REORG_SETUPJOBTABLE
   ****************** DONE WITH THE DROP MANAGEMENT OBJECTS SCRIPT ******************
   

6. If you use the Oracle LSH Workflow feature, you need to reinstall the existing Oracle LSH workflows as described in Reinstall Existing Oracle LSH Workflows. Otherwise, skip that procedure.

Once you complete the previous tasks in this chapter, see one of the following documents on My Oracle Support to upgrade or install Oracle Database 19c.

• For an Oracle RAC environment: Document 2530680.1, Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.1

  Note:

  Once you reach "Section 4: Install Oracle Database 19c RAC Software on Grid Infrastructure 19c" in the My Oracle Support document, stop after step 9 (after you apply the patches in section 1, step 8: "Apply additional 19c RDBMS patches" of My Oracle Support Knowledge Document 2580629.1, Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c). Before you perform step 10, install the following patches:

  • Patch 31143870. See "Bug 31321089 : PATCH OF 31143870 ON DATABASE RU 19.6.0.0.0 FOR LINUX X86-64 [226]" on My Oracle Support for details.
  • Patch 30955442. See "Bug 31318599 : PATCH OF 30955442 ON OCW RU 19.6.0.0.0 FOR LINUX X86-64 [226]" on My Oracle Support for details.
• For a non-RAC environment: Document 2580629.1, Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c
• When your database is on OCI Exadata ( ExaCS): Document 2617850.1, Upgrading Oracle Database 11g to Oracle Database 19c for Oracle E-Business Suite Release 12.1 on OCI Exadata DB Systems.

Once you upgrade the database, perform the post-upgrade tasks.

• Perform Oracle Database 19c Post-Upgrade Tasks