3 Replies Latest reply: Sep 6, 2013 8:21 AM by Jairam RSS

    Components are invalid after the execution of utlrp.sql

    Jairam

      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