Step by Step upgrade of Oracle Database 12c to 19c Upgrade Manually on Linux
1. Source Database - 12.2.0.1 (12cR2)
2. Target Database - 19.0.0 (19c)
3. Red Hat Linux 7.8
4. Virtual Box 7.6
Timeline:
00:00 Introduction
00:12 Steps Overview
03:30 Softwares Used
03:50 Install Oracle 19c
08:50 Pre-Upgrade - Recompile and Gather Stats
10:28 Configure FRA, take backup and create restore point
16:50 Preupgrade.jar script
24:16 Perform Upgrade
36:20 Modify /etc/oratab
36:50 Start Upgraded 19c Database
38:02 Upgrade Timezone
41:54 Run Postupgrade fixup
42:35 Validate components using DBA_REGISTRY
43:00 Drop Flashback Restore Point
44:20 Upgrade Database Compatible Parameter
45:32 Recompile Invalid Objects and Gather Stats
46:30 Start Oracle 19c Listener
48:00 Test Remote Connectivity
48:50 Ending Notes
