This discussion is archived
1 2 Previous Next 29 Replies Latest reply: Jun 10, 2013 10:47 AM by clcarter RSS

Newbie on running Oracle 11g - Windows cannot find http:something

966080 Newbie
Currently Being Moderated
Greetings.

This is my first post here and my first attempt at using an Oracle Database. I need it for simulation of a client's program which uses such a database.

The installation went off without a hitch, far more user-friendly than I'd expect from a Database Installer. The only thing I had to input was a username and password for the SYS and SYSTEM accounts. Otherwise, the installer did everything on its own.

However, after installing the database and double-clicking the "Get Started with Oracle Database 11g Express Edition", I get the following error:

Windows cannot find 'http://127.0.0.1:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again.

Google-ing the error led me here, as well as to several other forums and stuff, but none were that helpful, so I thought I should post with more specific issues and stuff. Top of the list of differences I should note down:

1. Most users are experiencing this error on a 64-bit OS, which I read, isn't officially supported (yet?). I'm using a 32-bit OS - Windows 7.
2. Solutions posted by other members are hit and miss. Some work, and some don't. While I am grateful for any help, I'm afraid I can't risk doing something with less than a 100% chance of working because...
3. Newbie here, as I have stated on the thread title. In addition to this, I'm on my company's laptop - modifying registries and stuff is something I wouldn't want to do here.

With that out of the way, I'd like to ask the obvious: How do I fix this?

Also, why does this happen? I've never encountered such from MS SQL and MySQL.

