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

 
Forgot to cc this reply to the list

-----Original Message-----
From: CAMPBELL, ED (ATTBST) 
Sent: Thursday, June 17, 2010 12:52 PM
To: 'John Scoles'
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error

The scott/tiger user in Oracle is Locked with an expired password by
default, so you need to check.  If you can login from sqlplus with
scott/tiger then I would check the Roles given scott user.  I had to add
DBA to that user to get it to pass the  "make test" 

-----Original Message-----
From: John Scoles [mailto:[email protected]] 
Sent: Thursday, June 17, 2010 12:04 PM
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=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
>
>