Errors while creating DBConsole

Problem:

You receive one of the following errors while creating DBConsole ORA-24344, ORA-04063, PLS-00201

Solution:

To solve this, grant the following permissions to public:

sqlplus /nolog
conn / as sysdba
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;

Now run the command to recreate the DB Repos again:

Windows:
%ORACLE_HOME%\bin\emca -config dbcontrol db -repos recreate

Unix/Linux:
$ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

Notice that it would be a good idea to revoke these permissions and grant them directly to SYSMAN after the creation of the OEM repository.