3 Replies Latest reply: Oct 14, 2013 10:14 AM by Pradeepcmst RSS

    sysman packages invalid after migration ,10g to 11g !

    shipon_97

      Dear Friends ,

       

       

      I  have to upgrade my database from oracle 10gR2(10.2.0.1) to oracle 11gR2 (11.2.0.3) , also oracle 11g is in

      the RAC environment .

       

       

      During upgradation , I first take full backup of the oracle10g using datapump and then import it onto the

      oracle11g (with RAC) using datapump and FULL=y parameter . After the migration I see that my OEM is not

      working . For investigate more then I found most of the SYSMAN packages are invalid .

       

       

       

       

      For example :

       

       

      SQL> select owner, object_name, object_type,status from dba_objects where object_name ='MGMT_USER';

       

       

      OWNER                          OBJECT_NAME              OBJECT_TYPE          STATUS

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

      PUBLIC                         MGMT_USER                SYNONYM              VALID

      SYSMAN                         MGMT_USER                PACKAGE               VALID

      SYSMAN                         MGMT_USER                PACKAGE BODY         INVALID

       

       

       

       

      when I am going to complie the package then it shows error :

       

       

      PACKAGE BODY SYSMAN.MGMT_USER

      On line:  2279

      PL/SQL: ORA-00904: "OWNER": invalid identifier

       

       

       

       

       

       

       

      At in this stage , How can I resolve this issue on the Oracle11g environment .

        • 1. Re: sysman packages invalid after migration ,10g to 11g !
          Anar Godjaev

          Hello,

           

          Try to recreate repository with help of metalink(Oracle support ) note 278100.1


          For example:

          emca -deconfig dbcontrol db -repos drop

          STARTED EMCA at Nov 29, 2011 9:16:31 AM

          EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved.

          Enter the following information:

          Database SID: TEST11GR2

          Listener port number: 1521

          Password for SYS user:

          Password for SYSMAN user:

          ———————————————————————- WARNING : While repository is dropped the database will be put in quiesce mode. ———————————————————————-

          Do you wish to continue? [yes(Y)/no(N)]: y

          Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.EMConfig perform

          INFO: This operation is being logged at

          /oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_16_30.log.

          Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

          INFO: Stopping Database Control (this may take a while) …

          Nov 29, 2011 9:16:55 AM oracle.sysman.emcp.EMReposConfig invoke

          INFO: Dropping the EM repository (this may take a while) …

          Nov 29, 2011 9:19:15 AM oracle.sysman.emcp.EMReposConfig invoke

          INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 29, 2011 9:19:18 AM

          anar/oracle/ora11gR2> emca -config dbcontrol db -repos create

          STARTED EMCA at Nov 29, 2011 9:19:25 AM

          EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved.

          Enter the following information:

          Database SID: TEST11GR2

          Listener port number: 1521

          Listener ORACLE_HOME [ /oracle/ora11gR2 ]:

          Password for SYS user:

          Password for DBSNMP user:

          Password for SYSMAN user:

          Email address for notifications (optional):

          Outgoing Mail (SMTP) server for notifications (optional):

          —————————————————————–

          You have specified the following settings

          Database ORACLE_HOME ……………. /oracle/ora11gR2

          Local hostname ……………. dbanar

          Listener ORACLE_HOME ……………. /oracle/ora11gR2

          Listener port number ……………. 1521

          Database SID ……………. TEST11GR2

          Email address for notifications ……………

          Outgoing Mail (SMTP) server for notifications ……………

          —————————————————————–

          Do you wish to continue? [yes(Y)/no(N)]: y

          Nov 29, 2011 9:19:46 AM oracle.sysman.emcp.EMConfig perform

          INFO: This operation is being logged at

          /oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_19_24.log.

          Nov 29, 2011 9:19:47 AM oracle.sysman.emcp.EMReposConfig createRepository

          INFO: Creating the EM repository (this may take a while) …

          Nov 29, 2011 9:26:16 AM oracle.sysman.emcp.EMReposConfig invoke

          INFO: Repository successfully created

          Nov 29, 2011 9:26:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

          INFO: Uploading configuration data to EM repository (this may take a while) …

          Nov 29, 2011 9:27:19 AM oracle.sysman.emcp.EMReposConfig invoke

          INFO: Uploaded configuration data successfully

          Nov 29, 2011 9:27:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

          INFO: Securing Database Control (this may take a while) …

          Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

          INFO: Database Control secured successfully.

          Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil startOMS

          INFO: Starting Database Control (this may take a while) …

          Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

          INFO: Database Control started successfully

          Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

          INFO: >>>>>>>>>>> The Database Control URL is https://dbanar:1158/em <<<<<<<<<<<

          Nov 29, 2011 9:28:13 AM oracle.sysman.emcp.EMDBPostConfig invoke

          WARNING:

          ************************  WARNING  ************************

          Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in th file:

          /oracle/ora11gR2/dbanar_TEST11GR2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will becom unusable if this file is lost.

          ***********************************************************

          Enterprise Manager configuration completed successfully

          FINISHED EMCA at Nov 29, 2011 9:28:13 AM

          anar /oracle/ora11gR2> emctl status dbconsole

          Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

          Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.https://dbanar:1158/em/console/aboutApplication

          Oracle Enterprise Manager 11g is running. ——————————————————————

          Logs are generated in directory /oracle/ora11gR2/dbanar_TEST11GR2/sysman/log anar /oracle/ora11gR2>

           

          ANd please check again package status 

           

          Thank you


          Thank you



          • 2. Re: sysman packages invalid after migration ,10g to 11g !
            Levi Pereira

            You don't upgrade database only migration data between version, so many objects was from 10.2 to 11.2 without upgrade.

            The recommended is migrate only USER data to 11.2 instead migrate everthing to 11.2.

            Also the recommended is perform UPGRADE of database instead use export/import.


            I think you you need remove Datacontrol manually and Re-create it, also you can try upgrade EM Datacontrol.

             

            How To Manually Upgrade DBConsole Configuration After Database Upgrade (Doc ID 1293264.1)

            • 3. Re: sysman packages invalid after migration ,10g to 11g !
              Pradeepcmst

              Hi Shipon,

              If you upgrade, you must run utlrp.sql to recompile all objects in database.