From owner-freebsd-database@FreeBSD.ORG  Wed Jan  7 05:07:16 2004
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 9ED4C16A4D0
	for <freebsd-database@freebsd.org>;
	Wed,  7 Jan 2004 05:07:16 -0800 (PST)
Received: from oughtred.numericable.net (oughtred.numericable.net
	[80.236.0.153])	by mx1.FreeBSD.org (Postfix) with ESMTP id 13D3343D53
	for <freebsd-database@freebsd.org>;
	Wed,  7 Jan 2004 05:07:12 -0800 (PST)
	(envelope-from vitalisREMOVETHAT@numericable.fr)
Received: (qmail 27747 invoked from network); 7 Jan 2004 13:07:10 -0000
Received: from unknown (HELO [81.220.240.150]) ([81.220.240.150])
          (envelope-sender <vitalisREMOVETHAT@numericable.fr>)
          by oughtred.numericable.net (qmail-ldap-1.03) with SMTP
          for <freebsd-database@freebsd.org>; 7 Jan 2004 13:07:10 -0000
From: Vitalis <vitalisREMOVETHAT@numericable.fr>
To: database <freebsd-database@freebsd.org>,
	questions <freebsd-questions@freebsd.org>
Content-Type: text/plain
Message-Id: <1073480834.653.22.camel@localhost.ice-age.org>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Wed, 07 Jan 2004 14:07:14 +0100
Content-Transfer-Encoding: 7bit
cc: skv@freebsd.org
Subject: Re: p5-DBD-Oracle-1.14 with 9i
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 07 Jan 2004 13:07:16 -0000

Lukas Ertl wrote:

>On Tue, 6 Jan 2004, Vitalis wrote:
>
>> Should this driver also work for Oracle 9i?
>>
>> I get the following error at connection, though I don't think there is a
>> real memory problem:
>>
>> DBI connect('MYBASE','mylogin',...) failed:  at ./connect.pl line 4
>> ORA-01019: unable to allocate memory in the user side (DBD: login
>> failed, probably a symptom of a deeper problem) at ./connect.pl line 4.
>>
>> I'm running freebsd 5.1 SMP enabled, Oracle 9i, oracle7-client-0.02,
>> p5-DBI-137-1.37 and p5-DBD-Oracle-1.14, all on the same box.
>
>Unfortunately, you can't connect to Oracle 9i with an Oracle 7 client. :-/

Hi Lukas. Thanks for your answer but this is not true =)
I finally managed to make it working.

After many tests, I figured out that the problem was with the first database
I was trying to connect to. Oracle 7 client does not seem to work with a 9i 
database with the WE8ISO8859P15 character set! With WE8ISO8859P1, it works well.

So you weren't completely wrong...


For the archiving purpose, here are the other errors I got with the 
WE8ISO8859P15 database when tracking down this issue:

Error while trying to retrieve text for error ORA-03113 (DBD: login failed) at ./connect.pl line 4.

In the alert.log file:
ORA-07445: exception encountered: core dump [08D941EB] [SIGSEGV] [unknown code] [0x38] [] []
ORA-00600: internal error code, arguments: [12333], [10], [0], [115], [], [], [], []