Re: Perl 5.8.9 DBI/DBD::Oracle make test error
[email protected] (John Scoles)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
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=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
>>> <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.
>>>
>>>
>>>
>>>
>>
>>
>
>