0 Replies Latest reply: Jul 10, 2013 3:06 PM by alan_shiers RSS

    can't connect to apex homepage

    alan_shiers

      hi there,

       

      Downloaded Oracle Database Express Edition but I'm unable to connect to the home page via browser using http://localhost:8080/apex.

       

      When I perform the following commands:

       

      SQL> conn / as sysdba
      SQL> select status from v$instance;

       

      I get:

       

      STATUS

      ______

      OPEN

       

      The results of running command lsnrctl status are:

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 10-JUL-2013 12:37
      :57

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
      Start Date                10-JUL-2013 09:02:34
      Uptime                    0 days 3 hr. 35 min. 23 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Default Service           XE
      Listener Parameter File   C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
      Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\Alan-PC\listener\a
      lert\log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alan-PC)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alan-PC)(PORT=8080))(Presentation=HT
      TP)(Session=RAW))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "XEXDB" has 1 instance(s).
        Instance "xe", status READY, has 1 handler(s) for this service...
      Service "xe" has 1 instance(s).
        Instance "xe", status READY, has 1 handler(s) for this service...
      The command completed successfully

       

      The results of running command netstat -a -o:

       

      C:\Users\Alan>netstat -a -o

      Active Connections

        Proto  Local Address          Foreign Address        State           PID
        TCP    0.0.0.0:135            Alan-PC:0              LISTENING       776
        TCP    0.0.0.0:445            Alan-PC:0              LISTENING       4
        TCP    0.0.0.0:554            Alan-PC:0              LISTENING       2660
        TCP    0.0.0.0:1025           Alan-PC:0              LISTENING       436
        TCP    0.0.0.0:1026           Alan-PC:0              LISTENING       832
        TCP    0.0.0.0:1027           Alan-PC:0              LISTENING       992
        TCP    0.0.0.0:1028           Alan-PC:0              LISTENING       504
        TCP    0.0.0.0:1032           Alan-PC:0              LISTENING       1672
        TCP    0.0.0.0:1033           Alan-PC:0              LISTENING       488
        TCP    0.0.0.0:1521           Alan-PC:0              LISTENING       1732
        TCP    0.0.0.0:2869           Alan-PC:0              LISTENING       4
        TCP    0.0.0.0:3306           Alan-PC:0              LISTENING       3424
        TCP    0.0.0.0:8080           Alan-PC:0              LISTENING       1732
        TCP    0.0.0.0:10243          Alan-PC:0              LISTENING       4
        TCP    127.0.0.1:1029         Alan-PC:0              LISTENING       1732
        TCP    127.0.0.1:1032         Alan-PC:1243           ESTABLISHED     1672
        TCP    127.0.0.1:1243         Alan-PC:1032           ESTABLISHED     2396
        TCP    127.0.0.1:5939         Alan-PC:0              LISTENING       1836
        TCP    192.168.2.13:139       Alan-PC:0              LISTENING       4
        TCP    192.168.2.13:1900      a23-59-224-63:https    CLOSE_WAIT      5736
        TCP    [::]:135               Alan-PC:0              LISTENING       776
        TCP    [::]:445               Alan-PC:0              LISTENING       4
        TCP    [::]:554               Alan-PC:0              LISTENING       2660
        TCP    [::]:1025              Alan-PC:0              LISTENING       436
        TCP    [::]:1026              Alan-PC:0              LISTENING       832
        TCP    [::]:1027              Alan-PC:0              LISTENING       992
        TCP    [::]:1028              Alan-PC:0              LISTENING       504
        TCP    [::]:1032              Alan-PC:0              LISTENING       1672
        TCP    [::]:1033              Alan-PC:0              LISTENING       488
        TCP    [::]:1521              Alan-PC:0              LISTENING       1732
        TCP    [::]:2869              Alan-PC:0              LISTENING       4
        TCP    [::]:3306              Alan-PC:0              LISTENING       3424
        TCP    [::]:8080              Alan-PC:0              LISTENING       1732
        TCP    [::]:10243             Alan-PC:0              LISTENING       4
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1031  Alan-PC:1521           ESTABLISHED
           1672
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1090  Alan-PC:1091           ESTABLISHED
           1672
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1091  Alan-PC:1090           ESTABLISHED
           1732
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1092  Alan-PC:1093           ESTABLISHED
           1672
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1093  Alan-PC:1092           ESTABLISHED
           1732
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1521  Alan-PC:1031           ESTABLISHED
           1732
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:1919  Alan-PC:8080           FIN_WAIT_2
           5928
        TCP    [fe80::8d6f:e8b2:9e8a:e855%10]:8080  Alan-PC:1919           CLOSE_WAIT
           1732

       

      I see a reference to port 8080 but I don't know if it is really listening on localhost = 127.0.0.1.

      When I go into Windows Services it does say OracleServiceXE  started and

      OracleXETNSListener started.

       

      I don't know where to go from here.

       

      Please advise.

       

      Alan