RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
produkt bedzie mial takie pola (poki co) wyszukiwanie po nazwie,producencie,statusie product_name product_description product_producer product_status_id product_price product_price_currency_id product_price_datetime product_created_datetime product_modified_datetime product_url prezentowane w gridzie name, producer, price, price_currency, url (klikalny?) za chwile podesle polaczenia
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
sorry, my mistake :(
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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
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
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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
this thread may help as well http://forums.oracle.com/forums/thread.jspa?threadID=872112 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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
On 06/24/2010 05:52 AM, John Scoles wrote: 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. ---deleted on purpose ;) Perhaps it might help to start over with a personal copy of perl? That is to say, build perl with prefix=some/dir, then add in only the DBI and DBD::Oracle. This might simplify things enough to be able to isolate the problem. -- Bob McGowan
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
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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
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/01baseok 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
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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/01baseok 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
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
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/01baseok 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
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/01baseok t/10general.DBI connect('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s 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