?
Solved

ClickOnce: Error while trying to retrieve text for error ORA-01019

Posted on 2006-06-08
4
Medium Priority
?
5,278 Views
Last Modified: 2007-12-19
I was trying to deploy my application with ClickOnce using C# 2.0, VS2005, windows app.
After the app detect there is a latest version, it downloads the latest and restarts the app.
Error occurred after the restarts:

Error while trying to retrieve text for error ORA-01019

Stack Trace:
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
...

Check on Oracle Document says:
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.

Can anyone helps? What went wrong?
0
Comment
Question by:michellechan57
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
topdog770 earned 1500 total points
ID: 16870915
It almost sounds as though there are some Oledb objects getting created when your app starts that don't get cleaned up correctly when the app does a shutdown in prep for being updated.

0
 

Author Comment

by:michellechan57
ID: 16875333
Any suggestions to cleaned up correctly?

I called close method of OleDbDataReader after finish reading all data and
close method of OleDbConnection is in finally block to ensure that all connection are closed.
I have also used OleDbCommand and OleDbDataAdapter.
0
 

Author Comment

by:michellechan57
ID: 16965571
Can I request to delete this question?
0
 
LVL 12

Expert Comment

by:topdog770
ID: 16970429
michelle, I'm sorry, I lost track of this question.. I'm certainly ok with your delete request, did you get the issue resolved?

If not, two things to check..

First, if you have installed several versions of Oracle on a computer, there are some web threads that have correlated "left over" oracle 'stuff' causing this oracle error, where the 'left over' pieces can be either registry settings, etc and or code specific issues( where taking the same code into a new project allowed the Oracle connection process to occur successfully )

Also, ( indirect example ) http://help.netscape.com/kb/corporate/19970825-5.html

We have seen this issue.  ( We started using a much earlier version of Oracle ( 6 or 7) it was before my time here, and we've had to maintain this NLS_LANG=american_america.US7ASCII setting even into our current flavor on Oracle 9, or 10 now, in order to allow some of our applications to be able to connect properly.


0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question