Thanks.
  • 1. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    963077 wrote:
    Windows cannot find 'http://127.0.0.1:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again.
    This should be very easily fixed by replacing %httpport% with 8080 (or actual port number if different).

    Take a look in the url file that Get Started menu item targets (properties).
  • 2. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    Udo Guru
    Currently Being Moderated
    Hello, and welcome to the OTN forums!
    With that out of the way, I'd like to ask the obvious: How do I fix this?
    This is indeed one of the most frequently answered questions, but I agree the issue seems to be rare on 32bit Windows installations. Do you use a home edition of Windows 7?
    Anyway, in most cases it would be sufficient to replace +%HTTPPORT%+ with +8080+ so your "Get Started"-link would look like
    http://127.0.0.1:8080/apex/f?p=4950
    If this doesn't help, please post the output of the following two commands
    lsnrctl status
    
    sqlplus / as sysdba
    Also, why does this happen? I've never encountered such from MS SQL and MySQL.
    Neither MS SQL nor MySQL do have a web server, do they? ;)

    -Udo
  • 3. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    That was quick, thanks. I use the Windows 7 Ultimate
    And yes, as of this post, I did try changing it into 8080.

    Gone into:
    C:\oraclexe\app\oracle\product\11.2.0\server\
    Get_Started (which is an internet shortcut)
    Right-click -> Properties -> Changed URL into:
    http://127.0.0.1:%HTTPPORT%/apex/f?p=8080

    Posted here step by step in case I missed anything. After doing so and trying it out, it gets me the same error, with the 4950 replaced with an 8080.

    As for this:
    lsnrctl status
    sqlplus / as sysdba

    Which I assume is done in the command prompt, yields me this:
    [Wall of text here]

    C:\Windows\System32>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-OCT-2012 15:46
    :50

    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 - Produ
    ction
    Start Date 04-OCT-2012 14:29:04
    Uptime 0 days 1 hr. 17 min. 47 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\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\arnold-PC\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(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...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully

    C:\Windows\System32>sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 4 15:47:55 2012

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


    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

    SQL> exit
    Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

    C:\Windows\System32>

    On a side note, what are the major differences between SQL / MySQL and a web server? I had assumed up to this point that MS SQL, MySQL and Oracle are doing the exact same thing, just differently.

    Thanks.

    Regards,
    Zack_Falcon
  • 4. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    Udo Guru
    Currently Being Moderated
    http://127.0.0.1:%HTTPPORT%/apex/f?p=8080
    http://127.0.0.1:8080/apex/f?p=4950
    Do you see the difference? ;)

    The output of the two commands looks good, so probably correcting the URL will be sufficient.
    On a side note, what are the major differences between SQL / MySQL and a web server? I had assumed up to this point that MS SQL, MySQL and Oracle are doing the exact same thing, just differently.
    MS SQL and MySQL are database servers, which Oracle Database (obviously) is too. But Oracle Database has Oracle Application Express ("APEX") and comes with its own HTTP (web) server to host it. APEX is a web based development framework to develop database centric applications. It is completely implemented with Oracle Database functionality (tables, stored procedures, etc.), so it "lives" inside the database and doesn't need any additional components, though it is recommended to use the database internal web server for development purposes only.

    -Udo
  • 5. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Right. Saw the difference.
    Replaced URL, correctly, this time.

    What is it supposed to open, anyway?

    Only thing I got was a Google Chrome window saying:
    "Oops! Google Chrome could not connect to 127.0.0.1:8080"

    Thanks.
    - Zack_Falcon
  • 6. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    Udo Guru
    Currently Being Moderated
    What is it supposed to open, anyway?
    It targets at an APEX application bundled with XE that offers basic database management features, i.e. it allows database management through your browser rather than using the command line client.
    "Oops! Google Chrome could not connect to 127.0.0.1:8080"
    Interesting. Do you have any firewall blocking that access? And which IP address is mapped to "arnold-PC"? Try
    ping arnold-PC
    to find out.

    If it's not mapped, try adding it to your local hosts file, usually located in c:\Windows\System32\drivers\etc\ , among the loopback address, e.g.
    127.0.0.1       localhost arnold-PC
    -Udo
  • 7. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    The ping arnold-pc returns only an IPv6 long line of string. I also tried ipconfig, which may be what you're looking for.


    C:\Windows\System32>ping arnold-pc

    Pinging arnold-PC [fe80::fd35:7af2:d5f6:c12b%12] with 32 bytes of data:
    Reply from fe80::fd35:7af2:d5f6:c12b%12: time<1ms
    Reply from fe80::fd35:7af2:d5f6:c12b%12: time<1ms
    Reply from fe80::fd35:7af2:d5f6:c12b%12: time<1ms
    Reply from fe80::fd35:7af2:d5f6:c12b%12: time<1ms

    Ping statistics for fe80::fd35:7af2:d5f6:c12b%12:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
    Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

    C:\Windows\System32>ipconfig

    Windows IP Configuration


    Wireless LAN adapter Wireless Network Connection 2:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :

    Wireless LAN adapter Wireless Network Connection:

    Connection-specific DNS Suffix . : domain.name
    Link-local IPv6 Address . . . . . : fe80::fd35:7af2:d5f6:c12b%12
    IPv4 Address. . . . . . . . . . . : 192.168.2.22
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Default Gateway . . . . . . . . . : 192.168.2.1

    Ethernet adapter Local Area Connection:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :

    Tunnel adapter isatap.{D984D6D9-F780-46BA-B965-659A31B73BF5}:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :

    Tunnel adapter Teredo Tunneling Pseudo-Interface:

    Connection-specific DNS Suffix . :
    IPv6 Address. . . . . . . . . . . : 2001:0:4137:9e76:2858:1159:3f57:fde9
    Link-local IPv6 Address . . . . . : fe80::2858:1159:3f57:fde9%13
    Default Gateway . . . . . . . . . : ::

    Tunnel adapter 6TO4 Adapter:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :

    Tunnel adapter Reusable ISATAP Interface {8B9D18E8-56EC-4BD4-ADC7-62149FD0BF63}:


    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . : domain.name

    Tunnel adapter isatap.{759D18F6-68FC-4B1A-88C8-3B03ED5C7DB8}:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :

    C:\Windows\System32>

    This is what's in the host file:

    # Copyright (c) 1993-2009 Microsoft Corp.
    #
    # This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
    #
    # This file contains the mappings of IP addresses to host names. Each
    # entry should be kept on an individual line. The IP address should
    # be placed in the first column followed by the corresponding host name.
    # The IP address and the host name should be separated by at least one
    # space.
    #
    # Additionally, comments (such as these) may be inserted on individual
    # lines or following the machine name denoted by a '#' symbol.
    #
    # For example:
    #
    # 102.54.94.97 rhino.acme.com # source server
    # 38.25.63.10 x.acme.com # x client host

    # localhost name resolution is handled within DNS itself.
    #     127.0.0.1 localhost
    #     ::1 localhost

    I gather I should add:
    127.0.0.1 localhost arnold-PC
    without the # sign.

    Will this mess with anything networking related?

    Again, thanks.
  • 8. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    963077 wrote:
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(PORT=1521)))
    There's no 8080 listening there.

    So fixing the client/browser side was one step. Now you need something on the server side responding on that port (8080).

    Stop listener. (e.g. OracleXETNSListener service)

    Rename listener.ora, the one listed as Listener Parameter File above.

    Start listener again. Re-run lsnrctl stat command.
  • 9. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    >
    C:\Windows\System32>ping arnold-pc

    Pinging arnold-PC [fe80::fd35:7af2:d5f6:c12b%12] with 32 bytes of data:
    Try
    ping -4 arnold-pc

    To get the IPv4 translation instead.


    Possibly your hosts file needs another line as below, but don't change anything before a problem is established.

    <ip> arnold-pc
  • 10. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    I'm sorry, rename listener.ora to what?

    Also, my IP Address is 192.168.2.22, if that means anything.

    Thanks,

    -Zack_Falcon
  • 11. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    963077 wrote:
    I'm sorry, rename listener.ora to what?
    E.g. to listener.ora_renamed
  • 12. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Right. Stopped the service, renamed the listener.ora file, and restarted the service.

    Re-ran the lsnrctl stat command. Here's what followed:

    C:\Windows\System32>lsnrctl stat

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 08-OCT-2012 09:25
    :59

    Copyright (c) 1991, 2010, 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 11.2.0.2.0 - Produ
    ction
    Start Date 08-OCT-2012 09:25:15
    Uptime 0 days 0 hr. 0 min. 44 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\arnold-PC\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(PORT=1521)))
    Services Summary...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully

    I'm sorry to say, but running the Get Started still doesn't do anything, except display a "Oops! Google Chrome could not connect to 127.0.0.1:8080" message.

    Any other ideas?

    Thanks for the help.

    -Zack_Falcon
  • 13. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    zack_falcon wrote:
    Uptime 0 days 0 hr. 0 min. 44 sec
    Wait a while then lsnrctl stat again. At least 1 min should have passed.

    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(PORT=1521)))
    Services Summary...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully
    I'm sorry to say, but running the Get Started still doesn't do anything,
    That's ok. Per above summaries you have no "8080" endpoint or XDB service registered.

    Endpoint should look something like:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=8080))(Presentation=HTTP)(Session=RAW))

    What do you get from commands below?
    netstat -nao | findstr 1521 | findstr LIST
    
    type %systemroot%\system32\drivers\etc\hosts | findstr /vr ^#
  • 14. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Here's what I got after trying "lsnrctl stat" again:

    C:\Windows\System32>lsnrctl stat

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 09-OCT-2012 09:47
    :51

    Copyright (c) 1991, 2010, 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 11.2.0.2.0 - Produ
    ction
    Start Date 09-OCT-2012 08:50:06
    Uptime 0 days 0 hr. 57 min. 47 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\arnold-PC\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-pc)(PORT=1521)))
    Services Summary...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully


    This is the netstat command:

    C:\Windows\System32>netstat -nao | findstr 1521 | findstr LIST
    TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING 3152
    TCP [::]:1521 [::]:0 LISTENING 3152


    And the last one:

    C:\Windows\System32>type %systemroot%\system32\drivers\etc\hosts | findstr /vr ^
    #


    127.0.0.1 arnold-pc

    C:\Windows\System32>


    Of note is that I've already inserted the following:
    127.0.0.1 arnold-pc
    into the hosts file out of desperation.

    Thanks.

    -Zack_Falcon
1 2 Previous Next

Legend

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