Monday, March 7, 2022

CHECKLIST FOR ORACLE DATABASE UPGRADE

 

CHECKLIST FOR ORACLE DATABASE UPGRADE

Check List for Oracle Database Upgrade

No

 

Description

Status

 

1.

Enable Port 6000 (Default port) XWindow to run DBUA

 

o Yes

o No

2.

Enable Port 22 (SSH)

*if it’s still not open

 

o Yes

o No

3.

Run XClock to verify status of GUI

 

o Yes

o No

 

4.

DBUA can upgrade only supported versions of direct upgrade.

 

Please verify version from current database

12.1.0.2 OR

12.2.0.1

 

 

o Yes

o No

5.

Download and Run Oracle’ Database Pre-Upgrade Utility (Doc ID 884522.1)

* Oracle Database Pre-Upgrade utility is executed on your existing database, while the database is running (no shutdown required) and provides a list of items which should be reviewed prior to the actual upgrade. 

 

o Yes

o No

6.

Create New Oracle Home for 19c

*Make sure there are enough disks space in the current Oracle home path (12c) to create new Oracle home(19c)

 

 

 

 

7.

Transfer Binary Oracle 19c inside the current Oracle server

 

8.

Source Database

 

         I.            Ensure that all database components/objects provided by Oracle are Valid

 

         II.            Make sure to have a valid backup of source database prior to upgrade.

 

         III.            Ensure backup is complete before upgrade

 

         IV.            Empty recycle bin

 

 

         V.            Disable any custom triggers that would get executed before / after DDL statements. Re-enable after the upgrade.

 

         VI.            Check the database server upgrade/downgrade compatibility matrix before upgrading the database.

 

         VII.            Set Archive Log ON during upgrade. Oracle recommends that you set Archive Log ON in order for DBUA to create and update the log file for the upgrade process.

 

          VIII.            For Oracle RAC, if you upgrade a cluster database using DBUA, then you must leave the CLUSTER_DATABASE initialization parameter set to TRUE.

 

         IX.            Ensure to run the pre-upgrade utility prior to upgrading the database. (refer item no 3)

 

         X.            Examine and follow the recommendation given in the preupgrade log file. (refer item no 3)

 

         XI.            Materialized views in source database should be stopped before upgrade (Doc ID 1406586.1)

 

         XII.             Disable scheduled database custom jobs / cron jobs.

 

 

 

o Yes

o No

 

o Yes

o No

 

o Yes

o No

 

o Yes

o No

 

o Yes

o No

 

 

o Yes

o No

 

 o Yes

o No

 

 

o Yes

o No

 

 

 o Yes

o No

 

o Yes

o No

 o Yes

o No

 

o Yes

o No

9.

Target Database

 

         I. Verify whether Operating System/ Platform is certified for 19x release

 

         II.  Make sure to set the ORACLE_HOME, PATH, LD_LIBRARY_PATH, LIBPATH etc. to 19.x target home.

 

         III. Review patch status inside current database (Doc ID 2539751.1)

 

 

 

 

 

o Yes

o No

 

o Yes

o No

 

 o Yes

o No

10.

Make sure Latest RMAN Backup success before start upgrade

o Yes

o No

 


No comments: