Infrastructure Software

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