10 Replies Latest reply: Jan 24, 2013 8:55 AM by Osama_Mustafa RSS

    SEVERE: Failed to unlock all EM-related accounts

    969765
      Hi,

      I created a post there but I put it in this section where comming more experts.
      SEVERE: Failed to unlock all EM-related accounts

      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