SAP Knowledge Base Article - Preview

2893950 - ORA-01722 during an Upgrade to 19c on Windows

Symptom

Upgrade to Oracle 19c is failing with below error visible in catupgrd0.log

...

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


Read more...

Environment

  • Oracle RDBMS 19c
  • Windows Operating System

Product

SAP ERP 6.0

Keywords

dbua, dbua.sap.ps1, WIN DBBP, 19c, 18c, 12c, 12.1, 12.2, upgrade, Bug, banner, version, catupgrd0.log , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.