Re: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user
[email protected] ("Martin J. Evans")
| Newsgroups | perl.dbi.users |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
On 01/02/11 15:58, Alexander Saip 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
export ORACLE_USERID=username/password
export TWO_TASK=//myoraclemachine.domain.com/sid
always works for me and you don't need to set up tnsnames.
I don't think you need ORACLE_HOME set with instant client, just LD_LIBRARY_PATH.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com