:

ORA-01019: unable to allocate memory in the user side

ORA-01019 unable to allocate memory in user side

The Problem

One of the in-house developed tools which connects to the database to allow a user to perform configuration updates was throwing an error:

ORA-01019: unable to allocate memory in the user side

Most of the docs that I could find online told me the same thing, namely:

Cause: The user side memory allocator returned error
Action: Increase the processes heap size or switch to the old set of calls

However, sometimes the Oracle errors that you receive don’t seem to be that helpful in actually determining what the problem is. The ORA-01019 error is no exception in this case…You will find numerous forums online which tell you to fix the ORA-01019 error by “increasing the processes heap size” on the client and that it’s not to do with any configuration, just resource. I have found differently.

The ORA-01019 Solution

So, what you need to check is whether or not you have multiple ORACLE_HOMES installed on the client machine. The reason I say this is because in our case we did. We had an old Oracle 10g client and a new 11g client. We found that the default client was still the 10g one, so when the client was attempting to connect to the database it was using executables and dlls which we didn’t expect or want it to use.

The way to resolve your ORA-01019: unable to allocate memory in the user side is to ensure that you have the correct default path for the Oracle client. The client was running on Windows so if you type PATH from a command prompt it will show you what the default one is.

Change the PATH

You can update this in My Computer -> Properties -> Advanced -> Environment Variables -> then scroll to the System Variables window at the bottom until you see PATH and edit that. Put the path to the Oracle home that you want to use first before any other Oracle home in the list order.

I have some more details about how to change the PATH environment variable in another post if you would like to see some screenshots of where to go and change it.

Like it, share it...

Category: Database Config


Related Posts

Comments (5)

Trackback URL | Comments RSS Feed

  1. Sergio says:

    Muchas gracias por ese valioso aporte, me sirvió muchísimo, pues ya llevaba tiempo de no poder resolver este problema. Felicitaciones y Saludos desde Guatemala.

  2. peyman says:

    clean the new update windows and try agane.

Leave a Reply

Your email address will not be published. Required fields are marked *