ORA-01722: invalid number

Issue:

DOC>#######################################################################

DOC>#######################################################################

DOC>     The following statement will cause an "ORA-01722: invalid number"

DOC>     error if the Oracle Database Vault option is TRUE.  Upgrades cannot

DOC>     be run with the Oracle Database Vault option set to TRUE since

DOC>     AS SYSDBA connections are restricted.

DOC>

DOC>     Perform "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT", relink

DOC>     the server without the Database Vault option, and restart the server

DOC>     using UPGRADE mode.

DOC>

DOC>

DOC>#######################################################################

DOC>#######################################################################

DOC>#

SELECT TO_NUMBER('DATA_VAULT_OPTION_ON') FROM v$option

                 *

ERROR at line 1:

ORA-01722: invalid number

Cause:

Before running upgrade script disable dv  at OS level

chopt disable dv

Once the upgrade script is completed enable dv

 

chopt enable dv