Upgrade to 18.0.0 fails with ORA-01722: SELECT TO_NUMBER('GDS_ROLES_ARE_FOUND') FROM SYS.DUAL (Doc ID 2720210.1)

Last updated on OCTOBER 23, 2020

Applies to:

Symptoms

During upgrade from 11.2.0.4 to 18.0.0 receiving ORA-01722: invalid number

00:35:50 SQL>
00:35:50 SQL> SELECT TO_NUMBER('GDS_ROLES_ARE_FOUND') FROM SYS.DUAL
00:35:50 2 WHERE (select count(*) from sys.user$ WHERE
00:35:50 3 name in ('GSMUSER_ROLE', 'GSM_POOLADMIN_ROLE', 'GSMADMIN_ROLE',
00:35:50 4 'GDS_CATALOG_SELECT')
00:35:50 5 AND bitand(spare1, 256) != 256) > 0 AND
00:35:50 6 (select SUBSTR(version,1,4) FROM registry$ where
00:35:50 7 cid = 'CATPROC') < '12.1';
SELECT TO_NUMBER('GDS_ROLES_ARE_FOUND') FROM SYS.DUAL
  *
ERROR at line 1:
ORA-01722: invalid number


Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.6.0.0.0

catupgrd0.log:

==============

Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at $ORACLE_HOME/rdbms/admin/catctl.pl line 9021.
 at /$ORACLE_HOME/rdbms/admin/catctl.pl line 9021.
main::catctlDie("\x{a}Unexpected error encountered in catconExec; exiting\x{a} 2") called at $ORACLE_HOME/rdbms/admin/catctl.pl line 5515
main::catctlExecutePhaseFiles(0, 1, undef, undef, undef) called at $ORACLE_HOME/rdbms/admin/catctl.pl line 1999
main::catctlRunPhase(0, 1, undef, undef, undef) called at $ORACLE_HOME/rdbms/admin/catctl.pl line 2143
main::catctlRunPhases(0, 109, 109, undef, undef, undef) called at$ORACLE_HOME/rdbms/admin/catctl.pl line 2767
main::catctlRunMainPhases() called at $ORACLE_HOME/rdbms/admin/catctl.pl line 1419
main::catctlMain() called at $ORACLE_HOME/rdbms/admin/catctl.pl line 1328
eval {...} called at $ORACLE_HOME/rdbms/admin/catctl.pl line 1326

Changes

Cause

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