Perl 5.8.9 DBI/DBD::Oracle make test error

[email protected] ("Yeow Yiew Choong-PBKN64")
Newsgroups perl.dbi.users
Message-ID <[email protected]>
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=zmy12s
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.