What you'll learn
Oracle EBS DBA
Freshers and Experienced EBS DBA's
Upgrade database from 12c to 19c
Cloud DBA's
Requirements
Oracle EBS DBA
Description
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
Who this course is for
Who want to upgrade from 12c to 19c

Homepage

https://www.udemy.com/course/upgrade-oracle-ebs-database-to-19c/