0 Replies Latest reply: Apr 9, 2013 3:38 PM by 697720 RSS

    EM isn't created

    697720
      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?