This discussion is archived
0 Replies Latest reply: Jul 10, 2013 1:06 PM by a20318ce-4ac4-45c6-9099-3e92f9cc07e3 RSS

can't connect to apex homepage

a20318ce-4ac4-45c6-9099-3e92f9cc07e3 Newbie
Currently Being Moderated

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

Legend

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