My Oracle Support Banner

DBUA upgrade to 19.4 in Windows fails with Error:ORA-1722 (Doc ID 2579192.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Oracle Database - Standard Edition - Version 19.1.0.0.0 and later
Microsoft Windows x64 (64-bit)

Symptoms

ORA-1722 error is encountered while upgrading the database from 18.6 to 19.4 on Windows platform, using dbua.


SQL> SELECT TO_NUMBER(
  2   'MUST_BE_&C_ORACLE_HIGH_MAJ..&C_ORACLE_HIGH_RU..&C_ORACLE_HIGH_RUR')
  3  FROM v$instance
  4  WHERE substr(version_full,1,instr(version,'.',1,3)-1) !=
  5    '&C_ORACLE_HIGH_MAJ..&C_ORACLE_HIGH_RU..&C_ORACLE_HIGH_RUR';
   2: 'MUST_BE_&C_ORACLE_HIGH_MAJ..&C_ORACLE_HIGH_RU..&C_ORACLE_HIGH_RUR')
   2: 'MUST_BE_19.3.0')
   5:      '&C_ORACLE_HIGH_MAJ..&C_ORACLE_HIGH_RU..&C_ORACLE_HIGH_RUR'
   5:      '19.3.0'
  'MUST_BE_19.3.0')
  *
Line 2:
ORA-01722: invalid number

 

 

Changes

 

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.