This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes  Failed to unlock all EM-related accounts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark " Failed to unlock all EM-related accounts" Watch " Failed to unlock all EM-related accounts" New topic
Author

Failed to unlock all EM-related accounts

rosan samuel
Ranch Hand

Joined: Nov 17, 2010
Posts: 37
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

Java Bee
Wouter Oet
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

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.


"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
rosan samuel
Ranch Hand

Joined: Nov 17, 2010
Posts: 37
Thanks My Friend
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19649
    
  18

Moving to our JDBC forum.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
wood burning stoves
 
subject: Failed to unlock all EM-related accounts
 
Similar Threads
Hibernate issue while loading config file - Caused by: java.lang.OutOfMemoryError: PermGen space
Exception occurred while attempting to acquire a JDBC DataSource from JNDI : Tomcat 7 and Mysql
Why jdk6x is not compatiable with Tomcat7? why jdk7x compiled classes are not working in jdk6x
HTTP status 404 error on page
404 error when application is runned on tomcat server.