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: [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.
>>
>>   
>>     
>
>