Re: APEX in Oracle XE stopped working

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Wed, 15 Nov 2006 17:46:37 GMT
Message-Id: <pan.2006.11.15.17.46.36.369687@gmail.com>

On Wed, 15 Nov 2006 16:00:56 +0000, Martin J. Evans wrote:

> HansF wrote:

>> 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.

>
> Fedora Core release 5 (Bordeaux)
>
> Oracle 10.2.0.1.0
>

Thanks. Fedora series is notable for the infernal SELinux interfereing with Oracle operations. However, you have verified that SELinux is disabled.

>> 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

>
> Argh, did not know that. This box is DHCP, currently running with
> 192.168.0.87 and named x.easysoft.local but I cannot absolutely
> guarantee it was exactly the same when oracle was installed although we
> do tie mac addresses to IP addresses and this one is tied.
>
> Do you know where the "listener and tns lock in the host name at install
> time"?
>

$ORACLE_HOME/network/admin ... the listeer.ora and tnsnames.ora files.

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

>
> This demonstrates a redirect I think:
>
> As I said above, without the /apex it shows the oracle license so oracle
> is listening.

Yup. Sorry , I'd glossed over the previous replies and missed that one.

This states, in no uncertain terms, that the apex listener is managing the intercept properly. That sort-of tells me the port and DHCP stuff is not an issue right now.

Which means that apex itself may have become invalid or corrupt.

http://{host}:8080/i should give a list of directories.

Suggest you register for the Oracle Tech Net (otn) Express database discussion forum and ask there. I haven't spent any time researching an Apex-only reinstall (as my specialty is the XE baseline install), but a few of the others have gone down this path.

Search this forum and the OTN Database-General forum for 'register for XE'

>

>> 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.

>
> identifier 'SETHTTPPORT' must be declared
>

I keep doing that ... it's dbms_xdb.sethttpport()

But ... it's not necessary in this case, as the listener is actualy running properly on the right port.

-- 
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.

Received on Wed Nov 15 2006 - 11:46:37 CST