Re: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user

On Feb 9, 5:02 pm, [email protected] (Joseph Koral) wrote:

> However I came across this thread because I'm getting the same error
> when I attempt to connect while running under mod_perl.  The same code
> (simple test connection) runs fine from a standalone perl script, but
> I get "ORA-24327: need explicit attach before authenticating a user
> (DBD ERROR: OCISessionBegin)" when attempting to connect while running
> under mod_perl.

Replying to myself in case others run into this problem, I found the
solution.  That error message is really a simple "can not connect"
error (same error if you shutdown the listener).  If using
tnsnames.ora (I was), under mod_perl I had to explicitly add the
environment variables to the mod_perl startup.pl script where I
preload the modules (even though they were already set in shell).
Alternatively, I would also expect to be able to set them in the
httpd.conf using PerlSetEnv, but I had tried that earlier to no avail.