"ORA-01722: invalid number" During Upgrade/Downgrade (Doc ID 435536.1)

Last updated on MAY 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.7 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.


Symptoms

You are getting following error while performing upgrade/downgrade of the database. 
This error appears when executing script in the following release only

catbkout.sql (Available on  9.2.0.7 and Above )
catbkout.sql (Available on 10.1.0.5 and Above )
catbkout.sql (10.2.0.2 and Above )
catupgrd.sql (10.2.0 Above)

SQL> @?/rdbms/admin/catupgrd.sql 


DOC>####################################################################### 
DOC>####################################################################### 
DOC> The following statement will cause an "ORA-01722: invalid number" 
DOC> error if the database has not been opened for UPGRADE. 
DOC> 
DOC> Perform a "SHUTDOWN ABORT" and 
DOC> restart using UPGRADE. 
DOC>####################################################################### 
DOC>####################################################################### 
DOC># 
SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance 
* 
ERROR at line 1: 
ORA-01722: invalid number 

Cause

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 hundreds of Community platforms