Site icon Database Tutorials

ORA-01722 error received during upgrade process

 

When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in the database.

In this case, the Database Vault must be set to off.

You can set to off the Database Vault with the following steps for the solution of the error. All services that use the relevant binary must be closed beforehand.

If you are using an RAC database, these operations must be performed on all nodes separately.

Then restart with “startup upgrade” and you can run catupgrd.sql successfully.

Exit mobile version