Don't know what else to say.
You either have a bad perl or DBI/DBD install or something on the network permission side is blocking you. Can't really help more than that. Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error Date: Mon, 28 Jun 2010 19:06:23 +0800 From: pbk...@motorola.com To: byter...@hotmail.com CC: dbi-users@perl.org Hi John, Started over with ORACLE_USERID, ORACLE_HOME & TNS_ADMIN set. Still not able to connect for DBD. Yeow From: John Scoles [mailto:byter...@hotmail.com] Sent: Friday, June 25, 2010 7:16 PM To: Yeow Yiew Choong-PBKN64 Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error Well all else fails start over. 1) clear out all your envionement variables 2) rerun the make test 3) that should fail with a different error 4) set the ORACLE_USERID 5) rerun the make test 6) should still fail with a different error 7) set the ORACLE_HOME 8) rerun the make test 9) should still fail with a different error 10) set the TNS_HOME 11) rerun the make test 12) should conenct My last gasp at it. Cheers John > Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error > Date: Fri, 25 Jun 2010 16:06:32 +0800 > From: pbk...@motorola.com > To: sco...@pythian.com > CC: dbi-users@perl.org > > 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. > >>> > >>> > >>> > >>> > >> > >> > > > > > Enter for a chance to get your town photo on Bing.ca! Submit a Photo Now! _________________________________________________________________ Learn more ways to connect with your buddies now http://go.microsoft.com/?linkid=9734388
