Upgrade Fails With ORA-01722 When Upgrading A Database With Data Vault (Doc ID 1147895.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Manual upgrade to 11.1 using a Data Vault environment fails with an error similar to...

DOC>#######################################################################
DOC>#######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if Database Vault is installed in the database but the Oracle
DOC> Label Security option is FALSE. To successfully upgrade Oracle
DOC> Database Vault, the Oracle Label Security option must be TRUE.
DOC>
DOC> Perform a "SHUTDOWN ABORT", relink the server with the OLS option
DOC> (but without the Oracle Database Vault option) and restart the server
DOC> using UPGRADE.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SELECT TO_NUMBER('LABEL_SECURITY_OPTION_OFF') FROM v$option
*
ERROR at line 1:
ORA-01722: invalid number


Data Vault has been disabled using...

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_off

...but the ORA-1722 error is still happening.

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