I was in a hurry to upgrade a database from 11.1.0.7 to 11.2.0.4 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