On Tue, Sep 20, 2005 at 07:18:25PM -0700, Mitchell, Louise M wrote:
> Oracle has some environment variables that are critical, such as
> ORACLE_HOME, NLS_LANG, etc. It appears that these are not set for the
> user that is doing the install. Check with your Oracle DBA if you're
> not familiar with these.
And, out of idle curiosity, can someone tell me what the command
oerr ORA 24322
says? (I don't have access to an Oracle system right now.)
I'm just guessing that maybe the error code from OCIInitialize is
actually an oracle standard error number...
Tim.
> -----Original Message-----
> From: Trivedi, Dhirendra [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 8:07 AM
> To: dbi-users@perl.org
> Subject: Perl-Oracle DBI module
>
> Hi,
>
> Trying to install Oracle Driver for Perl I get the error message
>
> UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS
> settings etc. at t/general.t line 21
>
> Are you able to advise a work around for this ?
>
> t/base..............ok
> t/general...........DBI->connect failed: (UNKNOWN OCI STATUS 24322)
> OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t
> line 21 Unable to connect to Oracle ((UNKNOWN OCI STATUS 24322)
> OCIInitialize. Check ORACLE_HOME and NLS set tings etc.) Tests skiped.
> skipping test on this platform
> t/long..............Unable to connect to Oracle ((UNKNOWN OCI STATUS
> 24322) OCIInitialize. Check ORA CLE_HOME and NLS settings etc.) Tests
> skiped.
> skipping test on this platform
> t/plsql.............Unable to connect to Oracle ((UNKNOWN OCI STATUS
> 24322) OCIInitialize. Check ORA CLE_HOME and NLS settings etc.) Tests
> skiped.
> skipping test on this platform
> t/reauth............skipping test on this platform All tests successful,
> 4 tests skipped.
>
> Files=5, Tests=5, 1 wallclock secs ( 1.20 cusr + 0.27 csys = 1.47
> CPU)
> PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> -I/usr/local/lib/perl5/5.00503/aix -I
> /usr/local/lib/perl5/5.00503 test.pl
> Oraperl test application $Revision: 1.2 $
>
> Oraperl emulation interface version 1.39 DBD::Oracle 1.06 using OCI8 by
> Tim Bunce DBI 1.10 by Tim Bunce
>
> ata sources:
> dbi:Oracle:CATDB
> dbi:Oracle:EIBTC1
> dbi:Oracle:eibtc1
> dbi:Oracle:extproc_connection_data
> dbi:Oracle:grommit_catdb
> dbi:Oracle:grommit_eibtc1
> dbi:Oracle:grommit_nolog
> dbi:Oracle:tsmrman
> dbi:Oracle:wallace_eibtc1
>
>
> Connecting
> to 'eibtc1' (from command line, else uses ORACLE_SID or TWO_TASK -
> recommended) as 'scott/[EMAIL PROTECTED]' (via ORACLE_USERID env var or
> default - recommend name/[EMAIL PROTECTED]) (ORACLE_SID='EIBTC1',
> TWO_TASK='')
> ora_login: 24322: (UNKNOWN OCI STATUS 24322) OCIInitialize. Check
> ORACLE_HOME and NLS settings etc.
>
> Generally set TWO_TASK or ORACLE_SID but not both at the same time.
> Try to connect to the database using an oracle tool like sqlplus only if
> that works should you suspect problems with DBD::Oracle.
> Try leaving dbname value empty and set dbuser to name/[EMAIL PROTECTED]
>
> Test aborted.
> make: 1254-004 The error code from the last command is 255.
>
>
> Stop.
>
>
>
>
>
> Regards
> Dhirendra Trivedi
> Tel: 01733 417828
> Mob: 07733411458
>
>
>
> ************************************************************************
> Thomas Cook - The ultimate expert in leisure travel, visit us at
>
> www.thomascook.com or tune in to Thomas Cook TV on Sky
> Digital Channel 645 or ntl:home channel 857 or visit us at...
>
> www.jmc.com www.tcsignature.com www.style-holidays.co.uk
> www.neilson.co.uk www.club18-30.com www.flythomascook.com
> www.flexibletrips.com www.sunset-holidays.com
> www.roomsandhotels.com www.thomascooksport.com
>
> This email is confidential, may be legally privileged, and is for
> the intended recipient only. Access, disclosure, copying,
> distribution or reliance on any of it by anyone else is prohibited
> and may be a criminal offence. Please delete if obtained in error.
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be
> the views of Thomas Cook UK Ltd.
>
> ************************************************************************
> **
>
