Tuesday, May 26, 2015

Enterprise manager Configuration




1- make sure you have static IP also add it to hosts file



2-  Login as sysdba and follow the steps :
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP RESTRICT;
SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
SQL> EXEC sysman.setEMUserContext('',5);
SQL> REVOKE dba FROM sysman;
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 USER mgmt_view CASCADE;
SQL> DROP ROLE mgmt_user;
SQL> DROP USER sysman CASCADE;
SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;


 
3-  Make sure var -à path is oracle home

4-  Make sure sqlnet.ora has (NTS)

5-  Run : emca -repos drop
: emca -deconfig dbcontrol db ( -cluster for RAC)

6-  Run : emca -repos create
: emca -config dbcontrol db ( -cluster for RAC)



8-  Cmd> emctl start dbconsole

9-  login from web browser : https://hostname or IP:1158/em/console/aboutApplication

or https://hostname or IP:1158/em/console/logon/logon

No comments:

Post a Comment