We promptly looked into the issue and checked for any mistakes in configuration or the setup. We scourged the oracle technology forums for an answer to this problem. There were a few solutions that were mentioned on the site. We tried all of them that we found on OTN but could not figure out the problem. The oracle service was running fine but we could not connect to it through the web admin interface.
Some of the solutions mentioned on the site included
a) Reinstalling Oracle XE - we did not want to go this way as we would not learn anything by doing this
b) Reloading settings by running
/etc/init.d/oracle-xe force-reload. We did this but didn't change anythingc) We tried the
exec dbms_xdb.sethttpport(8080) strategy but it was throwing errors.On checking
lsnrctl status we were getting the following errors
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
We figured that the the listener was not able to start and bind to the port and had something to do with network settings. We checked out /etc/hostname and /etc/hosts and checked with the local ip. What had happened was that the local static IP was changed manually after the Oracle XE installation but the hosts file did not reflect this change. We corrected this error and did a
/etc/init.d/oracle-xe force-reload and presto everything was working. We were no longer getting the "Could not connect to http://localhost:8080/apex, Page not found" error anymore. We verified that the listeners were running by running
lsnrctl status which gave us the correct response which should look like belowConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 1-DEC-2008 17:22:06
Uptime 0 days 1 hr. 12 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
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...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully


