Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Failed to unlock all EM-related accounts

 
rosan samuel
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am having Problem with Oracle 11 g R2 version installation.
i am using single , customized installation , but the log says this problem. ( Failed to unlock all EM-related accounts)
i attached logs and screen shots, could anyone help me to solve this?

ul 1, 2011 6:21:24 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Arguments passed C:\app\rosansamuel\product\11.2.0\dbhome_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=**snip**)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=otbr11ga))) **snip** 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; otbr11ga 1 SYSMAN_PWD

Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=**snip**)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=otbr11ga))) in home C:\app\rosansamuel\product\11.2.0\dbhome_1 with user "**snip**" role "**snip**".

Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Couldn't connect to the db - ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at C:\app\rosansamuel\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl line 106, <STDIN> line 2.

Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Error executing CMD /C C:\app\rosansamuel\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "C:\app\rosansamuel\product\11.2.0\dbhome_1\sysman\admin\scripts;C:\app\rosansamuel\product\11.2.0\dbhome_1\bin;" C:/app/rosansamuel/product/11.2.0/dbhome_1/perl/bin\perl.exe C:\app\rosansamuel\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl C:\app\rosansamuel\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=**snip**)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=otbr11ga)))" **snip** 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; otbr11ga 1 SYSMAN_PWD
Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Failed to unlock mgmt_view account
Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at C:\app\rosansamuel\cfgtoollogs\dbca\otbr11ga\emConfig.log for more details.
Jul 1, 2011 6:21:24 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:349)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
Jul 1, 2011 6:21:24 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to C:\app\rosansamuel\product\11.2.0\dbhome_1\oui
 
Wouter Oet
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've removed the host name, username and role since this may increase the chance of a successful security breach. Since I'm no oracle expert you might want to check for more sensitive data.
 
rosan samuel
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks My Friend
 
Rob Spoor
Sheriff
Pie
Posts: 20552
57
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our JDBC forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic