OraFAQ Forum: Enterprise Manager » ERROR CREATING REPOSITORY

Home » RDBMS Server » Enterprise Manager » ERROR CREATING REPOSITORY (11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ERROR CREATING REPOSITORY [message #634452]

Tue, 10 March 2015 04:18

dba44
Messages: 1
Registered: March 2015
Location: sydney

Junior Member

Hello,

When i create the OEM repository, the creation fails with the error

INFO: Creating the EM repository (this may take a while) ...
Mar 10, 2015 4:33:58 PM oracle.sysman.emcp.EMReposConfig createRepository
WARNING: ORA-04063: package body "SYSMAN.MGMT_USER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.MGMT_USER"
ORA-06512: at "SYSMAN.SETEMUSERCONTEXT", line 10
ORA-06512: at line 1

have tied granting these privileges ..

grant execute on utl_smtp to public;
grant execute on utl_tcp to public;
grant execute on utl_file to public;
grant execute on dbms_sql to public;
grant execute on DBMS_OBFUSCATION_TOOLKIT to public;

it didnt work

Any help is appreciated.

Report message to a moderator

Re: ERROR CREATING REPOSITORY [message #634454 is a reply to message #634452]

Tue, 10 March 2015 04:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What is the output from the following?

SELECT comp_name, status, version
FROM dba_registry
ORDER BY comp_id;

Report message to a moderator

Previous Topic:	Difference between OEM 11g and OEM cloud computing
Next Topic:	Able to create custom user to connect db console ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 19:11:58 CST 2025