RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread John Scoles
It is somthing in you connection string or you do not have the TNS_ADMIN env car set TNS_ADMIN should point to your TNSNAMES.ORA file > Subject: Having a problem conneting to an Oracle 11gr2 RAC > Date: Thu, 29 Apr 2010 15:03:18 -0500 > From: scott.stric...@ngc.com > To: dbi-users@pe

RE: question on how a path/directory is picked up

2010-04-29 Thread John Scoles
Looks like you are trying to 'run' a DBD::Oracle that was compiled against the 11.2 client against the 10.2 client?? Or the path to the 11.2 client is somehere in you enviornment perhaps the PATH or the client .so files have permission setting that do not allow you to execute them

Announce: DBI 1.611

2010-04-29 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.611.tar.gz size: 534200 bytes md5: f48bc718e871f8926809af16682783fb =head2 Changes in DBI 1.611 (svn r13935) 29th April 2010 NOTE: minimum perl version is now 5.8.1 (as announced in DBI 1.607) Fixed selectcol_arrayref MaxRows attribute to count r

Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread Stricker, Scott (IS)
Don't know if anyone has worked with the Oracle RAC environment and perl. Using sqlplus, I can do the following C:\>sqlplus ais_dbo/passw...@edc-dbserver/HCSMDA SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 11:55:35 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect

question on how a path/directory is picked up

2010-04-29 Thread Pam Wampler
I am still battling this problem install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/ Oracle.so' for module DBD::Oracle: /usr/lib/oracle/11.2/client/lib/libocci.so.11.1: cannot restore segment prot after reloc: Permission denied at /

Re: unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread John Scoles
ranjith makineni wrote: For DBD::Oracle and DBI you will need to get a copy of a Visual C++ compiler and nmake. If you down load DBD::ORacle 1.24 and have a look at the README.win32 it has full instructions on what you have to do. You are better off using a later version of DBI than the ve

Re: how to post

2010-04-29 Thread Jeff Zucker
On Wed, Apr 28, 2010 at 7:11 PM, Pam Wampler wrote: > How do I post a question to this forum? > > Not unlike the way you posted that one :-). -- Jeff > > > > > Thanks, > > > > Pam Wampler > > Senior Oracle Database Administrator > > Advanced Call Center Technologies, LLC. > > 3035 Boones Cree

Re: DBI/DBD question

2010-04-29 Thread Royce Miller
I am working with the Informix DBA.  The original DBA also got laid off so he didn't install.  But he is comparing this environment with the other environment that is working.  He is also going to create a "stores" database so I can rebuild DBD on the newer system.  Meanwhile, I have confirmed t

Re: unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread Michael Ludwig
Am 28.04.2010 um 18:01 schrieb ranjith makineni: > I need to install DBI for connection to Oracle Database for Perl version > 5.8.0 from windows X86. Perl 5.8.0 is ages old. You should upgrade to get the bugfixes. > I have downloaded DBI-1.48. We are able to run perl Makefile.PL, but unable > to

unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread ranjith makineni
Hi, I need to install DBI for connection to Oracle Database for Perl version 5.8.0 from windows X86. I have downloaded DBI-1.48. We are able to run perl Makefile.PL, but unable to nmake or dmake commands on windows. we are getting the error "'nmake' is not recognized as an internal or external

Re: centos perl-DBD:Oracle

2010-04-29 Thread Kim
Hi Pam, Pam Wampler wrote: What are the steps to install perl-DBD:Oracle on a centos 5 server? I have the following oracle rpm's installed rpm -qa | grep oracle oracle-instantclient11.2-odbc-11.2.0.1.0-1 oracle-instantclient-sqlplus-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1 oracle-instan

RE: (Fwd) Problems inserting into a CLOB field type using DBI PERL

2010-04-29 Thread Arshad Mahmood
Hi, Many thanks for your assistance. Thank you for highlighting that John. I have managed to fix the problem, I also needed to set the LongReadLen and LongTruncOk attributes which control how long columns are retrieved. I appreciate your support Wishing you all the best Ash -Original M

Re: centos perl-DBD:Oracle

2010-04-29 Thread Michael Ludwig
Am 29.04.2010 um 04:08 schrieb Pam Wampler: > What are the steps to install perl-DBD:Oracle on a centos 5 server? > rpm -i perl-DBD-Oracle-1.19-1.el5.i386.rpm > > warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature: > NOKEY, key ID e42d547b > > error: Failed dependencies: >