1 2 Previous Next 18 Replies Latest reply: Jan 15, 2013 1:28 AM by 982380 RSS

    unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32

    982380
      i have installed OracleXE112_Win32. Installation was smooth.
      but when i click the "Get Started With Oracle Database 11g Express Edition" it opens a url (http://127.0.0.1:8080/apex/f?p=4950) in browser. But the browser shows following message.
      "Unable to connect
      Firefox can't establish a connection to the server at 127.0.0.1:8080.
      The site could be temporarily unavailable or too busy. Try again in a few
      moments.
      If you are unable to load any pages, check your computer's network
      connection.
      If your computer or network is protected by a firewall or proxy, make sure
      that Firefox is permitted to access the Web."

      I googled a lot. but could not found any thing helpfull.
        • 1. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
          AndyPol
          Restart your computer. If you will this problem after restart searche errors in oracle alert log.
          • 2. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
            982380
            I have restarted PC many times but no effect.
            • 3. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
              clcarter
              Installer may not have finished its chores.

              Quickest way to find out ... is the database running? Can you connect to the database? In a command box (Start/Run/cmd)

              sqlplus
              connect system
              ... Password ...
              ... Connected.

              Or you might get "connected to idle instance". Make sure the .dbf data files got created by the installer- system.dbf, sysaux.dbf ... look in the oraclexe folder for them. Try search in WinExplorer. For *dbf files.

              If the datafiles aren't on the host follow the install documentation, the deinstall steps. Try the installer again, after verifying the install requirements. Those are in the install docs too: http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm



              You sound have about 5 or 6 *DBF files in your drive:\oraclexe folder.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
              • 4. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                982380
                i done and sharing results in the following image. Please check.
                [http://i46.tinypic.com/wi6ow3.jpg]
                • 6. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                  clcarter
                  Ok so the *DBF files are on the host.

                  And the database is running, as shown by a 'connect system ...' output.

                  Next item, how about a lsnrctl status output?
                  lsnrctl status
                  ...
                  ... Endpoints:
                  ... port=1521...
                  ... port=8080...
                  Got to have the port=8080 one or the apex pages will not work.
                  • 7. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                    982380
                    check it here
                    [http://i45.tinypic.com/dgjlhc.jpg]
                    • 8. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                      clcarter
                      Ok ... listener is not running. So start it ... and that may have to be done with a "run as Administrator" command box, maybe.
                      lsnrctl start
                      ...
                      lsnrctl status
                      And a tip ... if you left click the command prompt icon (upper left corner) go to Properties, on the Options tab, there is a checkbox for Quick Edit. Turning that on and using the mouse to highlight, <enter> to copy text to clipboard is much easier than posting .jpg pics. imho.

                      Edited by: clcarter on Jan 8, 2013 1:11 PM
                      add quickedit note
                      • 9. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                        982380
                        C:\Users\Salman>lsnrctl start

                        LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 09-JAN-2013 19:53
                        :34

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

                        Starting tnslsnr: please wait...

                        TNS-12560: TNS:protocol adapter error
                        TNS-00530: Protocol adapter error


                        C:\Users\Salman>lsnrctl status

                        LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 09-JAN-2013 19:54
                        :14

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

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                        TNS-12541: TNS:no listener
                        TNS-12560: TNS:protocol adapter error
                        TNS-00511: No listener
                        32-bit Windows Error: 2: No such file or directory
                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=softlicious)(PORT=1521))
                        )
                        TNS-12545: Connect failed because target host or object does not exist
                        TNS-12560: TNS:protocol adapter error
                        TNS-00515: Connect failed because target host or object does not exist
                        32-bit Windows Error: 1004: Unknown error
                        • 10. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                          orafad
                          979377 wrote:
                          C:\Users\Salman>lsnrctl start
                          To begin with, you would need to run that from a elevated admin's command prompt (Run as administrator...).

                          Or you could start the TNSListener service from local services panel.
                          • 11. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                            982380
                            Even i have run it as admin but no effect
                            [http://i48.tinypic.com/2i1m341.jpg]
                            • 12. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                              clcarter
                              "connect failed because target host or object does not exist".
                              So the listener doesn't like your host= setting, something isn't completely correct with the network client setup on the box.

                              Verify your IP address. Verify the hostname. In a command box:
                              hostname
                              ... <hostname>
                              ipconfig /all
                              ... host name . . .: <hostname>
                              ... ethernet adapter Local Area Connection . . . ...
                              ... ip address . . .: n.n.n.n
                              ping <hostname>
                              ... -> reply from n.n.n.n
                              ping n.n.n.n
                              ... -> reply from n.n.n.n
                              If all that "looks good" (but that is doubtful, obviously lsnrctl disagrees with that assessment) try changing your listener.ora HOST= to the "any IP" address of 0.0.0.0.

                              But first make sure the listener service is not running- if it is, stop it (Services applet, Start/run/services.msc) and edit your listener.ora file and (in the admin cmd box) lsnrctl start or use the services applet and click the Start. Check lsnrctl status. After a lsnrctl status shows a good result, use a sqlplus, connect system, and do an `alter system register`. After that the two Endpoints:... should show in lsnrctl status.

                              notepad <drive:...XE _HOME folder>\network\admin\listener.ora
                               ... (HOST=<incorrect hostname>)
                                # change to 
                               ... (HOST=0.0.0.0) 
                              • 13. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                                orafad
                                979377 wrote:
                                Even i have run it as admin but no effect
                                Look again. It had effect.
                                If you had posted a copy-paste of command window output, I could have quoted the important parts.

                                As the "target host" is in error, instead of trying to fix the parameter file manually, I suggest you:

                                stop listener (via command or services)
                                rename listener.ora (to, say, listener.ora.renamed)
                                start listener.

                                This should let Oracle pick up on actual settings. (if there is an underlying network config problem, it will be evident)

                                Run another lsnrctl stat command and post complete command line session (copy-paste).
                                • 14. Re: unable to access http://127.0.0.1:8080/apex/f?p=4950 OracleXE112_Win32
                                  982380
                                  Microsoft Windows [Version 6.1.7600]
                                  Copyright (c) 2009 Microsoft Corporation. All rights reserved.

                                  C:\Windows\system32>stop listener
                                  'stop' is not recognized as an internal or external command,
                                  operable program or batch file.

                                  C:\Windows\system32>rename listener.ora
                                  The syntax of the command is incorrect.

                                  C:\Windows\system32>start listener
                                  The system cannot find the file listener.

                                  C:\Windows\system32>
                                  1 2 Previous Next