Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013
    Posts
    5

    Unanswered: Unable to connect to Oracle Database Express Edition homepage

    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_F OR_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\netwo rk\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\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\netwo rk\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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Ready, FIRE, Aim!

    Oracle listener gets involved when an Oracle client desires to use SQL*Net to establish a connection to an Oracle database.

    XE use http to communicate with Browser clients!
    No remote client will ever succeed to connect to any host using 127.0.0.1

    It appears that you know enough to be really dangerous & are fearless when it comes to making changes; regardless of the consequences.

    the OS command
    netstat -a
    reports who is using which port for what purpose.

    Consider reformatting the system disk & starting again, again.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2013
    Posts
    5
    Hi Anacedent

    I am not using a remote client, I am connecting to database in the same machine where it has been installed. So, I think I can use localhost or 127.0.0.1, right?
    I have executed command netstat -a and checked that port 8090 is not being used.
    I have tried to change listener.ora name because that was a suggestion I have seen in another post related with problems of connectivity to oracle database express, for the database get re-registered with the listener.
    I am a rooky in oracle so, basically I am applying the suggestions I found in foruns.
    I appreciate if you have more suggestions to find the cause of my problem.
    Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •