Re: DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

2023-10-28 Thread Justin Schoeman
)     ELF object binary architecture: AMD x86-64 On 2023/10/25 15:39, Justin Schoeman wrote: Good day, I am trying to dig into an issue after a recent Oracle update. The application has been running flawlessly from version 9.x to 18.5, and has only broken on the most recent client library

DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

2023-10-25 Thread Justin Schoeman
Good day, I am trying to dig into an issue after a recent Oracle update. The application has been running flawlessly from version 9.x to 18.5, and has only broken on the most recent client library updates. Attached is a cut down application which demonstrates the issue. The forked child

Re: Oracle connection error

2023-01-14 Thread Richard Dice
encies resolved.* > *Nothing to do.* > *Complete!* > > *#perl -MCPAN -e shell* > *CPAN>get DBD::Oracle* > *CPAN>quit* > *#cd /root/.cpan/build/DBD-Oracle-1.83-0* > *#perl Makefile.PL* > > I see the below error again: > */usr/bin/ld: cannot find -lnsl* > *collect2: erro

Re: Oracle connection error

2023-01-13 Thread Syed Abdulla
then I see these errors install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/bin/perl /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (

Re: Oracle connection error

2023-01-12 Thread Syed Abdulla
.* *Dependencies resolved.* *Nothing to do.* *Complete!* *#perl -MCPAN -e shell* *CPAN>get DBD::Oracle* *CPAN>quit* *#cd /root/.cpan/build/DBD-Oracle-1.83-0* *#perl Makefile.PL* I see the below error again: */usr/bin/ld: cannot find -lnsl* *collect2: error: ld returned 1 exit status*

Re: Oracle connection error

2023-01-12 Thread Clive Eisen
dnf install libnsl.x86_64 > On 12 Jan 2023, at 14:25, Syed Abdulla wrote: > > Hi, > > While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I > see the below error and the installation fails. > > /usr/bin/ld: cannot find -lnsl > collect2: error

Oracle connection error

2023-01-12 Thread Syed Abdulla
Hi, While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I see the below error and the installation fails. /usr/bin/ld: cannot find -lnsl collect2: error: ld returned 1 exit status make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so <http://oracle.so/>] E

Re: please help with DBD-Oracle-1.76

2022-09-06 Thread Bruce Johnson
Also the SDK package needs to be installed or the build fails. Minimum for DBD::Oracle are the Basic and SDK packages. On Sep 5, 2022, at 6:43 AM, kmo...@esntech.com<mailto:kmo...@esntech.com> wrote: Hi Daniel, I have three questions. 1. Did you install the instant client as r

RE: please help with DBD-Oracle-1.76

2022-09-05 Thread kmoore
Hi Daniel, I have three questions. 1. Did you install the instant client as root? I always install it as Oracle. 2. LD_LIBRARY_PATH should be set as =/root/ora2pg/instantclient_21_7/lib in your case 3. The link you provided has a download to sqlplus, I’d suggest you

Fwd: please help with DBD-Oracle-1.76

2022-09-05 Thread Tim Bunce
> Begin forwarded message: > > From: Daniel Chmielewski > Subject: Fwd: please help with DBD-Oracle-1.76 > Date: 5 September 2022 at 10:03:15 IST > To: t...@cpan.org > > Tim, please help. > Regards, > Daniel > > > -- Forwarded mes

Oracle DBD with 19c - forked child hangs on exit

2022-05-10 Thread Tim Wolfe
We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 using Perl v5.26.3 and the latest DBD::Oracle and DBI from cpan. Under 19c, a forked child hangs on exit if the parent has (or had) an

Please test DBD::Oracle v1.90_1

2022-03-25 Thread Dean Hamstead
Hi All, Anyone using DBD::Oracle is invited to test out out this dev release v1.90_1 Download from metacpan https://metacpan.org/release/ZARQUON/DBD-Oracle-1.90_1 GH Tag https://github.com/perl5-dbi/DBD-Oracle/tree/v1.90_1 v1.90 candidate branch https://github.com/perl5-dbi/DBD-Oracle/tree

Re: [External] : DBD::Oracle use_drcp and connection class

2022-03-04 Thread Christopher Jones
On 5/3/2022 3:44 am, Andrei A. Voropaev via dbi-users wrote: Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "sessi

DBD::Oracle use_drcp and connection class

2022-03-04 Thread Andrei A. Voropaev
Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "session pooling", which is not exactly the same. Connected

Re: DBD::Oracle insert speed

2021-01-10 Thread Christopher Jones
On 10/1/21 11:22 am, Peter Meszaros wrote: Hi, I have already asked this question at perlmonks.org <https://urldefense.com/v3/__http://perlmonks.org__;!!GqivPVa7Brio!OybtaVZUVoKl3qAbiNkFHQxZALNrn7ocQA5ft_OycHRoAtyyjCPfcy33Ob-PjpZEzbH1Ow$> but I did not get proper answer. Module DBD::

DBD::Oracle insert speed

2021-01-09 Thread Peter Meszaros
Hi, I have already asked this question at perlmonks.org but I did not get proper answer. Module DBD::Oracle <http://search.cpan.org/perldoc?DBD%3A%3AOracle> has serious performance degradation at inserting rows. Except execute_array (or bind_param_array), all other insert solutions are

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-23 Thread Peter Vanroose
Actually, I did exactly this a few years ago. Only problem: NULLs show up as blanks ... Apart from that, it works like a charm! -- Peter Vanroose. Op 23 jun. 2020 22:10, om 22:10, "Fennell, Brian" schreef: >Another idea . . . > >You could also wrap Oracle SQLPlus in perl

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-23 Thread Fennell, Brian
Another idea . . . You could also wrap Oracle SQLPlus in perl using qx How-to SQLPLUS and XML here: https://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:3512822500346787661 That and a little perl text parsing could get you a long way - split , grep, map, s and tr. This pure

RE: [EXTERNAL] Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-22 Thread Fennell, Brian
FYI The Oracle DBD driver is hard to build, it requires Oracle C Libraries and Header files. It also requires Oracle Development files described by Oracle as Examples, but which are really templates for building any C client. All Oracle C Clients are hard to build. If I recall sometimes a

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-21 Thread Bruce Johnson
> On Jun 19, 2020, at 3:48 PM, Scott wrote: > > We have run into an issue when we upgraded to Oracle client 19c. Some of the > users processes are segfaulting on exit. > > #0 0x7f82ee84ccc0 in pthread_mutex_lock () from /lib64/libpthread.so.0 > #1 0x7f8

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-20 Thread Scott
On 6/20/20 1:51 PM, Scott wrote: More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we upgra

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-20 Thread Scott
More info, this error does not occur with DBD::Oracle 1.76. DBD::Oracle 1.80 => works with 18c client,  but fails with 19c. DBD::Oracle 1.76 => works with all client versions. On 6/19/20 5:48 PM, Scott wrote: We have run into an issue when we upgraded to Oracle client 19c. Some of the

DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

2020-06-19 Thread Scott
We have run into an issue when we upgraded to Oracle client 19c. Some of the users processes are segfaulting on exit. #0  0x7f82ee84ccc0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #1  0x7f82e6444f43 in kputxabt () from /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.19.1 #2

Re: DBD::Oracle install issue on CentOS 8 missing libnsl

2020-05-26 Thread Bruce Johnson
ora build is) , and the > DBD::Oracle install fails during make test: > > Can't load > '/root/.cpan/build/DBD-Oracle-1.80-1/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: libnsl.so.1: cannot open shared object file: No such file > or directory at

