Dbconsole installation and repository configuration

Please find the steps to configure Sysman and DBconsole and Repsoitory configuration.

Before that kindly check Os privilge and Oracle related folder permission.

Steps:-

Restore the DB and to check whether sysman and dbsnmp id available and it
should be unlock mode.Collect password for those accounts.

1) Logon SQLPLUS as user SYSMAN
2) exec
DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'MGMT_NOTIFY_QTABLE',force
=>TRUE);

3) Logon SQLPLUS as user SYS or SYSTEM
4) SHUTDOWN IMMEDIATE;
5) STARTUP RESTRICT;
6) EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
7) EXEC sysman.setEMUserContext('',5);
8) REVOKE dba FROM sysman;

9)

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;
/

10) DROP USER mgmt_view CASCADE;
11) DROP ROLE mgmt_user;
12) DROP USER sysman CASCADE;
13) ALTER SYSTEM DISABLE RESTRICTED SESSION;
14) drop public synonym MGMT_TARGET_BLACKOUTS;
15) drop public synonym SETEMVIEWUSERCONTEXT;

Delete DB Control Configuration Files and Repository Objects using
EMCA in Command prompt
================================================================
For DB Control 10.2.x,
16) /bin/emca -deconfig dbcontrol db -repos drop


Create the DB Control Configuration Files
===================================
17) bin/emca -config dbcontrol db -repos create

Warning : - No New Connections or Operations Can Be Performed During
the DB Control Repository Creation.

Finally restart the database.