This discussion is archived
1 Reply Latest reply: Apr 23, 2013 5:22 AM by Udo RSS

Unable to access access Database Express Edition homepage

1000659 Newbie
Currently Being Moderated
Hello,

I've installed Oracle Database Express Edition in a machine running windows server standard, 32bit, the application was successfully installed. I've installed it in port 8090 because during installation I was advert that 8080 port was occupied. When I try to access http://127.0.0.1:8090/apex, the webpage is not available.

Executing the command lsnrctl status I can see that there is not an end point to 8090.

I've tried two things: change listener.ora hostname to 0.0.0.0 and change listener.ora name to listener.ora.bak. I restart listener services in both cases.
No sucess. :(
The machine is running Tomcat could this be a reason?

Anyone can help?

Bellow there is the result of "lsnrctl status" before and after rename the listener.ora.

Thank you.

-----Before rename listener.ora---------

C:\Users\Administrator.FASRV01>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-ABR-2013 00:40
:06

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 23-ABR-2013 00:39:15
Uptime 0 days 0 hr. 0 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fasrv01.faleixo.local)(PORT=1521)))
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...
The command completed successfully

-----After rename listener.ora---------

C:\Users\Administrator.FASRV01>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-ABR-2013 00:43
:20

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 23-ABR-2013 00:43:13
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fasrv01.faleixo.local)(PORT=1521)))
The listener supports no services
The command completed successfully
  • 1. Re: Unable to access access Database Express Edition homepage
    Udo Guru
    Currently Being Moderated
    Hello,
    I've installed Oracle Database Express Edition in a machine running windows server standard, 32bit, the application was successfully installed.
    Is there any special reason why you chose XE 10.2 instead of the current 11.2 release?
    The machine is running Tomcat could this be a reason?
    No, since you've changed the port for the database HTTP server to be different from 8080 (probably used by your Tomcat) this won't cause any troubles.
    Bellow there is the result of "lsnrctl status" before and after rename the listener.ora.
    I see two hints in the latter output:
    Uptime 0 days 0 hr. 0 min. 7 sec
    This indicates you ran lsnrctl status pretty fast after starting the listener. It can take up to a minute until the database has registered all listening endpoints. Did you try to connect after at least that amount of time again?
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fasrv01.faleixo.local)(PORT=1521)))
    It seems your machine is actually named "fasrv01.faleixo.local". Are you sure this name can be resolved properly?
    This can be checked by a simple "ping", e. g.
    ping fasrv01.faleixo.local
    Another question would be whether your database service has been started at all. Could you post the output of
    sqlplus / as sysdba
    startup
    -Udo

Legend

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