This discussion is archived
3 Replies Latest reply: Oct 14, 2013 8:14 AM by Pradeepcmst RSS

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

shipon_97 Newbie
Currently Being Moderated

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 Expert
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    Hi Shipon,

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

Legend

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