EMCA Fails With "Failed To Unlock MGMT_VIEW Account"
(Doc ID 1081481.1)
Last updated on NOVEMBER 16, 2022
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.
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=<HOSTNAME.DOMAIN>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.<DOMAIN>))) 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
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=<HOSTNAME.DOMAIN>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.<DOMAIN>))) 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |