This discussion is archived
0 Replies Latest reply: Apr 9, 2013 1:38 PM by 697720 RSS

EM isn't created

697720 Newbie
Currently Being Moderated
I installed Oracle 11gR2 on windows 7 professional. But on database configuration installation on approximately 80%. I get the following message on a dialog box:

Enterprise manager configuration failed due to the following error-
Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again
Refer to the log file at C:\app\spiros\cfgtoollogs\dbca\orcl\emConfig.log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\app\spiros\product\11.2.0\dbhome_1\bin\emca script

Some of the lines the above log shows are:

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
     at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1066)
     at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
     at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
     at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
     at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
     at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
     at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
     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)


CONFIG: ORA-28000: the account is locked

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
     at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1066)
     at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
     at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
     at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1685)
     at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
     at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
     at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
     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)

CONFIG: ORA-12541: TNS:no listener

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
     at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
     at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1001)
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:346)
     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)
Apr 9, 2013 5:20:46 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at C:\app\spiros\cfgtoollogs\dbca\orcl\emConfig.log for more details.
Apr 9, 2013 5:20:46 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
     at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
     at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1001)
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:346)
     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)
Apr 9, 2013 5:20:46 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to C:\app\spiros\product\11.2.0\dbhome_1\oui



I carried out every single step in http://blog.mclaughlinsoftware.com/2011/12/29/oracle-11gr2-on-windows-7/
and http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/

but i get the following message instead:

INFO: Creating the EM repository (this may take a while) ...
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at C:\app\spiros\cfgtoollogs\emca\orcl\emca_repos_cr
eate_<date>.log for more details.
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at C:\app\spiros\cfgtoollogs\emca\orcl\emca_2013_04_09_23_
18_39.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\spiros\cfgtoollogs\emca\orcl\emca_2013_04_09_23_18_39.log for more details.

C:\app\spiros\cfgtoollogs\emca\orcl\emca_2013_04_09_23_18_39.log
--------------------------------------------------------------------------------------------------
CONFIG: ORA-00955: name is already used by an existing object

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00955: name is already used by an existing object

     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)
     at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
     at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)
     at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511)
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229)
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
     at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
     at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
     at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
     at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at C:\app\spiros\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at C:\app\spiros\cfgtoollogs\emca\orcl\emca_2013_04_09_23_18_39.log for more details.
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:241)
     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
     at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
     at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
     at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
     at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
Apr 9, 2013 11:22:00 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to C:\app\spiros\product\11.2.0\dbhome_1\oui

DHCP is disabled and I edited host file like this:

# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost
::1 localhost
192.168.1.4 bilisuoi

An other fact is that when i run :

C:\Users\spiros>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 09-APR-2013 23:37
:07

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 09-APR-2013 23:02:06
Uptime 0 days 0 hr. 35 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\spiros\product\11.2.0\dbhome_1\network\admin\li
stener.ora
Listener Log File c:\app\spiros\diag\tnslsnr\BILISUOI\listener\alert\log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bilisuoi)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\Users\spiros>

The above shows off.


What could be the solution to my problem?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points