Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones
DBD::Oracle uses Oracle's OCI not JDBC. The official OCI Support matrix is Document #207303.1 (for those with MOS access). Chris On 9/08/2016 1:07 AM, Mike Towery wrote: *Which version of JDBC drivers support which version of Oracle database?* Please refer to the table below for the Oracle

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones
You possibly need to bring your 10g client up to date with patches so authentication succeeds; I've seen similar things in the past. But, in general, why use 10g client if you are connecting to 12c? You may as well use the 12c client. I forget whether 8i used service names or only the old

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones
You can connect to 12c using 10gR2 client. Chris On 9/08/2016 12:40 AM, Mike Towery wrote: I don't think the 10G Oracle client works with Oracle 12. Have you tried the Oracle 12 client? On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris > wrote:

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'" ,

Re: (Fwd) Oracle.pm

2017-03-12 Thread Christopher Jones
On 8/3/17 3:45 am, Bruce Johnson wrote: On Mar 6, 2017, at 5:59 PM, Gowtham > wrote: Hi Ron, I did that. I have two scenarios here. Both the scenarios have same ($dbh,$dbname,$user,$auth,$attr) values. Scenario 1: executed

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

2017-03-06 Thread Christopher Jones
On 7/3/17 4:38 am, Douglas Wilson wrote: After some searching, I tried using the ora_connect_with_default_signals with INT and CHLD, and tried setting BEQUEATH_DETACH=yes in a local sqlnet.ora, but still same result. Stack trace? Versions? Have you worked back from the point of the

Re: Perl DBI libraries for connecting 12c

2017-10-10 Thread Christopher Jones
On 10/10/17 3:42 pm, John R Pierce wrote: On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the

Re: I probably mentioned this the last time I installed DBD:Oracle but I couldn't find it...

2017-10-22 Thread Christopher Jones
On 18/10/17 8:06 am, Bruce Johnson wrote: Oracle’s latest instant client for 64-bit linux puts the demo.mk file in /usr/share/oracle/12.2/client64/demo The DBD::Oracle installer only looks in /usr/share/oracle/12.2/client64/ to find it and thus installing from cpan fails. Dunno if this is

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

Re: Perl script excessively executing statement

2020-02-17 Thread Christopher Jones
On 18/2/20 9:51 am, JohnD Blackburn wrote: The problem is not about how well the SQL runs. It runs in less than a second, and it should only be getting executed 12 times an hour. What I'm trying to do is to figure out how the SQL statement got executed 1000 times more than it should have

Re: Perl script excessively executing statement

2020-02-13 Thread Christopher Jones
will come from the execute() - bogus syntax, wrong columns, DB space errors etc. Chris *From:* Christopher Jones *Sent:* Thursday, 13 February 2020 12:56 PM *To:* dbi-users@perl.org; JohnD Blackburn *Subject:* Re: Perl script excessively executing statement *CAUTION:*This email originated from

Re: Perl script excessively executing statement

2020-02-12 Thread Christopher Jones
On 13/2/20 11:13 am, JohnD Blackburn wrote: Is that a behavior of DBI or DBD::Oracle? Maybe your script, if you are blindly looping when it gets an error?  Overall, I don't think there is enough information to point directly at a cause.  Presumably the DBA meant that a SQL statement (of some

Re: DBD error

2020-07-19 Thread Christopher Jones
On 17/7/20 10:02 pm, Bala GANESH wrote: Hi Support, "Support" ? :) I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL

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 but I did not get proper answer. Module DBD::Oracle

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 "session pooling", which is not