This error Appears when are trying maunally creating EM using :
emca -config dbcontrol db -repos create
To Solve this error make sure you do all the below steps :
1-In your local users and groups add User to ORA_DBA group.
2-Set ORACLE_HOME and ORACLE_SID.
3- sqlplus / as sysdba
@$ORACLE_HOME/rdbms/admin/dbmspool.sql
Package created.
Create the dbmspool package body:
@$ORACLE_HOME/rdbms/admin/prvtpool.plb
View created.
Package body created.
Grant execution privilege on the package:
SQL> grant execute on dbms_shared_pool to sysman;
Grant succeeded.
SQL> grant execute on dbms_shared_pool to dba;
Grant succeeded.
4-Reinstall EM Using
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
