Apache and Oracle

Oracle's HTTP server comes with

• Oracle 9i R2 (or higher)
• Oracle 9i Application Server Rel 1 (1.0.2.2) (or higher)
• Oracle 10g Database companion CD release 1 or 2

When I tried to manually start the webserver, I found that I had to make two minor changes so as to be able to start the webserver:

In the httpd.conf file, I needed to change the line that read
SetEnv PERL5LIB "/home/oracle/OraHome1/Apache/perl/lib/5.00503:/home/oracle/OraHome1/Apache/perl/lib/site_perl/5.005"
to
SetEnv PERL5LIB "/home/oracle/OraHome1/Apache/perl/lib/site_perl/5.005"
to make it work.

Apparently, some part of the Oracle-Apache installation requires the environment variable WV_GATEWAY_CFG to be set:

export WV_GATEWAY_CFG=$ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

Actually, this variable is set by the apachectl script (found in $ORACLE_HOME/Apache/Apache/bin). apachectl is meant to start the webserver.

Also, DISPLAY neeeds to be set, although I have no idea what for.

export DISPLAY=localhost:0.0

Go to the directory $ORACLE_HOME/Apache/Apache/bin and do a

./httpd -f$ORACLEHOME/Apache/Apache/conf/httpd.conf

• $ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf
  This file must include the oracle_apache.conf file.
• $ORACLE_HOME/sqlplus/admin/isqplus.conf
  This file must be included by the oracle_apache.conf file if the webserver is to be used for isqlplus.
• $ORACLE_HOME/Apache/Apache/conf/httpd.conf
• $ORACLE_HOME/Apache/Apache/logs/error_log
  The file where Apache writes its errors to. Can be changed in the httpd.conf file.