SQL> alter database open resetlogs upgrade; SQL> SPOOL upgrade.log SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql SQL> SPOOL OFF SQL> shu immediate SQL> startup SQL> @$ORACLE_HOME/rdbms/admin/catuppst.sql SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
####################################################################### ####################################################################### The following statement will cause an "ORA-01722: invalid number" error if the current timezone version file is not the same as the version in the database to be upgraded. The statement will cause an ORA-00942 or ORA-00904 error if the pre-upgrade utility (utlu111i.sql) has not be run to update registry$database table to include the existing database timezone file version. Shutdown ABORT and revert to the original ORACLE_HOME. Then apply the required timezone version patch to the original ORACLE_HOME prior to attempting to upgrade. Re-run utlu111i.sql after applying the patch to record the new timzone file version in the registry$database table. ####################################################################### ####################################################################### # SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION') FROM registry$database WHERE tz_version != (SELECT version from v$timezone_file);
The following statement will cause an "ORA-01722: invalid number" error if the current timezone version file is not the same as the version in the database to be upgraded. The statement will cause an ORA-00942 or ORA-00904 error if the pre-upgrade utility (utlu111i.sql) has not be run to update registry$database table to include the existing database timezone file version.