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 - 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::
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 - 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&
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
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
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- 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/instantcl
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
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
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 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
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
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
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 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
mailto:pbk...@motorola.com>> wrote:
Hi all,
Ther
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 >> 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 > <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 >> 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
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 >> 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 > <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 >> >>
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 > 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 <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 > 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. >
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
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 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
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 Ins
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
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
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 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
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
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 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
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
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
>
>
FW: Perl 5.8.9 DBI/DBD::Oracle make test error
Forgot to cc this reply to the list
-Original Message-
From: CAMPBELL, ED (ATTBST)
Sent: Thursday, June 17, 2010 12:52 PM
To: 'John Scoles'
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
The scott/tiger user in Oracle is Locked with an expired password by
default, so you need to check. If you can login from sqlplus with
scott/tiger then I would check the Roles given scott user. I had to add
DBA to that user to get it to pass the "make test"
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, June 17, 2010 12:04 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:
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
>
>
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
Perl 5.8.9 DBI/DBD::Oracle make test error
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
