This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 14, 2013 11:28 PM by 982380 RSS

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

982380 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    "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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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