Database Administration (MOSC)

MOSC Banner

ora-01722 upgrade 11g standby database to 19c

edited Jun 24, 2022 7:29PM in Database Administration (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center