1. Install oracle software for the database on Oracle Home 19.3.0
2. Remove obsoleted init parameters and others
3. Stop the listener
4. Gather stats for dictionary and fixed objects
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
5. Empty recycle bin - purge dba_recyclebin;
6. Check whether we are using the right Time zone file. Need to update the latest time zone file.
7. Run Pre-Upgrade Information Tool
(12.1 Home)/jdk/bin/java -jar (19.3 Home)/rdbms/admin/preupgrade.jar FILE TEXT DIR /home/oracle/upgrade
execute preupgrade_fixups.sql
8. Stop 2nd RAC instance and Disable cluster and stop 1st instance
9. set the env variable for 19C
10. Start DB in upgrade mode - startup upgrade
11. invoke DB upgrade - (19.3 Home)/bin/dbupgrade
2. Remove obsoleted init parameters and others
3. Stop the listener
4. Gather stats for dictionary and fixed objects
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
5. Empty recycle bin - purge dba_recyclebin;
6. Check whether we are using the right Time zone file. Need to update the latest time zone file.
7. Run Pre-Upgrade Information Tool
(12.1 Home)/jdk/bin/java -jar (19.3 Home)/rdbms/admin/preupgrade.jar FILE TEXT DIR /home/oracle/upgrade
execute preupgrade_fixups.sql
8. Stop 2nd RAC instance and Disable cluster and stop 1st instance
9. set the env variable for 19C
10. Start DB in upgrade mode - startup upgrade
11. invoke DB upgrade - (19.3 Home)/bin/dbupgrade
No comments:
Post a Comment