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
<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/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 eve...@pythian.com
<mailto:eve...@pythian.com> to meet with Pythian.
--
Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1.
Hear Sheeri speak or email eve...@pythian.com to meet with Pythian.
