Oracle Database Discussions

Hi there,

I installed a fresh 10.2.0.1 (patched with 10.2.0.4) oracle database on Oracle Entreprise linux 5.7, and HTTP server + HTML DB products from the companion CD. Both are located in different home directory:

ODB: $ORACLE_BASE/product/10.2.0/db_1
APEX: $ORACLE_BASE/product/10.2.0/apex

I just discovered that logs files ($APEX/opmn/logs/) have filled up my entire disk this week end. After some googling / digging, I've read that there is a conflict between the ONS services that run for both products on the same port. Opening the configuration files of both products:

+$ODB/opnm/conf/ons.config+
+$APEX/opnm/conf/opnm.xml+ (btw, ons.conf is empty)

I indeed saw that they both use port 6113 as local port and 6200 as remote port. The workaround I've found in variuos places is to either change the port number, or unsuscribe ONS for the database listener (and sometimes both).

Question 1: what is the best solution ? what are the consequences for the database listener in case of unsuscribtion ?

I also saw that opnm.xml in APEX configuration file is making use of the $ORACLE_HOME environment variable, which I define in my /etc/profile as $ORACLE_BASE/product/10.2.0/db_1. So I guess the opnm of APEX is looking at the wrong place... Yet if I change ORACLE_HOME in my /etc/profile, I won't be able to run dbstart upon stgartup, as it is run using ORACLE_HOME in a init.d script...

Question 2: Can someone clarify things up about the exact relationship between oracle database and HTTP server ? How should I deal with ORACLE_HOME environment variable, which one use it and when... ?

Note that I'm completely new to Oracle (and hence APEX).

Thanks in advance!