|
|
METALINK上的信息,看能否解决:
On Windows Systems:
NOTE: The RepManager script in 10.1.0.2.0 does not work correctly on Windows. For this reason, you will have to manually drop the sysman schema and management objects. The RepManager script should be fully functional in the 10.1.0.3.0 release.
1. Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:
• ALTER SYSTEM DISABLE RESTRICTED SESSION;
•
• COMMIT;
•
• SHUTDOWN IMMEDIATE;
•
• STARTUP RESTRICT;
•
• EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
•
• EXEC sysman.setEMUserContext('',5);
•
• REVOKE dba FROM sysman;
•
• DECLARE
• CURSOR c1 IS
• SELECT owner, synonym_name name
• FROM dba_synonyms
• WHERE table_owner = 'SYSMAN'
• ;
• BEGIN
• FOR r1 IN c1 LOOP
• IF r1.owner = 'PUBLIC' THEN
• EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
• ELSE
• EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
• END IF;
• END LOOP;
• END;
•
• DROP USER mgmt_view CASCADE;
•
• DROP ROLE mgmt_user;
•
• DROP USER sysman CASCADE;
•
• ALTER SYSTEM DISABLE RESTRICTED SESSION;
•
2. At a command Prompt, run emca -x sid to remove the existing configuration files and then recreate the schema and configuration files with just emca. For example:
emca -x <SID>
emca |
|