Re: Perl 5.8.9 DBI/DBD::Oracle make test error
[email protected] (John Scoles)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
How are you connecting with SQLPLus? > Still failed with TNS_ADMIN configured & exported. > I tried another user with dba role but same error. > sqlplus can connect but DBD::Oracle cannot, how to troubleshoot what > is preventing it to connect? > Thanks. > Yeow > ------------------------------------------------------------------------ > *From:* John Scoles [mailto:[email protected]] > *Sent:* Friday, June 18, 2010 7:36 PM > *To:* Yeow Yiew Choong-PBKN64 > *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error > > last change TNS_ADMIN > > set this to the dir where you tnsnames.ora is located > > If all of these faile then there is something in your network that is > prefenting DBD::Oracle from connecting. > > cheers > John > > On Fri, Jun 18, 2010 at 6:27 AM, Yeow Yiew Choong-PBKN64 > <[email protected] <mailto:[email protected]>> wrote: > > Hi, > > I set NLS_LANG=.WE8ISO8859P15 and scott/tiger@CGISSRND > <mailto:scott/tiger@CGISSRND>, and tried scott/tiger@zmy12sora02 > <mailto:scott/tiger@zmy12sora02>. > All same error. > > Yeow > > ------------------------------------------------------------------------ > *From:* John Scoles [mailto:[email protected] > <mailto:[email protected]>] > *Sent:* Friday, June 18, 2010 6:15 PM > > *To:* Yeow Yiew Choong-PBKN64 > *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error > > Aw well you might want to set the NLS_LANG=.WE8ISO8859P15 just in > case as well > > On Fri, Jun 18, 2010 at 6:11 AM, John Scoles <[email protected] > <mailto:[email protected]>> wrote: > > scott/tiger@( > DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s > ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND) > > > would not be a correct connection string give > > scott/tiger@CGISSRND a try > > > > On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew Choong-PBKN64 > <[email protected] <mailto:[email protected]>> wrote: > > 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] > <mailto:[email protected]>] > Sent: Friday, June 18, 2010 12:04 AM > To: Yeow Yiew Choong-PBKN64 > Cc: [email protected] <mailto:[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 > <http://www.develooper.com>. I am using > > gcc 3.4.3 depot file from ftp.thewrittenword.com > <http://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 > <http://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 > > > > > > > > -- > Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. > Hear Sheeri speak or email [email protected] <mailto:[email protected]> to meet with Pythian. > > > > > -- > Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. > Hear Sheeri speak or email [email protected] to meet with Pythian. > >