My Oracle Support Banner

12.2:dbupgrade Failed with SELECT TO_NUMBER('MUST_BE_12_2_0_1') FROM v$instance ORA-01722: invalid number (Doc ID 2246737.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

After completing preupgrade utility execution and other validations when database upgrade utility was run it failed with following error 

1:50:16 DOC>######################################################################
11:50:16 DOC>######################################################################
11:50:16 DOC> The following statement will cause an "ORA-01722: invalid number"
11:50:16 DOC> error if the database server version is not correct for this script.
11:50:16 DOC> Perform "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT", and use
11:50:16 DOC> a different script or a different server.
11:50:16 DOC>######################################################################
11:50:16 DOC>######################################################################
11:50:16 DOC>#
11:50:16 SQL>
11:50:16 SQL> SELECT TO_NUMBER('MUST_BE_12_2_0_1') FROM v$instance
11:50:16 2 WHERE substr(version,1,8) != '12.2.0.1';
SELECT TO_NUMBER('MUST_BE_12_2_0_1') FROM v$instance <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
*
ERROR at line 1:
ORA-01722: invalid number <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

 

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!


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