My Oracle Support Banner

Database Upgrade Fails with Error :'ORA-01722: invalid number' for SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME') (Doc ID 1486277.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to Upgrade the database it fails with the following error occurs.

SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')
  *
ERROR at line 1:
ORA-01722: invalid number

 ------------------------------------------------------------------------------------------

When Upgrading to 12.2 ,the following error seen:

***********   Executing Change Scripts   ***********
Serial   Phase #:0    [ORCL] Files:1 wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
Unexpected error encountered in catconExec; exiting
2
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 7822.
at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 7822.
       main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} 2") called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 4556
       main::catctlExecutePhaseFiles(0, 1, undef, undef, undef) called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 1862
       main::catctlRunPhase(0, 1, undef, undef, undef) called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 2006
       main::catctlRunPhases(0, 116, 116, undef, undef, undef) called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 2171
       main::catctlRunMainPhases() called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 1341
       main::catctlMain() called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 1256
       eval {...} called at /u01/app/product/12.2.0/db_1/rdbms/admin/catctl.pl line 1254

 

Check the Upgrade logs:catupgrd0.log ,there will find the exact error for which the upgrade failed:

SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')
                *
ERROR at line 1:
ORA-01722: invalid number

 

 

Changes

 The Source database has timezone Version greater than the  timezone version of the target database  ORACLE HOME .

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.