On Feb 1, 10:58 am, as...@msn.com (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
