As we are migrating the last databases from Oracle 10gR2 to the latest 126.96.36.199 release, there are some errors that we stumbled upon along our way. For example, when we tried to upgrade one particular database, during the upgrade the following error was thrown:
SQL> SELECT TO_NUMBER('DATA_VAULT_OPTION_ON') FROM v$option 2 WHERE 3 value = 'TRUE' and parameter = 'Oracle Database Vault'; SELECT TO_NUMBER('DATA_VAULT_OPTION_ON') FROM v$option * ERROR at line 1: ORA-01722: invalid number
Ouch. That is something that you do not want to see during an upgrade! Needless to say, the upgrade won’t continue here, so how to fix this?