Hi,
I have seeen this error when the ORACLE_SID being used is not a TNS alias in
the tnsnames.ora. Given that you are using the instant client, make sure
first that you can connect to the database using sqlplus and the TNS alias.
Then you should check what value is being used to connect to the database by
the test code.
Regards
Pete
On 1 February 2011 15:58, Alexander Saip <as...@msn.com> wrote:
>
> Hi Everybody,
>
> 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:
>
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/01base................# Test loading DBI, DBD::Oracle and version
> t/01base................ok
> t/10general.............DBI connect('','user/password',...) failed:
> ORA-24327: need explicit attach before authenticating a user (DBD ERROR:
> OCISessionBegin) at t/10general.t line 22
> FAILED--Further testing stopped: Unable to connect to Oracle (ORA-24327:
> need explicit attach before authenticating a user (DBD ERROR:
> OCISessionBegin))
> make: *** [test_dynamic] Error 9
>
> Of course, the real username and password are sent to the Oracle server,
> the same that allow me to connect to it from sqlplus. I wonder what could
> cause that error? I have done some search on the Internet, but was unable to
> find any definitive solution.
>
> Thanks in advance,
>
> Alexander Saip
