Home > Oracle > Oracle 11g recreate EM dbconsole

Oracle 11g recreate EM dbconsole

I’ve run into the same errors trying to drop and recreate EM dbconsole.  Following the below steps still fails:

emca -deconfig dbcontrol db -repos drop 
emca -config dbcontrol db -repos create 
These type of errors would still show up in emca error log:
RROR at line 1:
ORA-04063: package body "SYSMAN.MGMT_AUDIT_LOG" has errors
ORA-06508: PL/SQL: could not find program unit being called:

Here’s how to fix it:

SQL> grant execute on dbms_obfuscation_toolkit to public;

Grant succeeded.

SQL> grant execute on utl_file to public;

Grant succeeded.

Categories: Oracle
  1. Ljupcho
    August 28, 2011 at 7:06 pm

    this saved my life… THANKS!!!

  2. ASIF RASHID
    May 7, 2012 at 2:34 pm

    Saves my Time. Nice Tip. Thank You.

  1. No trackbacks yet.

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

%d bloggers like this: