Enterprise Manager Agent Configuration Issue

After upgrade 11.1.0.7 oracle rdbms to 11.2.0.3 , enterprise manager 11g has begun to work improperly.When running "emctl status console" command in unix shell , the message was that "running" , but when clicking the enterprise manager url the error message was database is down.After upgrading database ; ORACLE_HOME path , listener configuration ... etc. was changed and EM control needs to fix.

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