Oracle 11g re-build the objects to be deleted by EM

Oracle 11g re-build the objects to be deleted by EM

The re-built EM is required. The re-built EM is forced to stop due to some errors, such as the object already exists and the user already exists. In the end, the necessary conditions for creation are found;

1. environment variables (Oracle and Grid are installed under the same user ):

Set ORACLE_HOME to the DB path;

ORACLE_UNQNAME to be set;

2. Delete synonyms related to em:

Select 'drop public synonym' | synonym_name | ';' from dba_synonyms where regexp_like (synonym_name, '^ MGMT _ | ^ SMP_EMD | ^ EMD _') order by synonym_name; 3. delete em users:

Drop user MGMT_VIEW;
Drop user SYSMAN cascade; 4. Delete em related role:

Drop role MGMT_USER; 5. Check the residual objects related to em and delete them:

Select * from dba_objects where status = 'invalid' AND OBJECT_TYPE = 'synonym'; 6. Recreate em:

Em-config dbcontrol db-repos create

Hope is personal, hope is something that no one can give to you, you have to choose to believe in hope, you have to make it yourself ..