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.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *