Hi all, My Oracle database NLS language is AMERICAN English. In DBD::Oracle, what variable/value should I set? Thanks. Yeow -----Original Message----- From: Yeow Yiew Choong-PBKN64 Sent: Thursday, June 24, 2010 11:00 AM To: 'John Scoles' Cc: dbi-users@perl.org Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all, Tried TNS_ADMIN =/opt/instantclient_10_2/ and ORACLE_USERID=scott/ti...@zmy12sora02 but still same error. I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different settings combination for TNS_ADMIN and ORACLE_USERID but still not successful. I am wondering what DBD::Oracle needs. I set NLS_LANG=.WE8ISO8859P15 , tried different settings for NLS_LANG such as .UTF8, .AL32UTF8, .UTF_8 but all not successful. I set NLS_NCHAR = AL32UTF8 and not successful. What is other NLS related setting(s)? Thanks. Yeow -----Original Message----- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, June 23, 2010 7:19 PM 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: ok you had these set before I just noticed you have TNS_ADMIN =/opt/instantclient_10_2/network/admin that should point to the dir where you TNSNAME.ORA file is. so I think it should be TNS_ADMIN =/opt/instantclient_10_2/ as well ass you have ORACLE_SID=CGISSRND TWO_TASK= zmy12sora02 set I would just drop those two and just use the following ORACLE_USERID=scott/ti...@zmy12sora02 Hope this helps John Scoles > Hi all, > > I am using tnsnames.ora file in my Oracle Instantclient folder. > The tnsnames.ora file content is listed below: > zmy12sora02 = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = > (COMMUNITY = tcp.world) > (PROTOCOL = TCP) > (Host = 10.228.140.12) > (Port = 1521) > ) > ) > (CONNECT_DATA = (SID = CGISSRND) > ) > ) > > > My remote database hostname is zmy12sora02 (IP address is > 10.228.140.12). > When I connect using SQLPlus, I am using the command below: > # sqlplus scott/ti...@zmy12sora02 > > I can connect using another user/password with dba role too. > However, in DBI/DBD make test, it cannot connect. Why? > Thanks. > Yeow > > -----Original Message----- > From: John Scoles [mailto:sco...@pythian.com] > Sent: Tuesday, June 22, 2010 6:44 PM > To: Yeow Yiew Choong-PBKN64 > Cc: dbi-users@perl.org > Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error > > 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: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 <mailto:pbk...@motorola.com>> wrote: >> >> Hi, >> >> I set NLS_LANG=.WE8ISO8859P15 and scott/ti...@cgissrnd >> <mailto:scott/ti...@cgissrnd>, and tried scott/ti...@zmy12sora02 >> <mailto:scott/ti...@zmy12sora02>. >> All same error. >> >> Yeow >> >> >> > ---------------------------------------------------------------------- > -- > >> *From:* John Scoles [mailto:sco...@pythian.com >> <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 >> <mailto: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 <mailto: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 >> <mailto:sco...@pythian.com>] >> Sent: Friday, June 18, 2010 12:04 AM >> To: Yeow Yiew Choong-PBKN64 >> Cc: dbi-users@perl.org <mailto: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 >> <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 eve...@pythian.com >> > <mailto: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. >> >> >> > >
