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: DBI module most important module in Perl 2010 survey
Martin Evans wrote: http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html Look for the presentation slides. Martin Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error!
Re: DBI module most important module in Perl 2010 survey
In message 4c20b25e.3030...@pythian.com, John Scoles writes: Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error! URL:http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf John groenv...@acm.org
Re: DBI module most important module in Perl 2010 survey
John Scoles wrote: Martin Evans wrote: http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html Look for the presentation slides. Martin Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error! Link at bottom of page http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf still works for me Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
Re: DBI module most important module in Perl 2010 survey
Must be an IE thing seems to open with Firefox/ Interesting stuff. When you look at the DBI I think it is understated as there are a number of mods on that list that require DBI. My fab is the very few who have taken formal 'Perl' training, me thinks it is time 'perl' is put on the curriculum of more post secondary courses. cheers all John Scoles wrote: Martin Evans wrote: http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html Look for the presentation slides. Martin Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error! Link at bottom of page http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf still works for me Martin
