at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
再次执行仍然报错，还没完了。。。
CONFIG: ORA-01921: role name 'MGMT_USER' conflicts with another user or role name
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01921: role name 'MGMT_USER' conflicts with another user or role name
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
登入数据库，这下彻底删除与em有关的用户信息
select grantee, granted_role from dba_role_privs where granted_role = 'MGMT_USER';
drop role mgmt_user;
drop user sysman cascade;
drop user mgmt_view cascade;
SET HEADING OFF;
spool a.sql
SELECT 'DROP PUBLIC SYNONYM ' || SYNONYM_NAME || ';'
FROM ALL_SYNONYMS
WHERE OWNER = 'PUBLIC' AND TABLE_OWNER ='SYSMAN';
spool off
SET HEADING ON;
@a.sql
再次创建资料库就行了
Jul 30, 2014 7:32:06 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_2014-07-30_07-31-53-PM.log.
Jul 30, 2014 7:32:06 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 30, 2014 7:39:28 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully