1 2 Previous Next 19 Replies Latest reply on Jan 3, 2011 4:06 PM by axlrose Go to original post
      • 15. Re: Error when starting up dbconsole
        user222828
        Yeah I change the sids when I check the status and all 5 state that they are not running but I can connect to them fine in my browser.

        I guess my new question is why would the status show as not running when in fact I can connect to them? Also when the status states it's not running and I try to start it it says it's already running:
        # /opt/oracle/admin/docwlo1/bdump>sid unator1
        ORACLE_HOME:/opt/oracle/product/10.2/db_1
        ORACLE_SID:unator1
        
        # /opt/oracle/admin/docwlo1/bdump>emctl start dbconsole
        Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
        Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
        https://<hostname>:5505/em/console/aboutApplication
         - An instance of Oracle Enterprise Manager 10g Database Control is already running.
        
        # /opt/oracle/admin/docwlo1/bdump>emctl status dbconsole
        Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
        Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
        https://<hostname>:5505/em/console/aboutApplication
        Oracle Enterprise Manager 10g is not running.
        ------------------------------------------------------------------
        Edited by: Jamie CC on Dec 1, 2009 8:44 AM
        • 16. Re: Error when starting up dbconsole
          740068
          There are 3 different processes... 2 are related to dbconsole directly... which makes the web interface available. If you only kill the java instance process (21764) it will get recreated with another pid. If you can't stop the dbconsole, you also have to kill the parent to make the web interface inaccessible (21739). The other process is the emagent. I too am having a similar problem, will post as a separate post.

          $ cd $ORACLE_HOME
          $ cd SLC-ORCL-1_SLCAEPROD1 *(DB Instance)
          $ ls
          emctl.pid oraInst.loc sysman
          $ cat emctl.pid
          21764
          $ ps -ef | grep 21764
          oracle 21764 21739 0 09:45 ? 00:00:18 /data1/oracle/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME
          =/data1/oracle/oracle/product/10.2.0/db_1 -Doracle.home=/data1/oracle/oracle/product/10.2.0/db_1/oc4j -Doracle.oc4j.localhome=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1/sysman -DEM
          STATE=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/data1/oracle/orac
          le/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/config/jazn.xml -Djava.security.policy=/data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/con
          fig/java2.policy -Djava.security.properties=/data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1
          -Dsysman.md5password=true -Drepapi.oracle.home=/data1/oracle/oracle/product/10.2.0/db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/h
          ome/oc4j.jar -config /data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/config/server.xml
          oracle 32765 32045 0 12:45 pts/1 00:00:00 grep 21764
          $
          $
          $ ps -ef | grep 21739
          oracle 300 32045 0 12:45 pts/1 00:00:00 grep 21739
          oracle 21739 1 0 09:45 ? 00:00:00 /data1/oracle/oracle/product/10.2.0/db_1/perl/bin/perl /data1/oracle/oracle/product10.2.0/db_1/bin/emwd.pl dbconsole /data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1/sysman/log/emdb.nohup

          oracle 21764 21739 0 09:45 ? 00:00:18 /data1/oracle/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME
          =/data1/oracle/oracle/product/10.2.0/db_1 -Doracle.home=/data1/oracle/oracle/product/10.2.0/db_1/oc4j -Doracle.oc4j.localhome=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1/sysman -DEM
          STATE=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1 -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/config/jazn.xml
          -Djava.security.policy=/data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/config/java2.policy -Djava.security.properties=/data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1
          -Dsysman.md5password=true -Drepapi.oracle.home=/data1/oracle/oracle/product/10.2.0/db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/home/oc4j.jar -config /data1/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_SLC-ORCL-1_SLCAEPROD1/config/server.xml

          oracle 24182 21739 0 09:47 ? 00:00:02 /data1/oracle/oracle/product/10.2.0/db_1/bin/emagent
          • 17. Re: Error when starting up dbconsole
            740068
            I'm having a similarly related issue, except I can start the dbconsole "without issue", but I can't stop the console.... with not much to go on.

            $ emctl status agent
            TZ set to US/Eastern
            Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
            Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
            ---------------------------------------------------------------
            Agent Version : 10.1.0.5.1
            OMS Version : 10.1.0.5.0
            Protocol Version : 10.1.0.2.0
            Agent Home : /data1/oracle/oracle/product/10.2.0/db_1/SLC-ORCL-1_SLCAEPROD1
            Agent binaries : /data1/oracle/oracle/product/10.2.0/db_1
            Agent Process ID : 24182
            Parent Process ID : 21739
            Agent URL : http://SLC-ORCL-1:3938/emd/main
            Started at : 2009-12-09 09:47:30
            Started by user : oracle
            Last Reload : 2009-12-09 09:47:30
            Last successful upload : 2009-12-09 12:58:30
            Total Megabytes of XML files uploaded so far : 1.23
            Number of XML files pending upload : 0
            Size of XML files pending upload(MB) : 0.00
            Available disk space on upload filesystem : 63.46%
            ---------------------------------------------------------------
            Agent is Running and Ready
            $
            $
            $ emctl stop dbconsole
            TZ set to US/Eastern
            Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
            Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
            http://SLC-ORCL-1:1158/em/console/aboutApplication
            Stopping Oracle Enterprise Manager 10g Database Control ...
            --- Failed to shutdown DBConsole Gracefully ---
            failed.

            $ ls -ltr
            total 12196
            -rw-r----- 1 oracle oinstall 0 Sep 11 16:33 emdctl.log
            -rw-r----- 1 oracle oinstall 0 Sep 11 16:35 emagentfetchlet.log
            drwxrwx--- 2 oracle dba 4096 Sep 11 16:41 nmcSLCAEPROD11521
            -rw-r----- 1 oracle oinstall 17228 Dec 2 16:00 emagent_perl.trc
            -rw-r----- 1 oracle oinstall 0 Dec 8 13:26 emtgtctl.log
            -rw-r----- 1 oracle oinstall 432 Dec 8 13:26 emtgtctl.trc
            -rw-r----- 1 oracle oinstall 4793735 Dec 9 09:41 emoms.trc_20091209
            -rw-r----- 1 oracle oinstall 4793735 Dec 9 09:41 emoms.log_20091209
            -rw-r----- 1 oracle oinstall 2803084 Dec 9 09:43 emdb.nohup_20091209
            -rw-r----- 1 oracle oinstall 2378 Dec 9 09:46 emoms.trc
            -rw-r----- 1 oracle oinstall 2378 Dec 9 09:46 emoms.log
            -rw-r----- 1 oracle oinstall 4080 Dec 9 09:47 emdctl.trc
            -rw-r----- 1 oracle oinstall 269 Dec 9 09:47 emdb.nohup.lr
            -rw-r----- 1 oracle oinstall 945 Dec 9 09:47 emagent.trc
            -rw-r----- 1 oracle oinstall 193 Dec 9 09:47 emagent.log
            -rw-r----- 1 oracle oinstall 1253 Dec 9 09:47 emagentfetchlet.trc
            -rw-r----- 1 oracle oinstall 459 Dec 9 13:01 emdb.nohup


            $ less emdb.nohup
            ----- Wed Dec 9 09:45:59 2009::DBConsole. Monitoring Agent+Console -----
            ----- Wed Dec 9 09:45:59 2009::Console Launched with PID 21764 at time Wed Dec 9 09:45:59 2009 -----
            09/12/09 09:46:04 Oracle Application Server Containers for J2EE 10g (9.0.4.1.0) initialized
            ----- Wed Dec 9 09:47:30 2009::Agent Launched with PID 24182 at time Wed Dec 9 09:47:30 2009 -----
            (pid=24182): starting emagent version 10.1.0.5.1
            09/12/09 13:01:10 Authentication Failed


            I have gone so far as to recreate the repository. emd.properties has the correct TZ setting... although 1 of the targets (oracle_emrep) timezone is "off"... which I believe is the cause of my primary problem... I can't see any sql statements in "Top Activity"

            SELECT target_name, target_type, timezone_delta, timezone_region
            FROM sysman.mgmt_targets
            ;

            "TARGET_NAME"      "TARGET_TYPE"      "TIMEZONE_DELTA"     "TIMEZONE_REGION"
            "Management Services and Repository"     "oracle_emrep"     "-360"     "-06:00"
            "SLC-ORCL-1:3938"     "oracle_emd"     "-300"     "US/Eastern"
            "SLC-ORCL-1"     "host"     "-300"     "US/Eastern"
            "SLCAEPROD1"     "oracle_database"     "-300"     "US/Eastern"
            "LISTENER_SLC-ORCL-1"     "oracle_listener"     "-300"     "US/Eastern"
            • 18. Re: Error when starting up dbconsole
              740068
              The solution to my issue was to restart the DB instance
              • 19. Re: Error when starting up dbconsole
                axlrose
                I got the exactly same issue
                1 2 Previous Next