DBD::Oracle install issue on CentOS 8 missing libnsl

2020-02-18 Thread Bruce Johnson
Just a heads up for those of you on the close-to-the-bleeding-edge. libnsl is no longer included with the standard glibc libs with CentOS (and I'm guessing also in RHEL 8, and whatever the current Fedora build is) , and the DBD::Oracle install fails during make test: Can't load &#

DBD::Oracle - Error with Oracle Wallet

2019-08-30 Thread Gandhi, Rajesh
Hello dbi-users, I am modifying existing Perl code to use Oracle wallet functionality (Using alias in tnsnames.ora to connect to database without username and password). The wallet setup is working fine through sqlplus but am getting the following error connecting thru perl: DBI connect

AIX (xlc) DBD::Oracle *without* LIBPATH?

2019-07-26 Thread John Wiersba via dbi-users
Hi! I like to know: has anyone been able to get DBD::Oracle working on AIX (6 and/or 7) using the xlc compiler, *without* having to set LIBPATH *at runtime*?  I am able to get it to work by setting LIBPATH, but that's very distasteful and I'm trying to find a way to avoid it. On RHEL

DBD-Oracle 1.79 released to the CPAN

2019-07-20 Thread Martin J. Evans
I have just uploaded DBD::Oracle 1.79 to the CPAN.   [BUG FIXES]   Fix Avoid GCC-ism so that HP-UX can compile (GH#92, Dean Hamstead)   Destroy envhp with last dbh (GH#93, GH#89, Dean Hamstead, CarstenGrohmann) Thanks to everyone who contributed. Martin -- Martin J. Evans Wetherby, UK

Re: (Fwd) Perl with Oracle 12c

2018-04-11 Thread John D Groenveld
In message <2ceb8fe815e746e480d13c6cc8be3...@uscpmb01.photomask.com>, "Seidler, Reinhard" writes: >Thanks to all. Who could know the compiled Oracle client version? $ perl -MDBD::Oracle -le 'print DBD::Oracle::ORA_OCI' 12.2.0.1 >11.2 would be fine and certified

RE: (Fwd) Perl with Oracle 12c

2018-04-10 Thread Seidler, Reinhard
Thanks to all. Who could know the compiled Oracle client version? 11.2 would be fine and certified by Oracle... Cheers Reinhard From: John Scoles [mailto:byter...@hotmail.com] Sent: Tuesday, April 10, 2018 6:26 PM To: Seidler, Reinhard; dbi-users@perl.org Subject: Re: (Fwd) Perl with Oracle 12c

RE: (Fwd) Perl with Oracle 12c

2018-04-10 Thread Fennell, Brian
DBD::Oracle is hard to build from source . . . just went thru this. If you don't build from source it may not be compatible with your Oracle shared libraries, OS Shared libraries or Oracle Server. Consider carefully Oracle client and server characterset (and Perl characterset, a

Re: (Fwd) Perl with Oracle 12c

2018-04-10 Thread John Scoles
Hmm unless you change the installed clients you DBD::Oracle should still work. as 11->12 should work If you are having problems you most likely will have to recompile DBD::Oracle against the new client Checking DBD::Oracle I see it hasn't seen an update for at least 4 years or so and

Re: (Fwd) Perl with Oracle 12c

2018-04-10 Thread Bruce Johnson
t; - Date: Tue, 10 Apr 2018 12:16:09 + From: "Seidler, Reinhard" mailto:reinhard.seid...@amtc-dresden.com>> To: "tim.bu...@pobox.com<mailto:tim.bu...@pobox.com>" mailto:tim.bu...@pobox.com>> Subject: Perl with Oracle 12c Hi Tim, We dev

Re: (Fwd) Perl with Oracle 12c

2018-04-10 Thread Bruce Johnson
rd.seid...@amtc-dresden.com>> To: "tim.bu...@pobox.com<mailto:tim.bu...@pobox.com>" mailto:tim.bu...@pobox.com>> Subject: Perl with Oracle 12c Hi Tim, We develop Perl applications connecting and working with Oracle database (DBD:Oracle). So far it was Oracle ve

Re: (Fwd) Perl with Oracle 12c

2018-04-10 Thread John D Groenveld
In message <20180410150233.7hxxrlqqhwoysp7m@timac>, "tim.bu...@pobox.com" write s: > We develop Perl applications connecting and working with Oracle database (D >BD:Oracle). So far it was > Oracle version 11. Now the database will be migrated to 12.2.0.1. How shoul

(Fwd) Perl with Oracle 12c

2018-04-10 Thread tim.bu...@pobox.com
- Forwarded message from "Seidler, Reinhard" - Date: Tue, 10 Apr 2018 12:16:09 + From: "Seidler, Reinhard" To: "tim.bu...@pobox.com" Subject: Perl with Oracle 12c Hi Tim, We develop Perl applications connecting and working with Oracle databas

RE: Hunting down (possible) memory leak in DBD::Oracle

2018-01-16 Thread Fennell, Brian
grind errors". I can run the same case on an older version of perl and an older version of "DBD::Oracle" module (with the exact same oracle database) and get no errors. Valgrind documentation describes an "invalid write" as follows: http://valgrind.org/docs/manual/mc-manua

Re: Hunting down (possible) memory leak in DBD::Oracle

2018-01-15 Thread Christopher Jones
On 16/1/18 9:17 am, Fennell, Brian wrote: $ egrep -B1 -A20 -i 'invalid write' /copy/sandbox/feeds/data/search4_1/valgrind-log.txt | head -22 ==19402== ==19402== Invalid write of size 4 ==19402==at 0xBD747E6: __intel_ssse3_rep_memcpy (in /db/app/oracle/product/12.1.0/cl

RE: Hunting down (possible) memory leak in DBD::Oracle

2018-01-15 Thread Fennell, Brian
DATE_MANIP=DM5; export ORACLE_HOME=/db/app/oracle/product/12.1.0/client_1 ; export LD_LIBRARY_PATH=$ORACLE_HOME/lib ; export PATH="$ORACLE_HOME/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin"; export NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"; export

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-20 Thread Fennell, Brian
John, Thanks for your incites. I tried what you said. I read up on NVARCHAR2 v VARCHAR2 - interesting.  I also see that Oracle has a way (more than one way) to specify if a VARCHAR2 should contain bytes or characters - further while a VARCHAR2(11 byte) and a VARCHAR2(11 char) are different

Re: Hunting down (possible) memory leak in DBD::Oracle

2017-12-20 Thread Peter J. Holzer
On 2017-12-19 20:55:30 +, Fennell, Brian wrote: > And, also with the log level set to 15 here are the LAST 200 lines [...] > -> fetchrow_array for DBD::Oracle::st > (AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010 > dbd_st_fetch 6 fields... >

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-19 Thread Fennell, Brian
7;1268251' 'aa' '1' undef 'en_US' ) [6 items] row858 at /dirname/scriptname.pl line 196 -> fetchrow_array for DBD::Oracle::st (AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010 dbd_st_fetch 6 fields... dbd_st_f

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-19 Thread Fennell, Brian
With the log level set to 15 here are the first 200 lines of log AAA::DBI::Connection::db=HASH(0x3abce00) trace level set to 0x0/15 (DBI @ 0x0/0) in DBI 1.637-ithread (pid 12594) -> STORE for DBD::Oracle::db (AAA::DBI::Connection::db=HASH(0x3abce00)~INNER 'RowCacheSize'

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-19 Thread Fennell, Brian
John, Thanks for the ideas to change the cache params - I will try that! Here is the SQL and the field types: SELECT d.ROW_NUMBER, d.f1, d.f2, d.f3, d.f4, d.f5 FROM ( SELECT /*+ FULL(A) PARALLEL(A 6) */ rownum ROW_NUMBER, A.field1 f1 ,

Re: Hunting down (possible) memory leak in DBD::Oracle

2017-12-19 Thread John Scoles
here. If could be running out of buffer. Give some of the caching params a tweak https://metacpan.org/pod/DBD::Oracle#RowCacheSize if you can try give fetchrow_hashref a try as see if the error happens there as well. Cheers John DBD::Oracle - Oracle database driver for the DBI module

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-18 Thread Fennell, Brian
Pluta, Looks like it is worth a try - when I looked at the project before it looked like it was for installing a "per user" perl. Does it work for root / all users on a box as well? Brian

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

2017-12-18 Thread Fennell, Brian
Good question - I have asked DBA and am waiting for a reply. -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Monday, December 18, 2017 11:36 AM To: Fennell, Brian ; dbi-users@perl.org Subject: RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

2017-12-18 Thread Fennell, Brian
Ok . . . I am already benefiting from the support from this list : - ) I noticed that I was actually ordering my query BY rownum (which doesn't make much sense . . . and perhaps oracle's optimizer recognized this and ignored the pseudo column.) Just to be sure, I change the query and then rera

RE: Hunting down (possible) memory leak in DBD::Oracle

2017-12-18 Thread Fennell, Brian
and the DBD::Oracle to the same version we use in production, but it would be nice to actually fix the bug if I can. I tried just downgrading the DBD::Oracle, but changes in perl 5 to support MULTIPLICITY made that look like more than just a little work - spend two days on it and then backed

RE: Hunting down (possible) memory leak in DBD::Oracle ** EXTERNAL **

2017-12-18 Thread Fennell, Brian
, 5 ) d WHERE d.row_number < 202 AND d.row_number >= 100 -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Monday, December 18, 2017 9:21 AM To: Fennell, Brian ; dbi-users@perl.org Subject: RE: Hunting down (possible) memory leak in DBD:

Re: Hunting down (possible) memory leak in DBD::Oracle

2017-12-18 Thread John Scoles
Hmm this type of DBD::Oracle debugging will be tricky. Could be almost anything. You are jumping versions in a big way but that still should be ok A few questions 1) What is the ORA-NN in question 2) Set trace to 15 to see if that give you more details 3) What are the type of fields

Hunting down (possible) memory leak in DBD::Oracle

2017-12-16 Thread Fennell, Brian
ht it might be an odd string/data related error, but I am starting to think it is a memory leak of some kind). The error always happens inside of fetchrow_array - and "$dbh->trace( 4 , $filename )" shows that the error originates inside the DBD::Oracle module while reading field 3 o

