5 Replies Latest reply: Nov 18, 2012 6:36 PM by 974875 RSS

    can not connect via URL to Oracle Enterprise Manager

    974780
      At the end of the installation I could connect to Oracle Enterprise Manager via URL http://<ip>:1158/em


      After restarting SLES 11 x64 and configuring oracle the oracle service work proper und are starting with booting the SLES 11 VM / OS.

      So Database, Listener and dbconsole / Enterprise manager are running.

      I can connect the database with SQLPlus and also SQL Developer (in the VM and from outside)


      But i found no way to connect to EM via URL in browser.

      Always the same answer in browser: could not connect to http://<ip>:1158/em .
      Its the same via HTTP and HTTPS.


      Do anybody have a solution to fix that problem?

      Edited by: user7477562 on 17.11.2012 06:13
        • 1. Re: can not connect via URL to Oracle Enterprise Manager
          JohnWatson
          Have you run the most basic diagnostic,
          emctl status dbconsole
          • 2. Re: can not connect via URL to Oracle Enterprise Manager
            974780
            well one questiion before: Do I need to run the apache / oracle http-Server to access Enterprise Manager via Browser?
            (I haven't installed it. and after installing it worked. So i thought I don't need this)


            oracle@VMSLES11x64ORA11x64:~> emctl status dbconsole
            Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
            Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
            https://VMSLES11x64:1158/em/console/aboutApplication
            Oracle Enterprise Manager 11g is not running.
            ------------------------------------------------------------------
            Logs are generated in directory /opt/oracle/database/server/ORADB/VMSLES11x64ORA11x64_ORADB/sysman/log


            But when I start Oracle via   /etc/init.d/oracle start

            I get following messages back:


            #############################################################################
            # Begin of O R A C L E startup section #
            #############################################################################


            SETTINGS start from /etc/sysconfig/oracle
            - Set Kernel Parameters for Oracle: yes
            - Start Oracle Listener: yes
            - Start Oracle Database: yes
            - Start Oracle Webserver: no
            - Start Oracle EManager: yes
            - Start Oracle iSQLPLUS Manager: yes
            - Start Oracle Agent: yes
            - Start Oracle Internet Filesystem: no
            - Start Oracle Directory Manager: no
            Can't find needed file: isqlplusctl - Setting START_ORACLE_DB_ISQLPLUS = no
            Oracle Agent undefinied or not properly set. Please check.


            Setting kernel parameters for Oracle, see file
            /etc/sysconfig/oracle for explanations.

            Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152
            Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256
            Other values: FILE_MAX_KERNEL=6815744 IP_LOCAL_PORT_RANGE=9000 65500
            RMEM_DEFAULT=262144 WMEM_DEFAULT=262144 RMEM_MAX=4194304 WMEM_MAX=1048586 AIO_MAX_SIZE=1048576
            Huge Pages: SHM_GROUP=dba/etc/init.d/oracle: line 357: echo: write error: Invalid argument
            NR_HUGE_PAGES=0
            ULIMIT values: MAX_CORE_FILE_SIZE_SHELL=unlimited
            FILE_MAX_SHELL=65536 PROCESSES_MAX_SHELL=16384

            Checking sysctl.conf to overwrite previous kernel settings...
            sysctl value fs.file-max=6553600 restored.

            Kernel parameters set for Oracle: done


            - Starting Listener... done

            + Starting Database(s)...
            Processing Database instance "ORADB": log file /opt/oracle/database/server/ORADB/startup.log
            Status of Oracle database(s) start: done

            - Starting Apache... unused
            - Starting Application Server... unused
            - Starting Application Server Console... unused
            - Starting Agent... done
            - Starting Enterprise Manager...
            Starting DB Console for ORADB done
            - Starting iSQLPLUS Manager... skipped
            - Starting Oracle Internet Filesystem... unused
            - Starting Oracle Internet Directory... unused

            #############################################################################
            # End of O R A C L E section #
            #############################################################################


            Messages vom oracle status:

            #############################################################################
            # Begin of O R A C L E status section #
            #############################################################################


            Kernel Parameters
            Shared memory: SHMMAX= 3294967296 SHMMNI= 4096 SHMALL= 2097152
            Semaphore values: SEMMSL, SEMMNS, SEMOPM, SEMMNI: 1250 32000 100 256

            Database-Instances
            Instance ORADB is up (autostart: Y)

            TNS-Listener: up

            Web-Server (Apache httpd): down (0 processes)

            Process list for user oracle:
            PID TTY STAT TIME COMMAND
            4738 ? S 0:00 sshd: oracle@notty
            4739 ? Ss 0:00 /usr/lib64/ssh/sftp-server
            4772 ? S 0:00 /opt/oracle/database/server/ORADB/perl/bin/perl /opt/oracle/database/server/ORADB/bin/emwd
            4858 ? Sl 0:01 /opt/oracle/database/server/ORADB/bin/emagent
            10172 ? S 0:00 sshd: oracle@pts/0
            10173 pts/0 Ss 0:00 -bash
            12507 ? Ssl 0:00 /opt/oracle/database/server/ORADB/bin/tnslsnr LISTENER -inherit
            12735 ? Ss 0:00 ora_pmon_ORADB
            12737 ? Ss 0:00 ora_vktm_ORADB
            12741 ? Ss 0:00 ora_gen0_ORADB
            12743 ? Ss 0:00 ora_diag_ORADB
            12745 ? Ss 0:00 ora_dbrm_ORADB
            12747 ? Ss 0:00 ora_psp0_ORADB
            12749 ? Ss 0:00 ora_dia0_ORADB
            12751 ? Ss 0:00 ora_mman_ORADB
            12753 ? Ss 0:00 ora_dbw0_ORADB
            12755 ? Ss 0:00 ora_lgwr_ORADB
            12757 ? Ss 0:00 ora_ckpt_ORADB
            12759 ? Ss 0:00 ora_smon_ORADB
            12761 ? Ss 0:00 ora_reco_ORADB
            12763 ? Ss 0:00 ora_mmon_ORADB
            12765 ? Ss 0:00 ora_mmnl_ORADB
            12767 ? Ss 0:00 ora_d000_ORADB
            12769 ? Ss 0:00 ora_s000_ORADB
            12845 ? Ss 0:00 ora_qmnc_ORADB
            12906 ? Ss 0:00 ora_cjq0_ORADB
            13460 ? Ss 0:00 ora_q000_ORADB
            13462 ? Ss 0:00 ora_q001_ORADB
            14480 ? Ss 0:00 ora_j000_ORADB
            14491 ? Ss 0:00 ora_j001_ORADB
            14498 ? Rl 0:00 /opt/oracle/database/server/ORADB/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:M

            #############################################################################
            # End of O R A C L E section #
            #############################################################################



            and when I try o start oracle enterprise manager via  emctl start dbconsole
            Then the mashine told me that it is already running.

            "...
            VMSLES11x64ORA11x64:/shared/scripts # emctl start dbconsole
            Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
            Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
            https://VMSLES11x64:1158/em/console/aboutApplication
            - An instance of Oracle Enterprise Manager 11g Database Control is already running.
            ..."


            the ps -ef | grep oracle command I get following information back:

            "...
            VMSLES11x64ORA11x64:/shared/scripts # ps -ef | grep oracle
            root 4735 3360 0 13:29 ? 00:00:00 sshd: oracle [priv]
            oracle 4738 4735 0 13:29 ? 00:00:00 sshd: oracle@notty
            oracle 4739 4738 0 13:29 ? 00:00:00 /usr/lib64/ssh/sftp-server
            oracle 4772 1 0 13:29 ? 00:00:00 /opt/oracle/database/server/ORADB/perl/bin/perl /opt/oracle/database/ server/ORADB/bin/emwd.pl dbconsole /opt/oracle/database/server/ORADB/VMSLES11x64ORA11x64_ORADB/sysman/log/emdb.nohup
            oracle 4858 4772 0 13:30 ? 00:00:01 /opt/oracle/database/server/ORADB/bin/emagent
            root 10169 3360 0 13:33 ? 00:00:00 sshd: oracle [priv]
            oracle 10172 10169 0 13:33 ? 00:00:00 sshd: oracle@pts/0
            oracle 10173 10172 0 13:33 pts/0 00:00:00 -bash
            oracle 12507 1 0 13:37 ? 00:00:00 /opt/oracle/database/server/ORADB/bin/tnslsnr LISTENER -inherit
            oracle 12735 1 0 13:37 ? 00:00:00 ora_pmon_ORADB
            oracle 12737 1 0 13:37 ? 00:00:00 ora_vktm_ORADB
            oracle 12741 1 0 13:37 ? 00:00:00 ora_gen0_ORADB
            oracle 12743 1 0 13:37 ? 00:00:00 ora_diag_ORADB
            oracle 12745 1 0 13:37 ? 00:00:00 ora_dbrm_ORADB
            oracle 12747 1 0 13:37 ? 00:00:00 ora_psp0_ORADB
            oracle 12749 1 0 13:37 ? 00:00:00 ora_dia0_ORADB
            oracle 12751 1 0 13:37 ? 00:00:00 ora_mman_ORADB
            oracle 12753 1 0 13:37 ? 00:00:00 ora_dbw0_ORADB
            oracle 12755 1 0 13:37 ? 00:00:00 ora_lgwr_ORADB
            oracle 12757 1 0 13:37 ? 00:00:00 ora_ckpt_ORADB
            oracle 12759 1 0 13:37 ? 00:00:00 ora_smon_ORADB
            oracle 12761 1 0 13:37 ? 00:00:00 ora_reco_ORADB
            oracle 12763 1 0 13:37 ? 00:00:00 ora_mmon_ORADB
            oracle 12765 1 0 13:37 ? 00:00:00 ora_mmnl_ORADB
            oracle 12767 1 0 13:37 ? 00:00:00 ora_d000_ORADB
            oracle 12769 1 0 13:37 ? 00:00:00 ora_s000_ORADB
            oracle 12845 1 0 13:37 ? 00:00:00 ora_qmnc_ORADB
            oracle 12906 1 0 13:37 ? 00:00:00 ora_cjq0_ORADB
            oracle 13460 1 0 13:37 ? 00:00:00 ora_q000_ORADB
            oracle 13462 1 0 13:37 ? 00:00:00 ora_q001_ORADB
            oracle 15665 1 0 13:42 ? 00:00:00 ora_smco_ORADB
            oracle 15696 1 0 13:42 ? 00:00:00 ora_w000_ORADB
            oracle 16519 1 0 13:43 ? 00:00:00 ora_j000_ORADB
            oracle 16522 1 0 13:43 ? 00:00:00 ora_j001_ORADB
            oracle 16542 4772 99 13:43 ? 00:00:03 /opt/oracle/database/server/ORADB/jdk/bin/java -server -Xmx384M -XX:M axPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/database/server/ORADB -Dora cle.home=/opt/oracle/database/server/ORADB/oc4j -Doracle.oc4j.localhome=/opt/oracle/database/server/ORADB/VMSLES11x64 ORA11x64_ORADB/sysman -DEMSTATE=/opt/oracle/database/server/ORADB/VMSLES11x64ORA11x64_ORADB -Doracle.j2ee.dont.use.me mory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/opt/oracle/database/server/O RADB/oc4j/j2ee/OC4J_DBConsole_VMSLES11x64ORA11x64_ORADB/config/jazn.xml -Djava.security.policy=/opt/oracle/database/s erver/ORADB/oc4j/j2ee/OC4J_DBConsole_VMSLES11x64ORA11x64_ORADB/config/java2.policy -Djavax.net.ssl.KeyStore=/opt/orac le/database/server/ORADB/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/opt/oracle/database/server/ORAD B/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/database/server/ORADB/VMSLES11x64ORA11x64_ORADB -Ds ysman.md5password=true -Drepapi.oracle.home=/opt/oracle/database/server/ORADB -Ddisable.checkForUpdate=true -Doracle. sysman.ccr.ocmSDK.websvc.keystore=/opt/oracle/database/server/ORADB/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGen ericFonts=true -Djava.awt.headless=true -jar /opt/oracle/database/server/ORADB/oc4j/j2ee/home/oc4j.jar -config /opt/o racle/database/server/ORADB/oc4j/j2ee/OC4J_DBConsole_VMSLES11x64ORA11x64_ORADB/config/server.xml
            root 16568 11383 0 13:43 pts/0 00:00:00 grep oracle
            ..."

            Edited by: user7477562 on 17.11.2012 06:53

            Edited by: user7477562 on 17.11.2012 06:55
            • 3. Re: can not connect via URL to Oracle Enterprise Manager
              JohnWatson
              You need to starty the console:
              emctl start dbconsole
              Edited by: JohnWatson on Nov 17, 2012 3:02 PM
              Sorry, I misread that you have already tried that. You need to kill any java or perl processes, and then start the console.
              The process PIDs are 4772 and 16542.
              And in future, don't try to start things through init.d scripts, it usually doesn't work properly.
              • 4. Re: can not connect via URL to Oracle Enterprise Manager
                Osama_Mustafa
                well one questiion before: Do I need to run the apache / oracle http-Server to access Enterprise Manager via Browser?
                (I haven't installed it. and after installing it worked. So i thought I don't need this)
                
                oracle@VMSLES11x64ORA11x64:~> emctl status dbconsole
                Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
                https://VMSLES11x64:1158/em/console/aboutApplication
                Oracle Enterprise Manager 11g is not running.
                Logs are generated in directory /opt/oracle/database/server/ORADB/VMSLES11x64ORA11x64_ORADB/sysman/log
                Use
                emctl start dbconsole
                • 5. Re: can not connect via URL to Oracle Enterprise Manager
                  974875
                  After solving some other problems with hostname | ORACLE_HOSTNAME I stopped automatic starting Oracle via init.d/oracle-Script.

                  Now I start it with following commands:


                       su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"

                       su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"

                       su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl start dbconsole"

                  To start Oracle like this, Enterprise Manager could be connected in Browser via URL.


                  Wow. A long journey to this solution.... :-) ...


                  Thanks to you for the tips and informations and help!

                  Edited by: 971872 on 18.11.2012 16:35