My Oracle Support Banner

Upgrade to 12.2 Fails with Error:"ORA-01722: Invalid number : NONUPGRADED_TABLEDATA" (Doc ID 2279497.1)

Last updated on SEPTEMBER 21, 2018

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Upgrading the database to  12.2.
The upgrade errors with the following message :

SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE
*
ERROR in line 1:
ORA-01722: Invalid number

 

Receiving following in upgrade log :

Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at /EMREPO/rdbms/admin/catctl.pl line 8976.
at /EMREPO/rdbms/admin/catctl.pl line 8976.
main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} 2") called at
EMREPO/rdbms/admin/catctl.pl line 5481
main::catctlExecutePhaseFiles(0, 1, undef, undef, undef) called at /EMREPO/rdbms/admin/catctl.pl line 1979
main::catctlRunPhase(0, 1, undef, undef, undef) called at /EMREPO/rdbms/admin/catctl.pl line 2123
main::catctlRunPhases(0, 109, 109, undef, undef, undef) called at /EMREPO/rdbms/admin/catctl.pl line 2739
main::catctlRunMainPhases() called at /EMREPO/rdbms/admin/catctl.pl line 1405
main::catctlMain() called at /EMREPO/rdbms/admin/catctl.pl line 1314
eval {...} called at /EMREPO/rdbms/admin/catctl.pl line 1312

 

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!


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