ORA-01921 when configuring Oracle Enterprise Manager

Posted: June 12, 2012 in Oracle
Tags: , , ,

Configuring Oracle Enterprise Manager on Oracle 11g through command ’emctl -config dbcontrol db -repos create’ may sometimes lead to error ORA-01921

Go through the following steps to resolve this issue.

  1. In sqlplus :
    drop user sysman cascade;
    drop public synonym SETEMVIEWUSERCONTEXT;
    drop role MGMT_USER;
    drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
    drop user MGMT_VIEW;
  2. emca -deconfig dbcontrol db
    emca -config dbcontrol db -repos create
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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