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

On Feb 1, 10:58 am, [email protected] (Alexander Saip) wrote:

> I am trying to install DBD::Oracle 1.27 on Red Hat Enterprise Linux Server release 5.5 (Tikanga), Linux 2.6.18-194.17.1.el5 x86_64 x86_64 x86_64 GNU/Linux.
> I have already deployed the latest Oracle InstantClient and can connect to the Oracle server (running on a different box) via sqlplus. Since I'm not allowed to log
> on as 'root', I am installing everything in my home directory. I set the ORACLE_HOME, TNS_ADMIN, ORACLE_SID, ORACLE_USERID, LD_LIBRARY_PATH,
> C_INCLUDE_PATH and PERL5LIB environment variables to include everything needed for the Perl module to be happy, as well as creating tnsnames.ora and
> sqlnet.ora files. I can 'make' DBD::Oracle okay, but "make test" fails with the following error
>
>t/10general.............DBI connect('','user/password',...) failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)...

I had the exact same problem but I ignored it because I could connect
successfully through a Perl DBI test script.  Sure enough, TWO_TASK
fixed it for me too.

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.

Sorry to hijack this thread, but any suggestions appreciated.

Joe