Home » RDBMS Server » Enterprise Manager » ERROR CREATING REPOSITORY (11.2.0.3)
ERROR CREATING REPOSITORY [message #634452] Tue, 10 March 2015 04:18 Go to next message
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.
Re: ERROR CREATING REPOSITORY [message #634454 is a reply to message #634452] Tue, 10 March 2015 04:33 Go to previous message
gazzag
Messages: 1118
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;
Previous Topic: Difference between OEM 11g and OEM cloud computing
Next Topic: Able to create custom user to connect db console ?
Goto Forum:
  


Current Time: Fri Mar 29 06:30:58 CDT 2024