EMCA Fails With "Failed To Unlock MGMT_VIEW Account" (Doc ID 1081481.1)

Last updated on JANUARY 21, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 14-Feb-2013

Symptoms

Running "emca -config dbcontrol" fails with "Failed to unlock mgmt_view account" error message.
The emca log file shows the following:

Apr 5, 2010 8:28:36 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end;

Apr 5, 2010 8:28:36 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

Apr 5, 2010 8:28:36 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: /opt/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil /opt/oracle/product/11.2.0/db_1/perl/lib:/opt/oracle/product/11.2.0/db_1/perl/lib/site_perl:/opt/oracle/product/11.2.0/db_1/sysman/admin/scripts:/opt/oracle/product/11.2.0/db_1/bin: %s_perlBin%/perl /opt/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl /opt/oracle/product/11.2.0/db_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.oracle.com))) SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; PROD 1 SYSMAN_PWD

Apr 5, 2010 8:28:36 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 1

Apr 5, 2010 8:28:36 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: /opt/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil: %s_perlBin%/perl: not found

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms