9 Replies Latest reply: Feb 2, 2013 3:57 AM by Venkateshj RSS

    EM Console Problem

    Venkateshj
      Hi all,

      I installed Oracle 11g R@ in windows 7 PC and created database as OR, for this OR database EMCONSOLE is created & working Fine..

      Then again i created another database in the same PC as database name as RO, for that it is throwing a error as below while creation from DBCA.

      Enterprise Manager configuration failed due to the following error-
      Listener is not up or database service is not registered with it.
      start the listener & registe database service and run EM configuration Assistant again.

      Refer to the log file at E:\app\ORACLE\cfgtoollogs\dbca\emconfig.log for more details.

      Log file:-
      CONFIG: Successfully submitted dbms job
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.ParamsManager getParam
      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE-PC)(PORT=1831)))(CONNECT_DATA=(SERVICE_NAME=ro)))
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.ParamsManager getHost
      CONFIG: Host having instnces running for database ro : ORACLE-PC
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.ParamsManager setParam
      CONFIG: Setting param: REP_DB_RUNNING_HOST value: ORACLE-PC
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.ParamsManager getRepDbPort
      CONFIG: Listener Port: 1831
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
      CONFIG: isLocalConnectionRequired: true
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
      Jan 31, 2013 11:26:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine connecting with SID: RO, oracleHome: E:\app\ORACLE\product\11.2.0\dbhome_1, and user: SYSMAN
      Jan 31, 2013 11:26:35 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine created successfully and connected
      Jan 31, 2013 11:26:35 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

           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.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)
           at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
           at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
           at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)
           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)
      Jan 31, 2013 11:26:35 PM 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 E:\app\ORACLE\cfgtoollogs\dbca\ro\emConfig.log for more details.
      Jan 31, 2013 11:26:35 PM 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.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)
           at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
           at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
           at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)
           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)
      Jan 31, 2013 11:26:35 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
      CONFIG: Restoring oracle.installer.oui_loc to E:\app\ORACLE\product\11.2.0\dbhome_1\oui



      Please solve my problem, to open the EM Console's of Both Databases..


      Thanks in advance...
        • 1. Re: EM Console Problem
          sb92075
          EM can only be configured for single DB per system.

          EM is NOT required for any DB operation or support.
          • 2. Re: EM Console Problem
            Venkateshj
            sb92075 wrote:
            EM can only be configured for single DB per system.

            EM is NOT required for any DB operation or support.
            I want to create tablespaces from EMCONSOLE and also other options to do...

            Suggest a solution how can i create EM Console for RO database?
            • 3. Re: EM Console Problem
              sb92075
              Venkateshj wrote:
              sb92075 wrote:
              EM can only be configured for single DB per system.

              EM is NOT required for any DB operation or support.
              I want to create tablespaces from EMCONSOLE and also other options to do...

              Suggest a solution how can i create EM Console for RO database?
              remove repository for OR database then create new repository for RO database.

              Rinse, Lather, Repeat


              or just use sqlplus to manage both DB's concurrently.
              • 4. Re: EM Console Problem
                EdStevens
                sb92075 wrote:
                EM can only be configured for single DB per system.
                Clarification:

                A single "instance" of dbcontrol can only be configured for a single DB. However, it is quite possible (and documented in an MOS note) to configure multiple instances of dbcontrol on a given host. Each instance of dbcontrol runs on its own https port and manages the one single database for which it was configured.
                EM is NOT required for any DB operation or support.
                • 5. Re: EM Console Problem
                  EdStevens
                  Venkateshj wrote:
                  Hi all,

                  I installed Oracle 11g R@ in windows 7 PC and created database as OR, for this OR database EMCONSOLE is created & working Fine..

                  Then again i created another database in the same PC as database name as RO, for that it is throwing a error as below while creation from DBCA.

                  Enterprise Manager configuration failed due to the following error-
                  Listener is not up or database service is not registered with it.
                  start the listener & registe database service and run EM configuration Assistant again.

                  Refer to the log file at E:\app\ORACLE\cfgtoollogs\dbca\emconfig.log for more details.
                  <snip>

                  Please solve my problem, to open the EM Console's of Both Databases..


                  Thanks in advance...
                  I'd say that first error message was pretty self-explanatory. What have you done to address it?
                  • 6. Re: EM Console Problem
                    Venkateshj
                    EdStevens wrote:
                    Venkateshj wrote:
                    Hi all,

                    I installed Oracle 11g R@ in windows 7 PC and created database as OR, for this OR database EMCONSOLE is created & working Fine..

                    Then again i created another database in the same PC as database name as RO, for that it is throwing a error as below while creation from DBCA.

                    Enterprise Manager configuration failed due to the following error-
                    Listener is not up or database service is not registered with it.
                    start the listener & registe database service and run EM configuration Assistant again.

                    Refer to the log file at E:\app\ORACLE\cfgtoollogs\dbca\emconfig.log for more details.
                    <snip>

                    Please solve my problem, to open the EM Console's of Both Databases..


                    Thanks in advance...
                    I'd say that first error message was pretty self-explanatory. What have you done to address it?
                    I Created Listener Service file & then started the listener by Net configuration Assistant..

                    After Listenet Status up also am unable to create the EM Console Repository sir...
                    • 7. Re: EM Console Problem
                      EdStevens
                      Venkateshj wrote:
                      EdStevens wrote:
                      Venkateshj wrote:
                      Hi all,

                      I installed Oracle 11g R@ in windows 7 PC and created database as OR, for this OR database EMCONSOLE is created & working Fine..

                      Then again i created another database in the same PC as database name as RO, for that it is throwing a error as below while creation from DBCA.

                      Enterprise Manager configuration failed due to the following error-
                      Listener is not up or database service is not registered with it.
                      start the listener & registe database service and run EM configuration Assistant again.

                      Refer to the log file at E:\app\ORACLE\cfgtoollogs\dbca\emconfig.log for more details.
                      <snip>

                      Please solve my problem, to open the EM Console's of Both Databases..


                      Thanks in advance...
                      I'd say that first error message was pretty self-explanatory. What have you done to address it?
                      I Created Listener Service file & then started the listener by Net configuration Assistant..

                      After Listenet Status up also am unable to create the EM Console Repository sir...
                      "Listener is not up *or database service is not registered with it*."

                      Open a command prompt.
                      Copy this command and paste it into the command prompt:
                      lsnrctl status
                      Press enter.
                      Copy the entire session and paste into your next post.
                      • 8. Re: EM Console Problem
                        Osama_Mustafa
                        After Listener Status up also am unable to create the EM Console Repository sir...
                        How is that ? Post Logs
                        • 9. Re: EM Console Problem
                          Venkateshj
                          Osama_mustafa wrote:
                          After Listener Status up also am unable to create the EM Console Repository sir...
                          How is that ? Post Logs
                                                                  Am created new listener & registered to databases.. Now working fine of both EM Console's..


                          Thank u sir..