Oracle Upgrade - Prerequisite

1. Review Oracle Documentation :
Before starting the upgrade process, thoroughly review the Oracle Database Release Notes for both the current and target versions. This will provide information on new features, known issues, and any specific considerations for the upgrade.

2. System Requirements :
Verify that your hardware and operating system meet the minimum requirements for the target Oracle Database version.

3. Backup :
Perform a full database backup before starting the upgrade. This is essential to safeguard your data in case anything goes wrong during the upgrade process.

4. Software Certification :
Check the Oracle certification matrix to ensure that your current Oracle Database version is certified to be upgraded to the target version. Verify that all components, including Oracle Enterprise Manager, are compatible with the new version.

5. Gather Database Statistics :
Use the DBMS_STATS package to gather statistics on the current database. This ensures that the query optimizer has up-to-date statistics for generating optimal execution plans after the upgrade.

6. Check Database Health :
Use tools like the Database Health Check (DBMS_HM) to identify and address any potential issues with your database before the upgrade.

7. Identify Deprecated Features :
Identify and address any deprecated features in your current Oracle version that may have been removed or replaced in the target version.

8. Pre-Upgrade Information Tool :
Run the Pre-Upgrade Information Tool provided by Oracle to identify any potential issues or incompatibilities that might arise during the upgrade.

9. Disable Triggers and Constraints :
Disable triggers and constraints before starting the upgrade to speed up the process. You can re-enable them after the upgrade is complete.

10. Check for Invalid Objects :
Identify and resolve any invalid database objects using the utlrp.sql script provided by Oracle.

11. Review and Plan Downtime :
Review the expected downtime for the upgrade and plan accordingly. Communicate the downtime schedule to relevant stakeholders.

12. Test the Upgrade :
Perform a test upgrade in a non-production environment to identify and address any issues before upgrading the production database.

13. Monitor and Optimize :
Monitor the upgrade process closely and optimize performance as needed. Utilize Oracle Enterprise Manager and other diagnostic tools.


(Oracle Upgrade - 12c to 19c - Container DB)