18c to 19c - Oracle Database Upgradation

 0. Check Compatibility Before Upgrading Oracle Database

1. Environment

PRE-UPGRADE TASKS

2. Backup
3. Run preupgrade script
4. View Preupgrade log
5. Minimum tablespace sizes for upgrade
6. Update INITIALIZATION PARAMETERS
7. Gather DICTIONARY STATS
8. Purge Recyclebin
9. Refresh MVs
10. Run preupgrade_fixups.sql
11. Verify archive log dest size
12. Stop LISTENER
13. Create Flashback Guaranteed Restore Point

UPGRADE TASK

14. Shutdown Database
15. Copy init and password files from one version to new version 
16. Startup DB in Upgrade mode
17. Run dbupgrade
18. Starup DB from New Oracle Home

POST-UPGRADE TASKS 

19. Run catcon.pl to start utlrp.sql
20. Run postupgrade_fixups.sql
21. Upgrade Timezone
22. Run utlusts.sql
23. Run catuppst.sql
24. Re-Run postupgrade_fixups.sql
25. Reverify INVALID OBJECTS
26. Drop Restore point
27. Set COMPATIBALE parameter value
28. Verify DBA_REGISTRY
29. Add TNS Entries in 19c TNS home
30. Password File – orapwCID
31. Edit oratab
32. Back Up the Database

===================================================

Preupgrade.jar is available under new 19c Oracle Home.

 You can run it like following.
SYNTAX:
$OLD_ORACLE_HOME/jdk/bin/java -jar $NEW_ORACLE_HOME/rdbms/admin/preupgrade.jar -FILE DIR $OS_DIRECTORY
 /applications/oracle/18.4.0.1/jdk/bin/java -jar  /applications/oracle/19.3.0.0/rdbms/admin/preupgrade.jar FILE DIR /home/oracle/19c_upgrade/TRGR
/u01/patch/preupgrade.log
/u01/patch/preupgrade_fixups.sql

/u01/patch/postupgrade_fixups.sql

2) stop the listener and shutdown the database

3)  Set environment variables to NEW ORACLE_HOME(19.3)

SQL> startup UPGRADE

cd /applications/oracle/19.3.0.0/bin

./dbupgrade -n 2 -l /home/oracle/19c_upgrade/script/log

nohup $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl 

-d $ORACLE_HOME/rdbms/admin -l /home/oracle/ -n 96 catupgrd.sql &

5) SQL> STARTUP

$] @/home/oracle/ORACLEDB_upgrade/postupgrade_fixups.sql 

cd $ORACLE_HOME/rdbms/admin

run 

@utlusts.sql TEXT ---------------------->and then (give you the staus of upgrade) ---> 19c  new script 

SQL> @catuppst.sql

Caution: If you perform a manual upgrade, and you do not run catuppst.sql, then your database suffers performance degradation over time.

Run below Script 

cd $ORACLE_HOME/rdbms/admin

1)  @utltz_countstats.sql

2)  @utltz_countstar.sql

3)  @utltz_upg_check.sql

4)  @utltz_upg_apply.sql ------- >  Main script to change DST time zone  ( Open in upgrade mode and down the DB also)

Check the DST version  SELECT version FROM v$timezone_file;