The course will help you to upgrade Oracle Database from 12c to 19c, here are the course contents

Upgrading Oracle EBS Database to 19c. 3

About the Upgrade. 3

Environment: 3

Here are support notes that we are going to follow.. 5

Let’s download 19.3 from below links. 5

Highlevel Steps. 6

Before the Database Installation. 6

After the Database Upgrade. 6

Convert Database to Multitenant Architecture. 6

Before the Database Installation. 7

Run hcheck.sql 7

Apply required patches on R12.2.x. 8

Migrate Autoconfig to DB Tier: 10

Create the initialization parameter setup files: 11

Install Oracle Database 19c. 12

Install vncserver. 12

Disable firewall in Linux 7. 12

Upgrade Oracle Home from 19.3 to 19.12. 24

Apply the latest 19c Database Patches: 27

Create the nls/data/9idata directory. 28

Create appsutil and copy it to the database tier. 28

Install JRE 8. 29

Create the container database - DEVCDB. 29

Create the CDB MGDSYS schema. 53

Create the CDB TNS Files: 54

Shutdown the CDB now.. 56

Database upgrade. 57

Store the UTL_FILE_DIR parameter values. 57

Drop SYS.ENABLED$INDEXES. 59

Remove the MGDSYS schema (not applicable for our version) 59

Shut down the database listener. 60

Database Pre-Upgrade Steps: 60

Run the Pre-upgrade Tool: 61

Make changes to initDEV.ora file as follows. 73

Upgrade the database instance. 75

Issues and Solutions. 85

Perform patch post-install instructions. 88

After the Database Upgrade. 88

Run adgrants.sql 88

Grant create procedure privilege on CTXSYS. 89

Compile invalid objects. 89

Grant datastore access. 89

Convert Database to Multitenant Architecture: 91

Run the post PDB script 102

Modify initialization parameters: 108

How to Connect as SYSDBA without password into a PDB directly. 119

Verify ETCC patches are applied. 121

References: 122