Hi, 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:sco...@pythian.com] 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 <pbk...@motorola.com> wrote: Hi, I set NLS_LANG=.WE8ISO8859P15 and scott/ti...@cgissrnd, and tried scott/ti...@zmy12sora02. All same error. Yeow ________________________________ From: John Scoles [mailto:sco...@pythian.com] 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 <sco...@pythian.com> 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/ti...@cgissrnd a try On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew Choong-PBKN64 <pbk...@motorola.com> 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:sco...@pythian.com] Sent: Friday, June 18, 2010 12:04 AM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org 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_passw...@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 > > -- Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. Hear Sheeri speak or email eve...@pythian.com to meet with Pythian. -- Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. Hear Sheeri speak or email eve...@pythian.com to meet with Pythian.
