1 Reply Latest reply: Apr 23, 2013 7:22 AM by Udo RSS

    Unable to access access Database Express Edition homepage

    1000659
      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
          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