Creating DBConsole via EMCA Fails With "ORA-28007: the password cannot be reused" and "Failed to unlock all EM related accounts" (Doc ID 336629.1)

Last updated on FEBRUARY 17, 2013

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Feb-2013***

Symptoms

Running Enterprise Manager Configuration Assistant (EMCA) to create dbconsole after database upgrade to 10.2.0.1.0, appears to create the repository but the when attempting to generate the configuration files, a failure is detected.

"Failed to unlock all EM related accounts"

 The following is the corresponding logged error in the emca_<date>_<time>.log:

CONFIG: Unlocking dbsnmp and sysman
Sep 29, 2005 1:17:09 PM oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: ORA-28007: the password cannot be reused
ORA-06512: at line 1
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28007: the password cannot be reused
ORA-06512: at line 1
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1708)
at oracle.sysman.emcp.EMReposConfig.unlockAccounts(EMReposConfig.java:566)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:235)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
Sep 29, 2005 1:17:09 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
Sep 29, 2005 1:17:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at /oracle/product/10.2.0.1/cfgtoollogs/emca/orcl/emca_2005-09-29_01-13-49-PM.log for more details.
Sep 29, 2005 1:17:09 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:239)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)

Other errors that have also been associated with this issue are:

ORA-28002

ORA-28003

Changes

The DEFAULT user profile has been modified.

Manual upgrade to the 10.2.0.1.0 version of the database (see <Note.316889.1>) may bring the existing profile definitions from the original database, including the DEFAULT profile, or profiles may be otherwise different from what the EMCA utility is expecting.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms