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: [email protected]
To: [email protected]
CC: [email protected]




Hi John,
 
Started over with ORACLE_USERID, ORACLE_HOME & TNS_ADMIN set.
Still not able to connect for DBD.
 
Yeow



From: John Scoles [mailto:[email protected]] 
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: [email protected]
> To: [email protected]
> CC: [email protected]
> 
> 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.
> >>>
> >>> 
> >>> 
> >>> 
> >> 
> >> 
> >
> > 
> 



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