Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

utlrp.sql running extremely slow during db upgrade from 12.2.0.1 to 19.12

Hello:


We were upgrading a prod database from 12.2.0.1 to 19.12. Right after the upgrade step (./dbupgrade), we ran the required upgrade step to re-compile invalid with the following:


$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql


or


SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql



We used the first command above at command line. But the job took 3 days for this db of 8 Tb with about 3100 invalid objects - it is still running now. So the db components are still in 19c "UPGRADED" mode - not in new db version 19.12.


So we are seeking advice from you on how to speed up and improve utlrp.sql performance in general and particularly during 19c upgrade.

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