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 .