1 2 Previous Next 29 Replies Latest reply: Jun 10, 2013 12:47 PM by clcarter RSS

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

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