10g重建EM 报ORA-20001: SYSMAN already exists 报错日志如下: Check if repos user already exists. 原值 6: WHERE username=UPPER('&EM_REPOS_USER'); 新值 6: WHERE username=UPPER('SYSMAN'); 原值 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN 新值 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN 原值 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..'); 新值 11: raise_application_error(-20000, 'SYSMAN does not exists..'); 原值 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN 新值 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN 原值 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..'); 新值 17: raise_application_error(-20001, 'SYSMAN already exists..'); 原值 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE'); 新值 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS'); DECLARE * 第 1 行出现错误: ORA-20001: SYSMAN already exists.. ORA-06512: 在 line 17 解决方法: Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects: 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;
|
|