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