This discussion is archived
5 Replies Latest reply: Nov 18, 2012 4:36 PM by 974875 RSS

can not connect via URL to Oracle Enterprise Manager

974780 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    Have you run the most basic diagnostic,
    emctl status dbconsole
  • 2. Re: can not connect via URL to Oracle Enterprise Manager
    974780 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points