Hi John, The print command lines I put in 02test.t file and run make test. It does not give any output other than "No subtests run". I run instmodsh command and please refer the installed modules.
# instmodsh Available commands are: l - List all installed modules m <module> - Select a module q - Quit the program cmd? l Installed modules are: Archive::Tar Archive::Zip Authen::SASL BSD::Resource Bit::Vector CPAN::Checksums Carp::Clan Compress::Bzip2 Compress::LZF Compress::Raw::Bzip2 Compress::Raw::Zlib Compress::Zlib Convert::ASN1 Convert::IBM390 Crypt::Blowfish Crypt::CBC Crypt::DES Crypt::Rijndael Crypt::Rot13 Cwd DBD::CSV DBD::File DBD::SQLite DBI Data::Compare Data::Peek Date::Calc Date::Manip Debug::Trace Devel::Cover Devel::Modlist Devel::Size Devel::Symdump Devel::Trace Devel::ptkdb Digest::HMAC Digest::MD5 Digest::SHA Digest::SHA1 ExtUtils::CBuilder ExtUtils::Install ExtUtils::MakeMaker File::Find::Rule File::Next Graph HTML-Tree HTML::Parser HTML::Tagset HTTP::Proxy Heap IO::Compress::Base IO::Compress::Bzip2 IO::Compress::Lzf IO::Compress::Zlib IO::String IO::Tee IO::Zlib Image::Base Image::ExifTool Image::Info Image::Size Image::Xbm Image::Xpm Inline LWP List::MoreUtils List::Util Mail::Sendmail Module::Build Net::LDAP Net::NTP Net::Rexec Net::SNMP News::NNTPClient Number::Compare OLE::Storage_Lite OpenOffice::OOBuilder OpenOffice::OODoc PDF::Extract Package::Constants Parse::RecDescent Perl Perl::Tidy Pod Pod::Coverage Pod::Escapes Pod::Simple Proc::ProcessTable RTF::Parser RTF::Tokenizer RTF::Writer Regexp::Common SOAP::Lite SQL::Statement Spreadsheet::ParseExcel Spreadsheet::Read Spreadsheet::ReadSXC Spreadsheet::WriteExcel Storable Sub::Uplevel Term::Size Test::Exception Test::Harness Test::Pod Test::Pod::Coverage Test::Simple Text-Format+NWrap Text::CSV Text::CSV_XS Text::Glob Text::Metaphone Text::OutputFilter Tk Tk::Clock Tk::FontDialog Tk::TableMatrix Tk::TreeGraph URI Unix::Processors User::Utmp V VCS::SCCS X11::Protocol XML::Parser XML::SAX::Base XML::Simple XML::Twig XML::Writer XML::XPath YAML ack version Do I miss any module? The Oracle thread at http://forums.oracle.com/forums/thread.jspa?threadID=872112 does not give final solution. I installed DBI 1.611, same error after that for DBD::Oracle make test. Suggestions? Thanks. Yeow -----Original Message----- From: John Scoles [mailto:sco...@pythian.com] Sent: Thursday, June 24, 2010 8:52 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error Well not havening much luck are we. At this point I think you either have a bad Perl, DBI or DBD::Oracle installation and or a you have multiple installations of DBI and DBD::Oracle. So to see what you DBI can see give this a try use DBI; print "available_drivers:\n"; print "$_\n" foreach DBI->available_drivers; print "\ndata_sources:\n"; print "$_\n" foreach DBI->data_sources('Oracle'); and post the results here cheers John Scoles > 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=zmy >> 1 >> >> >>> > 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. >>> >>> >>> >>> >> >> > >
