Database Backup and Recovery (MOSC)

MOSC Banner

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 :

  1. rman
  2. connect target /
  3. startup nomount;
  4. restore controlfile from '';
  5. alter database mount;
  6. restore database;
  7. recover database;
  8. alter database open resetlogs upgrade
  9. Execute $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql
  10. 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 :

SELECT TO_NUMBER('INVALID_TABLEDATA') FROM SYS.DUAL

WHERE (SELECT COUNT(*) FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL# AND BITAND(t.FLAGS, 256) = 256) > 0;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center