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
新值 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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25152032/viewspace-752418/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25152032/viewspace-752418/