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 No o Yes o No o No o Yes o No 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 No |
10. |
Make sure Latest RMAN Backup success before start upgrade |
o Yes o No |
No comments:
Post a Comment