modPerl and Oracle...

Previously, we were using an older version of the Oracle client on a Linux machine.

We're now trying to recreate the server setup on a VMWare virtual machine that is using Oracle 10.2.0. This server has Apache running with modPerl connecting to Oracle.

The error message we were getting at first was "ERROR OCIEnvNlsCreate (check ORACLE_HOME, permissions, NLS settings etc." or something like that.

The first action that we took was to make the apache user a part of the oinstall group. This made the perl scripts work with Oracle, but not under modPerl.

In order to make script work under modPerl, we added a BEGIN {} group at the start of a startup file that was loaded by the httpd.conf file. Here's the instruction :

BEGIN {
$ENV{ORACLE_HOME} = ‘’;
}

That fixed the modPerl problem.