OraFAQ Forum: Programming Interfaces » Error while trying to retrieve text for error ORA-01019

Home » Open Source » Programming Interfaces » Error while trying to retrieve text for error ORA-01019

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while trying to retrieve text for error ORA-01019 [message #302770]

Wed, 27 February 2008 00:18

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I advice you to use Oracle driver.

Regards
Michel

Report message to a moderator

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 18:17:23 CST 2024