Trying different commands in order to configure EM was come to nothing.First I did ,
#emca -deconfig dbcontrol db -repos drop
After that ,
#emca -config dbcontrol db -repos recreate
Again failure above commands , I decide to manual drop EM repository.
SQL >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;
/
SQL >DROP ROLE mgmt_user;
SQL >drop user mgmt_view cascade;
SQL >drop user sysman cascade;
--------------------------------------------------------------------------------------------------
* If you have sessions that belongs to EM or related with SYSMAN user , you should kill these sessions.
After that , I tried to create repository , but again failure ;
#emca -config dbcontrol db -repos create
Running drop/create repository command and it success !
#emca -deconfig dbcontrol db -repos drop
#emca -config dbcontrol db -repos create
0 yorum:
Yorum Gönder