Monday, July 28, 2014

Always run the pre-upgrade script before a database upgrade!

I was in a hurry to upgrade a database from to and encountered the following error message: ORA-1722 when running the catupgrd.sql script. The script exited with the error message I just listed.

The root cause of the problem is that you must always run the utlu112i from the $ORACLE_HOME/rdbms directory before you upgrade your database. This script is not optional, it is actually mandatory since it makes changes to the database dictionary for the upgrade preparation.

I also suggest to please create a flashback guaranteed restore point just before kicking off the upgrade just in case you need to flash your database back. This can save valuable hours to flashback a database rather than restoring it from a backup. You can simply flashback the database to the GRP - guaranteed restore point if required rather than doing a full database restore which may take several hours or more from a disk based backup.

No comments:

Post a Comment