RE: Perl 5.8.9 DBI/DBD::Oracle make test error

Hi all,

There is a user scott, otherwise I cannot logon manually using sqlplus.
I am using the same username password to logon for my connection testing
using sqlplus.
I have set ORACLE_USERID but still no luck.
What to do?
Thanks.

Yeow 

-----Original Message-----
From: John Scoles [mailto:[email protected]] 
Sent: Friday, June 18, 2010 12:04 AM
To: Yeow Yiew Choong-PBKN64
Cc: [email protected]
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error

Yeow Yiew Choong-PBKN64 wrote:

I really doubt there is a scott/tiger user on you Oracle box

set the ORACLE_USERID  to a value user and password sid combination and
then come back to the list

ie

export ORACLE_USERID=my_user/my_password@my_id
> Hi,
>  
> I have HP-UX 11.11(64bit PA-RISC) and Perl 5.8.9.(32bit & 64bit) The 
> Perl I installed from depot file from www.develooper.com. I am using 
> gcc 3.4.3 depot file from ftp.thewrittenword.com.
> I am new to Perl. I want to install DBD::Oracle 1.24 (from CPAN) so 
> that I can connect to remote database Oracle 10g.
> I am using Oracle Instantclient 10.2 (32bit) from Oracle download.
>
> DBI is included in the perl 5.8.9.
> There is no issue on DBD compilation and make, the problem I have is 
> when I run make test.
>
> The error is:
> # make test
> 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('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy1
> 2s
> ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))',...) failed: ERROR 
> OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) 
> and or NLS settings, permissions, etc. at t/10general.t line 35 
> Bailout called. Further testing stopped: Unable to connect to Oracle 
> (ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH
> (Windows) and or NLS settings, permissions, etc.)
> *** Error exit code 1
>
> I can connect to Oracle using sqlplus manually.
> DBD make test failed to connect to Oracle.
> I have set ORACLE_HOME, LD_LIBRARY_PATH & SHLIB_PATH to my Oracle 
> Instantclient folder at /opt/instantclient_10_2. I have changed 
> t/10general.t under DBD setup folder to include the environment 
> variables but still failed. The variables are :
> $ENV{ORACLE_HOME} = '/opt/instantclient_10_2'; $ENV{NLS_LANG} = 
> '.WE8ISO8859P15'; #$ENV{NLS_LANG} = 'en_US.UTF8'; #$ENV{NLS_LANG} = 
> 'AMERICAN_AMERICA.UTF8'; #$ENV{ORACLE_USERID} = 'scott/tiger'; 
> $ENV{ORACLE_SID} = 'CGISSRND'; $ENV{LD_LIBRARY_PATH} = 
> '/opt/instantclient_10_2'; $ENV{SHLIB_PATH} = 
> '/opt/instantclient_10_2'; $ENV{LD_RUN_PATH} = 
> '/opt/instantclient_10_2'; $ENV{TNS_ADMIN} = 
> '/opt/instantclient_10_2/network/admin';
> $ENV{LD_PRELOAD} = '/opt/java1.5/jre/lib/PA_RISC2.0/libjava.sl';
> #$ENV{TWO_TASK} = 'zmy12sora02';
>
> I manually set $dbh as listed below:
>
> my $dbh = DBI->connect('dbi:Oracle:',
> q{scott/tiger@(DESCRIPTION=(ADDRESS=(PROTO
> COL=TCP)(HOST=zmy12sora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))},
> "");
>
> I can ping my server's IP address.
> I tried different variable settings that I can find from other threads

> in Internet but failed.
> Please help. Thanks.
>  
> regards,
> Yeow
>
>