Dev's Weblog

Reading time: 1 - 2 minutes

I were stuck with OMS configuration while installing EMGC 10.2.0.1.

I checked in $OMS_HOME/sysman/log directory but couldn't find anything.

There was no latest file in $OMS_HOME/sysman/log which proved that OMS configuration is hanging.

I looked into $OMS_HOME/cfgtoollog/cfgfw/CfmLogger_2008-12-11_11-02-50-AM.log file and found that the last step was dropping SYSMAN used and it never completed it ,so i followed the followinf steps and then OMS configuration succeeded.

A

1. EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
2. EXEC sysman.setEMUserContext('',5);
3. REVOKE dba FROM sysman;
4. 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;
5. DROP USER mgmt_view CASCADE;
6. DROP ROLE mgmt_user;
7. DROP USER sysman CASCADE;
8. drop public synonym MGMT_TARGET_BLACKOUTS;
9. drop public synonym SETEMVIEWUSERCONTEXT;