DanBrother的部落格

-- Method 1
cd C:\app\oracle\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin
set ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1
repmanager localhost 1521 -action drop -sys_password

Enter repository user name : sysman
Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Checking SYS Credentials ... rem error switch
OK.
rem error switch
Dropping the repository..
Checking for Repos User ... Exists.
Repos User exists..
Clearing EM Contexts ... OK.
Dropping EM users ...
Done.
Dropping Repos User ... Done.
Dropping Roles/Synonymns/Tablespaces ... Done.
Dropped Repository Successfully.

-- Method 2
emca -deconfig dbcontrol db -repos drop

-- Create a new Database Control Repository
emca -config dbcontrol db -repos create

Solution for ORA-01920: user name 'MGMT_VIEW' conflicts with another user or role name when re-create a new OEM repository
>>
SQL> conn / as sysdba
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;

emca -config dbcontrol db -repos create