APEX in Oracle XE stopped working altogether
We are running Oracle XE on Linux for prototyping a project and have
been using the rather useful web based apex utility for minor
administration and reporting jobs. It now seems to be broken and I
cannot work out why.
Usually we tap in the url http://machine.domain:8080/apex and the web
interface starts but now we get
Not found
The requested URL /apex/apex was not found on this server
Note the /apex/apex (which I did not type in).
We are running
Fedora Core release 5 (Bordeaux)
Oracle 10.2.0.1.0
We don't have any firewall running (./iptables status shows "Firewall is stopped".) and SELinux is disabled (/etc/sysconfig/selinux says "SELINUX=disabled").
We are using DHCP but the MAC address is tied to the IP address and DNS and reverse DNS lookups show the same values they did when we installed Oracle. The tnsnames.ora and listener.ora files use the machine's name properly.
The url http://localhost:8080/apex does the same thing. Without the /apex on the end I get the Oracle License Agreement page. When I run lsnrctl info I can see:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machine.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
The URL http://localhost:8080/i shows a huge list of gifs, css files and directories.
A wget shows what I think might be a redirect:
$ wget -S http://localhost:8080/apex
--15:50:31-- http://localhost:8080/apex
=> `apex'
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:8080... connected.
HTTP request sent, awaiting response...
HTTP/1.1 302 Found
Server: Oracle XML DB/Oracle Database
Location: /apex/apex
Connection: close
Location: /apex/apex [following]
--15:50:31-- http://localhost:8080/apex/apex
=> `apex'
Connecting to localhost|127.0.0.1|:8080... connected.
HTTP request sent, awaiting response...
HTTP/1.1 404 Not found
Server: Oracle XML DB/Oracle Database
Content-Type: text/html
Connection: close
15:50:31 ERROR 404: Not found.
If you have any ideas how to make apex work again I'd love to hear them.
Thanks
Martin