Enterprise Manager Reconfiguration / Recreation

cmd->emca -deconfig dbcontrol db -repos drop


SQL> alter user sysman account unlock; SQL> drop user sysman cascade;

User dropped.

SQL> drop public synonym setemviewusercontext;

Synonym dropped.

SQL> drop role mgmt_user;

Role dropped.

SQL> drop public synonym mgmt_target_blackouts;

Synonym dropped.

SQL> drop user mgmt_view;

User dropped.


cmd->emca -config dbcontrol db -repos create