Error ORA-01722: invalid number, When Running On Catctl.pl and Catupgrd.sql
I have updated database 12.1.0.2 and restore it my full backup with RMAN from database 11.2.0.3 with steps :
- rman
- connect target /
- startup nomount;
- restore controlfile from '';
- alter database mount;
- restore database;
- recover database;
- alter database open resetlogs upgrade
- Execute $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql
- Recompile invalid objects with utlrp.sql
But in step 9 when I execute catctl.pl and catupgrd.sql in 12.1.0.2 home the steps failured with status a process terminated prior to completion. The log file, catupgrd0.log, shows :