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.

Advertisements

About Bruno Carvalho

Coffee addicted tech guy.
This entry was posted in ORACLE Database and tagged , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s