This discussion is archived
4 Replies Latest reply: Feb 18, 2013 5:07 AM by 991699 RSS

http://127.0.0.1:8080/apex/f?p=4950  | TNS-12541: TNS:no listener

987677 Newbie
Currently Being Moderated
Hello,

I know this question is asked frequently; but I have been trying for days now and I can't seem to get my Oracle Database Express Edition 11g Release 2 for Windows x32 database to connect. I keep getting this error- http://127.0.0.1:8080/apex/f?p=495 when I try IE or Firefox.

Here are my specs and I realllllly appreciate anyone who can help me. When I check the command shell it seems that the listener isn't working... or at least that is my best guess. I have also tried to uninstall and reinstall and still no luck.


My computer is a Mac OS and i am using Oracle's VirtualBox VM- I allocated 2048 Mib or 2GB
I installed Win7 32bit - which can connect to the internet fine
I downloaded the Express version of Oracle -Oracle Database Express Edition 11g Release 2 for Windows x32
I have the firewall turned off
all SSL and TLS protocols enabled.
I do have Xampp installed on my computer but it is not activated.


This is what I get when I put lsnrctl status in the command shell.

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=4242)(PORT=1521)))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
32-bit Windows Error:51: Unknown error

Edited by: 984674 on Jan 28, 2013 6:52 PM
  • 1. Re: http://127.0.0.1:8080/apex/f?p=4950  | TNS-12541: TNS:no listener
    Paul M. Oracle ACE
    Currently Being Moderated
    it seems that the listener isn't working...
    Yes, from your post it seems so. Did you try to start it (lsnrctl start) ? Also, is the database running ? did you try to connect from Sql command line ?
  • 2. Re: http://127.0.0.1:8080/apex/f?p=4950  | TNS-12541: TNS:no listener
    Udo Guru
    Currently Being Moderated
    Hello, and welcome to the OTN forums,
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=4242)(PORT=1521)))
    In addition to Paul's question concerning your database service being up, are you sure +4242+ is your actual host name and it is resolvable? The error message for the second listening endpoint indicates it's not:
    TNS-00513: Destination host unreachable
    The error message for the first one aims at Paul's suggestion:
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    It seems there is no database process running that would "attach" to your IPC listening endpoint.
    In addition to
    lsnrctl start
    please also post the output of
    sqlplus / as sysdba
    SQL> startup
    -Udo
  • 3. Re: http://127.0.0.1:8080/apex/f?p=4950  | TNS-12541: TNS:no listener
    987677 Newbie
    Currently Being Moderated
    Hello,

    I uninstalled my windows and reinstalled renaming my computer to admin instead of 4242. I believe it could not be all numbers.

    Either way this seemed to work !!!!!


    Thank you for your help.
  • 4. Re: http://127.0.0.1:8080/apex/f?p=4950  | TNS-12541: TNS:no listener
    991699 Newbie
    Currently Being Moderated
    My login to this http://127.0.0.1:8080/apex was working fine until I changed the computer name
    after several tries and restats of computer............. I renamed my computer back to original name
    now its working fine

    Errors i found when i changed the original computer name ( not username )

    Primavera Login Error: User Already logedin and Listener servise was not working ( on force stat massage was: started and terminated suddenly


    second error was at the " http://127.0.0.1:8080/apex" login show no login window

    So if you or your administrator has renamed your computer rename it back to original name !!!!!!!!

    Edited by: 988696 on Feb 18, 2013 5:06 AM

Legend

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