Re: APEX in Oracle XE stopped working

On Wed, 15 Nov 2006 01:37:45 -0800, Martin wrote:  

> The database is running fine - no problems there. Just this problem
> with apex.

Generic response here ...

A few possible external factors may stop APEX from running. You don't specify which Linux you are using and that could make a difference as the distros have some differences.

Most common issue is that some form of firewall is running, perhaps re-enabled as a result of a patch. If you are running a Fedora, then look at SELinux settings.

Another challenge is DHCP ... the listener & tns lock in the host name at install time and DHCP can change the host's IP so that does not always get resolved consistently. Similar symptoms from DNS-based resolution instead of /etc/hosts

I've also noted that people use other tools, like JBoss or TomCat, on the same ports as the Apex port.

What happens when you try going against the localhost instead of the installed host? http://localhost:8080/apex

Since you can access using sqlplus, what happens when you

exec sethttpport(8091);

in sqlplus as a DBA, and then try http to that port in your browser.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.