Home » Open Source » Programming Interfaces » Error while trying to retrieve text for error ORA-01019
Error while trying to retrieve text for error ORA-01019 [message #302770] Wed, 27 February 2008 00:18 Go to next message
AndrewG1976
Messages: 7
Registered: June 2005
Junior Member
I am getting the following error when trying to connect (using ODBCTest) to an Oracle 10g (Release 10.2.0.2.0) database using the Microsoft ODBC Driver for Oracle on a Windows 2000 Server machine:

[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019'

I have installed the Oracle XE Client Release 10.2.0.1.0 and have created the SQL*Net connection to the database and can connect it it through SQL*Plus.

The ODBC driver details are:

Name: Microsoft ODBC driver for Oracle
Version: 2.575.1064.00
Date: 12/12/2006

The description of the Oracle error is:

ORA-01019: unable to allocate memory in the user side
Cause: The user side memory allocator returned error.
Action: Increase the processes heap size or switch to the old set of calls

How do I "increase the processes heap size" or "switch to the old set of calls"?

Thanks

[Updated on: Wed, 27 February 2008 00:22]

Report message to a moderator

Re: Error while trying to retrieve text for error ORA-01019 [message #302818 is a reply to message #302770] Wed, 27 February 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advice you to use Oracle driver.

Regards
Michel
Re: Error while trying to retrieve text for error ORA-01019 [message #303060 is a reply to message #302818] Wed, 27 February 2008 19:15 Go to previous message
AndrewG1976
Messages: 7
Registered: June 2005
Junior Member
The Oracle XE Driver gave me the error "Cannot load resource file sqresus.dll", so I removed the Oracle XE Client and installed the normal Oracle 10.2.0.1 client and it works now.

[Updated on: Wed, 27 February 2008 19:16]

Report message to a moderator

Previous Topic: Perl DBI: Check is item exist and performance
Next Topic: Reading LOBS using Perl - help!!
Goto Forum:
  


Current Time: Thu Mar 28 06:09:39 CDT 2024