This discussion is archived
4 Replies Latest reply: Jan 24, 2013 2:12 AM by Fran RSS

SEVERE: Failed to unlock all EM-related accounts

810816 Newbie
Currently Being Moderated
TEST 11.1.0@server TEST$ emca -config dbcontrol db -repos create

STARTED EMCA at Jan 23, 2013 1:47:18 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: TEST
Listener port number: 1521
Password for SYSMAN user: Email address for notifications (optional): cc@.cc
Invalid email.
Email address for notifications (optional): cc@c.cz
Outgoing Mail (SMTP) server for notifications (optional): cc.cz
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.1.0/dbee_1

Local hostname ................ server
Listener port number ................ 1521
Database SID ................ TEST
Email address for notifications ............... cc@c.cz
Outgoing Mail (SMTP) server for notifications ............... cc.cz

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jan 23, 2013 1:48:34 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/cfgtoollogs/emca/CEPR/e
Jan 23, 2013 1:48:39 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 23, 2013 1:51:39 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at /u01/app/oracle/product/cfgtoollogs/emca/TEST/emca_2013_01_23_
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/.log for more details.

Trace:
-------
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Error executing /u01/app/oracle/product/11.1.0/dbee_1/sysman/admin/scripts/emca/emcaDbUtil /u01/app/oracle/product/11.1.0/dbee_1/perl/lib:/u01/app/oracle/product/11.1.0/dbee_1/perl/lib/site_perl:/u01/app/oracle/product/11.1.0/dbee_1/sysman/admin/scripts:/u01/app/oracle/product/11.1.0/dbee_1/bin: /u01/app/oracle/product/11.1.0/dbee_1/perl/bin/perl /u01/app/oracle/product/11.1.0/dbee_1/sysman/admin/scripts/emca/emcaDbUtil.pl /u01/app/oracle/product/11.1.0/dbee_1 TEST 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; 1 SYSMAN_PWD
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Failed to unlock mgmt_view account
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at /u01/app/oracle/product/cfgtoollogs/emca/TEST/emca_2013_01_23_13_47_18.log for more details.
Jan 23, 2013 1:51:41 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:335)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)



Any idea?

Thank you.
REgards,
Tom

Edited by: 807813 on Jan 23, 2013 5:06 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points