1 2 3 4 Previous Next 50 Replies Latest reply on Mar 7, 2008 7:42 PM by Madrid Go to original post
      • 15. Re: emctl dbconsole not starting
        523455
        As per the metalink doc the path should be same as I suggested earlier

        $ORACLE_HOME\host_SID\sysman\config\emd.properties

        EM is not finding the path , as it is indicating in the error , so change the path.
        • 16. Re: emctl dbconsole not starting
          620899
          Hi Aman
          Sorry I got offline,
          Ok let me try what you said, then I will come back to you.

          Regards

          Suman
          • 17. Re: emctl dbconsole not starting
            Aman....
            Hi Suman,
            Why to say sorry for being offline?We all need rest.No issues!
            Ok let me try what you said, then I will come back to you.
            Ok.
            Aman....
            • 18. Re: emctl dbconsole not starting
              620899
              Hi,
              Yhose commands are not working, may be as I am using WinXP P.
              I am using
              --------------------------------------
              C:\>emca -r

              STARTED EMCA at Thu Feb 21 17:33:49 GMT+03:00 2008
              Enter the following information about the database to be configured
              Listener port number: 1521
              Database SID: orcl
              Service name: orcl
              Email address for notification: roy
              Email gateway for notification: mail
              Password for dbsnmp:
              Password for sysman:
              Password for sys:

              -----------------------------------------------------------------

              You have specified the following settings

              Database ORACLE_HOME ................ C:\oracle\product\10.1.0\Db_1
              Enterprise Manager ORACLE_HOME ................ C:\oracle\product\10.1.0\Db_1

              Database host name ................ suman
              Listener port number ................ 1521
              Database SID ................ orcl
              Service name ................ orcl
              Email address for notification ............... roy
              Email gateway for notification ............... mail

              -----------------------------------------------------------------
              Do you wish to continue? [yes/no]: yes
              DBConsole is already configured for the database orcl
              Would you like to re-configure DBConsole for the specified database? [yes/no]:
              es
              Make sure that DBConsole has been shutdown
              When you are ready to continue, press <Enter>

              Feb 21, 2008 5:34:21 PM oracle.sysman.emcp.EMConfig updateReposVars
              INFO: Updating file C:\oracle\product\10.1.0\Db_1\sysman\emdrep\config\reposito
              y.variables ...
              Feb 21, 2008 5:34:22 PM oracle.sysman.emcp.EMConfig stopOMS
              INFO: Stopping the DBConsole ...
              Feb 21, 2008 5:34:22 PM oracle.sysman.emcp.EMConfig addPortEntries
              INFO: Updating file C:\oracle\product\10.1.0\Db_1\install\portlist.ini ...
              Feb 21, 2008 5:34:22 PM oracle.sysman.emcp.EMConfig updateEmdProps
              INFO: Updating file C:\oracle\product\10.1.0\Db_1\sysman\config\emd.properties
              ..
              Feb 21, 2008 5:34:23 PM oracle.sysman.emcp.ParamsManager getLocalListener
              WARNING: Error retrieving listener for suman
              oracle.sysman.emcp.exception.EMConfigException: <Error CONTEXT="NoListener" >
              No listener found in "C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora"
              which is listening on port "1521"
              </Error>

              at oracle.sysman.emcp.util.ListenerUtil.getListenerTarget(ListenerUtil.
              ava:175)
              at oracle.sysman.emcp.ParamsManager.getLocalListener(ParamsManager.java
              324)
              at oracle.sysman.emcp.EMConfig.updateTargets(EMConfig.java:2729)
              at oracle.sysman.emcp.EMConfig.updateConfigFiles(EMConfig.java:1355)
              at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:407)
              at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.ja
              a:678)
              at oracle.sysman.emcp.EMConfigAssistant.performSetup(EMConfigAssistant.
              ava:627)
              at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.ja
              a:332)
              at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:172

              Feb 21, 2008 5:34:23 PM oracle.sysman.emcp.EMConfig updateConfigFiles
              INFO: targets.xml file is updated successfully
              Feb 21, 2008 5:34:23 PM oracle.sysman.emcp.EMConfig updateEmomsProps
              INFO: Updating file C:\oracle\product\10.1.0\Db_1\sysman\config\emoms.propertie
              ...
              Feb 21, 2008 5:34:23 PM oracle.sysman.emcp.EMConfig updateConfigFiles
              INFO: emoms.properties file is updated successfully
              Feb 21, 2008 5:34:25 PM oracle.sysman.emcp.EMConfig startOMS
              INFO: Starting the DBConsole ...
              Feb 21, 2008 5:34:25 PM oracle.sysman.emcp.EMConfig perform
              SEVERE: Error starting DBConsole. DBConsole could not be started successfully
              Could not complete the configuration. Refer to the log file for details

              C:\>
              --------------------------------------
              ...and it is not working

              Regards
              Suman
              • 19. Re: emctl dbconsole not starting
                Aman....
                Suman,
                Yhose commands are not working, may be as I am using WinXP P.
                Win XP may have tons of issues but it certainly doesnt stop commands from working.
                WARNING: Error retrieving listener for suman
                oracle.sysman.emcp.exception.EMConfigException: <Error CONTEXT="NoListener" >
                No listener found in "C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora"
                which is listening on port "1521"
                </Error>

                Thats what I could find in the first glance of the output.Is your listener is running on the machine where you are running these commands?
                Post the results of lsnrctl status and lsnrctl services
                Aman....
                • 20. Re: emctl dbconsole not starting
                  620899
                  Hi Aman,
                  These are the Listener output....
                  --------------------------
                  C:\>lsnrctl status

                  LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2008 17:52
                  :12

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias LISTENER
                  Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
                  ction
                  Start Date 21-FEB-2008 17:27:53
                  Uptime 0 days 0 hr. 24 min. 19 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File C:\oracle\product\10.1.0\Db_1\network\admin\listener.o
                  ra
                  Listener Log File C:\oracle\product\10.1.0\Db_1\network\log\listener.log

                  Message 1415 not found; product=NETWORK; facility=TNS
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=1521)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=8080))(Presentation=HTTP
                  )(Session=RAW))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=2100))(Presentation=FTP)
                  (Session=RAW))
                  Services Summary...
                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  The command completed successfully

                  C:\>
                  --------------------------

                  C:\>lsnrctl services

                  LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2008 17:54
                  :32

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                  Services Summary...
                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  Message 1412 not found; product=NETWORK; facility=TNS

                  DEDICATED established:0 refused:0
                  LOCAL SERVER
                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  Message 1412 not found; product=NETWORK; facility=TNS

                  Message 1417 not found; product=NETWORK; facility=TNS

                  LOCAL SERVER
                  Message 1411 not found; product=NETWORK; facility=TNS

                  Message 1408 not found; product=NETWORK; facility=TNS

                  Message 1412 not found; product=NETWORK; facility=TNS

                  Message 1413 not found; product=NETWORK; facility=TNS

                  DISPATCHER <machine: SUMAN, pid: 2444>
                  (ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=1038))
                  The command completed successfully

                  C:\>
                  ----------------------------------------

                  Thanks
                  Suman
                  • 21. Re: emctl dbconsole not starting
                    620899
                    Hi Aman,
                    These are the Listener output....
                    --------------------------
                    C:\>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2008 17:52
                    :12

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

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
                    ction
                    Start Date 21-FEB-2008 17:27:53
                    Uptime 0 days 0 hr. 24 min. 19 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File C:\oracle\product\10.1.0\Db_1\network\admin\listener.o
                    ra
                    Listener Log File C:\oracle\product\10.1.0\Db_1\network\log\listener.log

                    Message 1415 not found; product=NETWORK; facility=TNS
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=1521)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=8080))(Presentation=HTTP
                    )(Session=RAW))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=2100))(Presentation=FTP)
                    (Session=RAW))
                    Services Summary...
                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    The command completed successfully

                    C:\>
                    --------------------------

                    C:\>lsnrctl services

                    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2008 17:54
                    :32

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

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                    Services Summary...
                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    Message 1412 not found; product=NETWORK; facility=TNS

                    DEDICATED established:0 refused:0
                    LOCAL SERVER
                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    Message 1412 not found; product=NETWORK; facility=TNS

                    Message 1417 not found; product=NETWORK; facility=TNS

                    LOCAL SERVER
                    Message 1411 not found; product=NETWORK; facility=TNS

                    Message 1408 not found; product=NETWORK; facility=TNS

                    Message 1412 not found; product=NETWORK; facility=TNS

                    Message 1413 not found; product=NETWORK; facility=TNS

                    DISPATCHER <machine: SUMAN, pid: 2444>
                    (ADDRESS=(PROTOCOL=tcp)(HOST=suman)(PORT=1038))
                    The command completed successfully

                    C:\>
                    ----------------------------------------

                    Thanks
                    Suman
                    • 22. Re: emctl dbconsole not starting
                      Aman....
                      Hi Suman,
                      Well I guess your listener is really messed up.Wasit working fine in the past?What I suggest is that you reconfigure your listener using net manager tool.You will find this in the configuration tool in your start menu Oracle item.It has to be up and running before anything else can work.
                      Aman....
                      • 23. Re: emctl dbconsole not starting
                        620899
                        Hi Aman,
                        Thanks for your responses. Yes me also thinking to do that but my DBCA and Net manager is also not opening.
                        I am thinking to deinstall Oracle and install it again at last.

                        Regards

                        Suman
                        • 24. Re: emctl dbconsole not starting
                          Aman....
                          Hmm well if you are going to do installation than I shalll just suggest that take a cold backup of your database so that next time you can use this db without losing data.If it was a testing db than just go for the fresh installation.
                          Aman....
                          • 25. Re: emctl dbconsole not starting
                            Aman....
                            Just out of curosity ,what was teh error with DBCA and net manager?
                            Aman....
                            • 26. Re: emctl dbconsole not starting
                              620899
                              Hi Aman
                              This is my testDB luckily, I have tried to drop the repos and re-create instead of going deinstallation but not gone through.

                              here is the DBCA and NETCA error....

                              C:\>dbca
                              Exception in thread "main" java.lang.VerifyError: (class: oracle/sysman/assistan
                              ts/util/NetworkUtils, method: getOneLocalListenerProtocolAddress signature: (Lja
                              va/lang/String;Ljava/lang/String;)Loracle/net/config/AddressConfig;) Incompatibl
                              e argument to function
                              at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.jav
                              a:246)
                              at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:606)
                              at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:200)
                              at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHo
                              st.java:54)
                              at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:149)
                              at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:91)
                              at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:169)

                              C:\>netca
                              Oracle Net Services Configuration:
                              Exception in thread "main" java.util.MissingResourceException: Can't find resour
                              ce for bundle oracle.net.ca.mesg.NetCASR, key StandAloneNSNCreate
                              at java.util.ResourceBundle.getObject(ResourceBundle.java:314)
                              at java.util.ResourceBundle.getString(ResourceBundle.java:274)
                              at oracle.net.ca.NetStrings.getString(NetStrings.java:70)
                              at oracle.net.ca.CAPanelNetServiceNameStandalone.<init>(CAPanelNetServic
                              eNameStandalone.java:30)
                              at oracle.net.ca.NetCA.init(NetCA.java:621)
                              at oracle.net.ca.NetCA.<init>(NetCA.java:265)
                              at oracle.net.ca.NetCA.main(NetCA.java:165)

                              I am unable to understand the problem, if you can pl. let me know.

                              Regards

                              Suman
                              • 27. Re: emctl dbconsole not starting
                                Aman....
                                Hi Suman,
                                These are java errors.There are multiple reasons for it.May be the class paths are incorrect,jdbc drivers sre old,file names and class paths are not in synch etc etc.As you mentioned this is a testdb so I suggest you simply deinstall and reinstall it.That would be the best and safest option:-).
                                Aman....
                                • 28. Re: emctl dbconsole not starting
                                  Madrid
                                  Let's start it over. The very first error message was due to a missconfiguration, the missing path mentioned at the beginning of the thread was because when you configure the EM while you are connected to the network then a directory is created under the oracle home with a name composed of the hostname plus the instance name, if you are connected to the network with an assigned ip then the hostname is the name of your machine, either domain qualified or single, but once you unplug from the network, the name implicitly becomes localhost, so it won't match with the created directory. Either way this configuration is not stable and you would require to reconfigure the repository and fix your IP address with a loopaback adapter.

                                  Taking a look at the last errors I realize the PATH environment variable is just mixed with other things, either you have another oracle home installed on the same host or your PATH environment variable is not properly pointing to your actual ORACLE_HOME.

                                  Now let's fix it.

                                  Create a loopback adapter and declare a fixed ip address for it at the loopback adapter's properties. Then declare the hostname at the windows hosts file and associate this name with the newly declared IP address for the loopback adapter.

                                  Once you have your IP fixed, next step is to reconfigure the repository. First make sure the PATH environment variable properly points to the bin directory at the ORACLE_HOME of your current oracle installation. Next issue the emca sequence of commands to deconfigure, drop and recreate your repository.

                                  * set oracle_sid=YourInstanceName
                                  * emctl stop dbconsole
                                  * emca -deconfig dbcontrol db
                                  * emca -repos recreate
                                  * emca -config dbcontrol db

                                  And make sure your listener is up and running.



                                  http://hrivera99.blogspot.com
                                  • 29. Re: emctl dbconsole not starting
                                    620899
                                    Hi Aman,
                                    Ok let me try otherwise that is the only solution

                                    Regards

                                    Suman