Can't start EM DB Control : EM Daemon is not running
Hi,
I've installed (after hours of struggling) Oracle 10gR2 on a Debian 64 bits server.
At the end of the installation, I thought that everything was OK, I was able to connect to the instance with SqlPlus, but when I've tried to log in at the local EM DB Control page, I got the following error :
java.lang.Exception: Exception in sending Request :: null
"emctl status dbconsole" returns : EM Daemon is not running.
I've found in emoms.trc the following error occuring several times :
2007-08-07 14:03:10,770 [EMUI_14_03_10_/console/database/instance/sitemap] ERROR perf.sitemap initializeGeneral.398 - Failed to initialize object: ORA-20206:
ORA-06512: at "SYSMAN.EMD_DATABASE", line 1165
ORA-01403: no data found
ORA-06512: at line 1
I've recreated successfully the repository using these commands :
in sql plus :
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
EXEC sysman.setEMUserContext('',5);
REVOKE dba FROM sysman;
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;
/
DROP USER mgmt_view CASCADE;
DROP ROLE mgmt_user;
DROP USER sysman CASCADE;
ALTER SYSTEM DISABLE RESTRICTED SESSION;
and then :
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
everything was OK but I'm still getting the same error, and don't know what else I should do...
I've been searching for hours and nothing fixed my problem
Can anyone please help ?
Thank you very much !
Antoine