RE: Perl 5.8.9 DBI/DBD::Oracle make test error

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:[email protected]] 
Sent: Thursday, June 24, 2010 8:52 PM
To: Yeow Yiew Choong-PBKN64
Cc: [email protected]
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: [email protected]
> 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/tiger@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:[email protected]]
> Sent: Wednesday, June 23, 2010 7:19 PM
> To: Yeow Yiew Choong-PBKN64
> Cc: [email protected]
> 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/tiger@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/tiger@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:[email protected]]
>> Sent: Tuesday, June 22, 2010 6:44 PM
>> To: Yeow Yiew Choong-PBKN64
>> Cc: [email protected]
>> 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:[email protected]]
>>> *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 
>>> <[email protected] <mailto:[email protected]>> wrote:
>>>
>>>     Hi,
>>>      
>>>     I set NLS_LANG=.WE8ISO8859P15 and scott/tiger@CGISSRND
>>>     <mailto:scott/tiger@CGISSRND>, and tried scott/tiger@zmy12sora02
>>>     <mailto:scott/tiger@zmy12sora02>.
>>>     All same error.
>>>      
>>>     Yeow
>>>
>>>
>>>     
>>>       
>> ---------------------------------------------------------------------
>> -
>> --
>>   
>>     
>>>     *From:* John Scoles [mailto:[email protected]
>>>     <mailto:[email protected]>]
>>>     *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 <[email protected]
>>>     <mailto:[email protected]>> 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/tiger@CGISSRND  a try
>>>
>>>
>>>
>>>         On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew Choong-PBKN64
>>>         <[email protected] <mailto:[email protected]>> 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:[email protected]
>>>             <mailto:[email protected]>]
>>>             Sent: Friday, June 18, 2010 12:04 AM
>>>             To: Yeow Yiew Choong-PBKN64
>>>             Cc: [email protected] <mailto:[email protected]>
>>>             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_password@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 [email protected]
>>>     
>>>       
>> <mailto:[email protected]> to meet with Pythian.
>>   
>>     
>>>         
>>>
>>>
>>> --
>>> Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. 
>>> Hear Sheeri speak or email [email protected] to meet with Pythian.
>>>
>>>   
>>>     
>>>       
>>   
>>     
>
>