Comments
Help on Same Problem
jugal thakkar (not verified) wrote on November 21, 2012 - 23:14I am not Getting Oracle Home Page...
http://127.0.0.1:8080/apex/f?p=4950
As I am Java Developer and Don't Know Oracle Much....
I have tried so Many Solutions On the same....
AND you have posted solution for the same....
I don't know where to post the following that you have given in your Solution....Please Help me On the same...
/etc/init.d/oracle-xe force-reload
for doing this how can I do....?
I have a Win7 Ultimate. The
Anonymous (not verified) wrote on July 9, 2012 - 02:38I have a Win7 Ultimate. The same situation.
Thanks...
Ankur (not verified) wrote on April 24, 2012 - 23:15It really worked... thnx a lot...
http://127.0.0.1:8080/apex [Error]
Anonymous (not verified) wrote on March 7, 2012 - 16:34I am Not able to access "http://127.0.0.1:8080/apex" but I am able to access "http://192.168.1.23:8080/apex" and "http://127.0.0.1:8080".
Whenever I try to access "http://127.0.0.1:8080/apex" this url then I am getting error:
The webpage cannot be found HTTP 400
Most likely causes:
•There might be a typing error in the address.
•If you clicked on a link, it may be out of date.
What you can try:
Retype the address.
Go back to the previous page.
Go to and look for the information you want.
and bla-bla....
Please help me...:(
error 127.0.0.1:8080/apex
Anonymous (not verified) wrote on January 9, 2012 - 04:51how to run the "/etc/init.d/oracle-xe force-reload' and in where?
and also my account is lock, don't know how to unlock it.
I am a new student in SQL. Please help.
doubt
ananya (not verified) wrote on November 24, 2011 - 19:57i have download oracle 10g and it worked for some day but now it showing error as "oracle initialization or shutdown in progree". i cant get wat the error would be??What will be the error?what i have to do further to get that back..please help me
how to solve 127.0.0.1:8080/apex
Simple & easy dude (not verified) wrote on November 23, 2011 - 10:48go to run and execute command services.msc then try to start manually oracleserviceXE, oraleExeclrAgent, oraleExeTnsListener thats it.
just give a try for login.
have fun :)
Thanks.
Anonymous (not verified) wrote on January 14, 2012 - 22:06thank a lot... ur suggestion was really helpful..:)
Thanks
Murali (not verified) wrote on September 28, 2011 - 19:22Thanks a lot. Your solution is awesome. It works perfectly fine. I tried the same command oracle -xe force -reload
Once again thanks a ton for your solution!!!
Getting same error but only
Anonymous (not verified) wrote on August 31, 2011 - 00:19Getting same error but only on Windows XP
Getting same error but only on Windows XP
In Firefox, it says could not connect..
Getting same error but only
Anonymous (not verified) wrote on August 31, 2011 - 00:18Getting same error but only on Windows XP
Getting same error but only on Windows XP
In Firefox, it says could not connect..
Unbeliaveable
AnonymousInnerClass (not verified) wrote on August 20, 2011 - 08:45I had this same problem twice. The first time, I've just reinstalled the database. Them, some days after, the page stopped working again with no reason. No network changes occurred, since this DB is installed in my laptop at my house, a one machine LAN. Issuing etc/init.d/oracle-xe force-reload saved my day.
It's awesome this thread is old and the problem still exists. I'm running Ubuntu 10 with last updates.
Apex Error
Jimmie (not verified) wrote on July 6, 2011 - 23:05I have noticed the same problem on my installation. The system works well when I am connected to a LAN but doesn't work when I use my laptop alone. Trying to figure out what the issue could be..any help is welcome :)
Thank You :-)
Dario (not verified) wrote on May 13, 2011 - 16:47Perfect post!
It helped me to fix my issue, thank You!
Thank you for giving me a solution for windows
Upendra Yadav (not verified) wrote on March 26, 2011 - 18:14Thanks a lot to all of you. You do a best help to me.
this is ony one solution --- that you provide.
Good luck ... keep it up...
Great Solution
Helmut198 (not verified) wrote on January 12, 2011 - 23:20Thanks a lot for this Solution, works fine !!!
thanks
wad (not verified) wrote on September 3, 2010 - 08:22its work.
I just fix file for /etc/hostname and /etc/hosts and than force-reload
i have installed oracle-xe
GANESH KAMATH (not verified) wrote on September 3, 2010 - 06:44i have installed oracle-xe 10.2.0.1.1.0.0_i386.deb onto my ubuntu10.04 64 bit pc edition.After installing and configuring i could open the home page as well as create a new db account.However after a restart, i could not open the home page and an error on the Mozilla browser as cannot access http127.0.0.1.8080/apex was display on the web browser(Mozilla fire fox3.6) .please help me..
same problem
jyo (not verified) wrote on August 2, 2010 - 00:21even if i,have the same problem
install of oracle but home page is not displaying
thanq
Ajay Kumar (not verified) wrote on July 22, 2010 - 23:31Thanks a lot for the help
How do I correct this error in windows?
Anonymous (not verified) wrote on April 11, 2010 - 20:08You fixed the problem in linux. But how do you fix the problem in windows. I want to understand this! Please send me detailed information. what should my host file look like?
That's the answer
Anoryat (not verified) wrote on April 3, 2010 - 05:56Many Thanks !!!
lsnrctl start does not work, but /etc/init.d/oracle-xe force-reload is the solution.
Running Oracle XE in a Debian Lenny box.
I had this problem after my
Anonymous (not verified) wrote on March 24, 2010 - 15:34I had this problem after my PC has been migrated to an other domain so the host name had to be changed. The solution was just to edit the two files (that are under C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN on my machine):
listener.ora
tnsnames.ora
In these files I changed the value of HOST (. in the following example):
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = .)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
How do you edit these
Anonymous (not verified) wrote on April 20, 2012 - 18:13How do you edit these files???
Similar to 127.0.0.1:8080/apex problem
Muni Koti (not verified) wrote on January 3, 2010 - 09:27But that problem was solved by u r very gd solution
thanks a lot
Solution to apex
Kn (not verified) wrote on November 25, 2009 - 10:48HI, I have a similar problem with not being able to connect (it only worked the first time I installed it). However, I'm a rookie at this and i have no idea how to correct the issue with etc/init.d/oracle-xe force-reload. How am I to correct or add the etc/init.d/oracle-xe force-reload ? I do not see a hostname with an IP address with it either. Could you help me with this?
thank you
-K.N
Some troubleshooting tips
webmaster wrote on November 25, 2009 - 18:46I don't have a system in house to test this. But here are some troubleshooting tips
a) Make sure your oracle server is running - use ps/top
b) Make sure your server is listening on the ports - use lsnrctl
c) Make sure your ports are open - use telnet
To restart oracle open a terminal and type in
/etc/init.d/oracle-xe force-reload
Anoop John
Team Zyxware
Thanks!!!
Charles (not verified) wrote on October 16, 2009 - 15:26I had this problem after I had changed the listener port on my XE database from the default of 1521 to another port (for security reasons). I was able to access the database via SQL*plus but not the Apex web interface. After a lot of searching I found this blog post, tried /etc/init.d/oracle-xe force-reload and it worked.
A thousand thankyous!
Getting same error but only on Windows XP
Anonymous (not verified) wrote on February 13, 2009 - 22:05Getting same error but only on Windows XP
In Firefox, it says could not connect..
thanks
Stop Database, Start Database
george herson (not verified) wrote on June 16, 2011 - 03:38Everything (e.g., lsnrctl status) looked good but browsing returned "This webpage is not available" until Stop and Start Database.
racle XE - Solution to 'cannot access http://127.0.0.1:8080/apex
Terry (not verified) wrote on January 13, 2009 - 17:51I have the same problem and would like some more information if possible in particular
what is to be changed in the hosts file.
The problem occurred after 2 logons
What happened in the above
webmaster wrote on January 20, 2009 - 23:43What happened in the above case was that the ip of the machine was changed and this was not reflected in the hosts file. The hosts file should have a line with the hostname of the current machine and the IP of the machine