This discussion is archived
3 Replies Latest reply: Sep 6, 2013 6:20 AM by Srini Chavali-Oracle RSS

Components are invalid after the execution of utlrp.sql

Jairam Explorer
Currently Being Moderated

Hi All,

 

        I have migrated one database from the version 10.2.0.4 to 10.2.0.5, After the execution of upgrade script all components are found as valid, and then I executed utlrp.sql and at the end of this execution some of the components became Invalid. Please find the details below and Can anyone help me on this?

 

I have used RMAN for migration and started the database by using startup upgrade.

 

SOURCE:

 

OS : Linux 2.6.18-92.el5

 

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

 

 

TARGET:

 

OS :Linux  2.6.18-274.el5

 

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE    10.2.0.5.0      Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

 

 

 

 

 

Regards,

Jai

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points