Re: Oracle encoding query

2017-12-11 Thread Tim Bunce
On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:34:17 +, Tim Bunce > wrote: > > > A view might be useful. Or perhaps define your own function to wrap the > > expression. > > That worked very well! > > CREATE OR REPLACE FUNCTION diac_u (v VARCHAR2) RE

Re: Oracle encoding query

2017-12-06 Thread H.Merijn Brand
On Wed, 6 Dec 2017 15:34:17 +, Tim Bunce wrote: > On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > > > I have been playing with several variants of > > > > > > select convert (land_u, 'AL16UTF16', 'UTF8') fro

Re: Oracle encoding query

2017-12-06 Thread Tim Bunce
On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > I have been playing with several variants of > > > > select convert (land_u, 'AL16UTF16', 'UTF8') from land where c_land = > > 7072; > > > > but I didn't get SQL Devel

Re: Oracle encoding query

2017-12-06 Thread H.Merijn Brand
On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" wrote: > I have an Oracle databse with NLS_CHARACTERSET US7ASCII > > I have a table "land", like > > create table land ( > c_land number (4) not null, > zoek

Oracle encoding query

2017-12-06 Thread H.Merijn Brand
I have an Oracle databse with NLS_CHARACTERSET US7ASCII I have a table "land", like create table land ( c_land number (4) not null, zoekarg varchar2 (5), land varchar2 (40), diac number (

Oracle TAF, FCF and FAN support

2017-10-17 Thread Everett, Christopher L
I'm working with Oracle in a series of payments applications mostly done in Perl that run 24x7. We're trying to set up our environment to enable database changes (both patching and application changes) in place, transparently to clients/customers/users. I am using the TAF support

DBD::Oracle BLOB updates on multiple rows

2017-08-30 Thread Marcus Bergner
Hi,? Running an update like below with DBD::Oracle that updates 2 rows with the same BLOB value bound as ORA_BLOB fails with the following inside oci8.c if (row_count > 1) return oci_error(sth, errhp, OCI_ERROR, "LOB refetch attempted for multiple rows"); and I&#x

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-04-12 Thread Douglas Wilson
The issue was the libclntsh that Oracle was loading conflicted with SQLAnywhere , updating Oracle libs and recompiling DBD::Oracle fixes it. On Mar 7, 2017 2:10 PM, "Douglas Wilson" wrote: > That does work, but I can't consider it a practical solution for this. > Thro

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-07 Thread Douglas Wilson
DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first >> create a >> DBD:Oracle handle, the SQLAnywhere connect hangs for a while, and >> eventually segfaults. FYI on redhat Linux. >> >> >> I don't have the info to ha

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-07 Thread Martin J. Evans
eventually segfaults. FYI on redhat Linux. I don't have the info to hand right now but I've heard similar reports before. I think it had something to do with the method used to connect to Oracle and if that method is chosen it captures SIGCHLD and maybe another s

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-06 Thread Christopher Jones
BD:Oracle handle, the SQLAnywhere connect hangs for a while, and eventually segfaults. FYI on redhat Linux. I don't have the info to hand right now but I've heard similar reports before. I think it had something to do with the method used to connect to Oracle and i

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-06 Thread Douglas Wilson
r reports > before. I think it had something to do with the method used to connect to > Oracle and if that method is chosen it captures SIGCHLD and maybe another > signal as well. > > Martin > -- > Martin J. Evans > Wetherby, UK >

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-04 Thread Martin J. Evans
rd similar reports before. I think it had something to do with the method used to connect to Oracle and if that method is chosen it captures SIGCHLD and maybe another signal as well. Martin -- Martin J. Evans Wetherby, UK

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-02 Thread Ron Savage
Hi Doug On 03/03/17 09:54, Douglas Wilson wrote: DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first create a DBD:Oracle handle, the SQLAnywhere connect hangs for a while, and eventually segfaults. FYI on redhat Linux. First thing we ask: What versions of everything are you using!?

DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-02 Thread Douglas Wilson
DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first create a DBD:Oracle handle, the SQLAnywhere connect hangs for a while, and eventually segfaults. FYI on redhat Linux.

(Fwd) RE: Issues with Oracle DBD in Cygwin

2016-10-12 Thread Tim Bunce
v...@cpan.org'" CC: 'Mike Towery' , 'Christopher Jones' , "'john...@pharmacy.arizona.edu'" Subject: RE: Issues with Oracle DBD in Cygwin FYI - follow up. I believe the issue was a 32-bit versus 64-bit problem. I believe the Cygwin Perl is

Re: (Fwd) Issues with Oracle DBD in Cygwin

2016-09-17 Thread Bruce Johnson
> On Sep 17, 2016, at 7:41 AM, Tim Bunce wrote: > > > Couple of things I have noticed that seem off to me and might be an issue??? > > 1. after unpacking the instant client files into > c:\oracle\instantclient_12_1 (set as ORACLE_HOME) > I do NOT ha

Re: (Fwd) Issues with Oracle DBD in Cygwin

2016-09-17 Thread Christopher Jones
On 18/09/2016 12:41 AM, Tim Bunce wrote: - Forwarded message from "Neargarder, Keith" - Date: Fri, 16 Sep 2016 22:16:11 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" , "'yan...@

(Fwd) Issues with Oracle DBD in Cygwin

2016-09-17 Thread Tim Bunce
- Forwarded message from "Neargarder, Keith" - Date: Fri, 16 Sep 2016 22:16:11 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" , "'yan...@cpan.org'" , "'mjev...@cp

RE: (Fwd) DBD::Oracle quote_identifier

2016-08-17 Thread LAWS, MICHAEL H
: Wednesday, August 17, 2016 4:25 AM To: dbi-users@perl.org Cc: LAWS, MICHAEL H Subject: (Fwd) DBD::Oracle quote_identifier - Forwarded message from "LAWS, MICHAEL H" - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL H" To: "t...@cpan.org" Subject

(Fwd) DBD::Oracle quote_identifier

2016-08-17 Thread Tim Bunce
- Forwarded message from "LAWS, MICHAEL H" - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL H" To: "t...@cpan.org" Subject: DBD::Oracle quote_identifier Hello, I was using quote_identifier for table names on an oracle databas

Re: Bundle::DBI and DBD::Oracle failing

2016-06-23 Thread John D Groenveld
In message , "Tony D'Alfonso" writes: >Does it still make a difference running it as 32-bit on a 64-bit machine. I`v >e strictly been trying it on 64 bit. What does file(1) report about the architecture of your Oracle.so? # file /root/perl5/lib/perl5/x86_64-linux-thread-

RE: Bundle::DBI and DBD::Oracle failing

2016-06-23 Thread Tony D'Alfonso
Does it still make a difference running it as 32-bit on a 64-bit machine. I`ve strictly been trying it on 64 bit. Regards, Tony. -Original Message- From: Tony D'Alfonso Sent: June 23, 2016 9:55 AM To: 'Bruce Johnson' Cc: dbi users Subject: RE: Bundle::DBI and DBD:

RE: Bundle::DBI and DBD::Oracle failing

2016-06-23 Thread Tony D'Alfonso
. -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: June 22, 2016 5:12 PM To: Tony D'Alfonso Cc: dbi users Subject: Re: Bundle::DBI and DBD::Oracle failing > On Jun 22, 2016, at 1:26 PM, Tony D'Alfonso wrote: > > SDK was installed t

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread John R Pierce
inal perl executables. The only thing it affects is keeping track of what has been installed via cpan, since the .cpan metadata lives in root’s home directory. but the OP also said... perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-th

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Bruce Johnson
> On Jun 22, 2016, at 1:26 PM, Tony D'Alfonso wrote: > > SDK was installed too: > > # yum list oracle-instantclient* > Loaded plugins: product-id, search-disabled-repos, subscription-manager > Installed Packages > orac

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Bruce Johnson
eeping track of what has been installed via cpan, since the .cpan metadata lives in root’s home directory. Heck in OS X, I have to run cpan via sudo or I can’t install anything. and no way no how you should be doing Oracle database work while logged on as the unix root user. Oracle won’t even l

RE: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Tony D'Alfonso
SDK was installed too: # yum list oracle-instantclient* Loaded plugins: product-id, search-disabled-repos, subscription-manager Installed Packages oracle-instantclient-basic.x86_64 10.2.0.3-1 installed oracle-instantclient

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread John R Pierce
n see or access that. the Oracle user account that wants to run the perl scripts should instead be the ones to run CPAN. and no way no how you should be doing Oracle database work while logged on as the unix root user. -- john r pierce, recycling bits in santa cruz

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Bruce Johnson
2016 13:29:02 GMT > DBI is up to date (1.636). > DBI::Shell is up to date (11.95). > Storable is up to date (2.51). > Net::Daemon is up to date (0.48). > RPC::PlServer is up to date (0.2020). > DBD::Multiplex is up to date (2.11). > [root@screendoor ~]# cpan -i DBD::Oracle >

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Furst, Carl
It means you don¹t have the Oracle DBD installed. Or its installed to a different place. Did you install it? Where? Carl Yamamoto-Furst -- From: Tony D'Alfonso Date: Wednesday, June 22, 2016 at 2:00 PM To: "dbi-users@perl.org" Subject: RE: Bundle::DBI and DBD:

RE: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Tony D'Alfonso
et::Daemon is up to date (0.48). RPC::PlServer is up to date (0.2020). DBD::Multiplex is up to date (2.11). [root@screendoor ~]# cpan -i DBD::Oracle Reading '/root/.cpan/Metadata' Database was generated on Wed, 22 Jun 2016 13:29:02 GMT DBD::Oracle is up to date (1.74). I'm u

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Dean Pearce
made it through. Slicing the output into multiple messages. Can you help me with this error message? perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libstdc++.so.5: c

RE: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Tony D'Alfonso
# perl -V Summary of my perl5 (revision 5 version 16 subversion 3) configuration: Platform: osname=linux, osvers=2.6.32-504.16.2.el6.x86_64, archname=x86_64-linux-thread-multi uname='linux x86-021.build.eng.bos.redhat.com 2.6.32-504.16.2.el6.x86_64 #1 smp tue mar 10 17:01

RE: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread Tony D'Alfonso
Confirming this email made it through. Slicing the output into multiple messages. Can you help me with this error message? perl /stl/bin/test.pl install_driver(Oracle) failed: Can't load '/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for mod

Re: Help with DBD::Oracle install

2016-02-07 Thread John R Pierce
On 2/7/2016 3:12 AM, Martin J. Evans wrote: You need to install a C compiler - the one your Perl was built with is most likely to work. the perl that comes with solaris is built with Oracle Studio C (formerly Sun Forte C) ... but I seem to recall there was a solaris perl make script that

Re: Help with DBD::Oracle install

2016-02-07 Thread Martin J. Evans
On 05/02/2016 20:35, Tim Bunce wrote: Hi. I don't provide support for DBD::Oracle directly. Please email dbi-users@perl.org or, if you'd rather not just yet, then something here will probably help: https://www.google.com/search?q=dbd-oracle+/usr/ucb/cc:++language+optional+software+p

Re: Help with DBD::Oracle install

2016-02-05 Thread Tim Bunce
Hi. I don't provide support for DBD::Oracle directly. Please email dbi-users@perl.org or, if you'd rather not just yet, then something here will probably help: https://www.google.com/search?q=dbd-oracle+/usr/ucb/cc:++language+optional+software+package+not+installed Tim. On Fri, Feb 0

Re: DBD::Oracle and RHEL Instant Client rpms

2015-10-20 Thread Bruce Johnson
> On Oct 20, 2015, at 2:22 PM, Martin J. Evans wrote: > > > I don't use an RPM based system. I download instantclient basic, devel and > sqlplus zips and unzip them then point DBD::Oracle at them by setting > LD_LIBRARY_PATH. > > Did you download the sqlplus R

Re: DBD::Oracle and RHEL Instant Client rpms

2015-10-20 Thread Martin J. Evans
On 20/10/2015 19:53, Bruce Johnson wrote: Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant client? I installed the Basic and Development IC rpm’s and the DBD installer complained it couldn’t determine what version I had, then complained it couldn’t find demo.mk

DBD::Oracle and RHEL Instant Client rpms

2015-10-20 Thread Bruce Johnson
Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant client? I installed the Basic and Development IC rpm’s and the DBD installer complained it couldn’t determine what version I had, then complained it couldn’t find demo.mk. I finally got it to work by manually

Re: Oracle character column sizes from {PRECISION}

2015-09-08 Thread Steve Baldwin
is a mixture of (nn CHAR) and (nn BYTE). I was hoping to be able to use the information that comes back from the OCIAttrGet (OCI_ATTR_CHAR_USED) call - which as you can see from the trace output DBD::Oracle uses to populate char_used attribute to 1 (nn CHAR) or 0 (nn BYTE). Cheers, Steve On Wed,

Re: Oracle character column sizes from {PRECISION}

2015-09-08 Thread Bruce Johnson
> On Sep 8, 2015, at 3:42 PM, Steve Baldwin wrote: > > I have a table defined as follows: > > SQL> desc sb1 > Name Null?Type > - > C1 VARCHAR2(30 CHAR) > C2

Oracle character column sizes from {PRECISION}

2015-09-08 Thread Steve Baldwin
25ecac0,256eda8,2,25f32b0,31,5,25f45a0,25f46e0,25f4820,mode=DEFAULT,0)=SUCCESS calling OCIAttrSet OCI_ATTR_CHARSET_FORM with csform=1 (SQLCS_IMPLICIT) OCIAttrSet(25ec4b0,OCI_HTYPE_DEFINE, 25ecb06,0,Attr=OCI_ATTR_CHARSET_FORM,256eda8)=SUCCESS dbd_describe'd 2 columns (row bytes: 150 max, 75 es

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

2015-06-04 Thread Kurt Jaeger
Hi! > > > There's a newer linux-oracle-instantclient-sdk available in the > > > ports (10.2.0.3), and maybe it helps to compile and link a newer > > > DBD::Oracle. > > > > I have that one (actually, those three), but they are nine > > years ol

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

2015-06-04 Thread Kurt Jaeger
Hi! > > There's a newer linux-oracle-instantclient-sdk available in the > > ports (10.2.0.3), and maybe it helps to compile and link a newer > > DBD::Oracle. > > I have that one (actually, those three), but they are nine > years old as well: 20061115_5 is coded i

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

2015-06-04 Thread William Bulley
According to Kurt Jaeger on Thu, 06/04/15 at 09:38: > > My guess: no-one had the need, time and skills to fix it. > > There's a newer linux-oracle-instantclient-sdk available in the > ports (10.2.0.3), and maybe it helps to compile and link a newer > DBD::Oracle. I

Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

2015-06-04 Thread Kurt Jaeger
Hi! > According to Kurt Jaeger on Thu, 06/04/15 at 02:50: > > DBD::Oracle no longer supports Oracle client versions before 9.2 > > Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. > > > > and there is no oracle9-client port on FreeBSD. >

  1   2   3   4   5   6   7   8   9   10   >