aspose file tools*
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
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: 19697
    
  20

Moving to our JDBC forum.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Failed to unlock all EM-related accounts