ora-01722 upgrade 11g standby database to 19c
HI all,
Tried with autoupgrade and dbua method to upgrade a 11.2.0.4 EE logical standby database to 19.15 EE database on Linux 7 gives ora-1722.
I already fixed Max_sga, exec dbms_logstdby.apply_set('MAX_SGA', '50'), still got the same error.
Here is error from autoupgrade
SCRIPT = [/u01/app/oracle/product/19EE/rdbms/admin/c1102000.sql]
ERROR = [ORA-01722: invalid number] <<<-------
STATEMENT = [update system.logstdby$parameters
set value = '50'
where upper(name) = 'MAX_SGA'
and value is not null
and to_number(value, '999999999999') < 50]
Anybody having the same experience?
Thanks
a friend