Home » RDBMS Server » Server Administration » ORA-01019: unable to allocate memory in the user (Oracle 10g)
ORA-01019: unable to allocate memory in the user [message #526076] Sat, 08 October 2011 01:42 Go to next message
m3nhaq
Messages: 20
Registered: September 2011
Location: Pakistan
Junior Member
Hi Friends!

I have installed Oracle 10g on my PC and create a Database on it. I wanted to connect it with PL Sql Developer with the same PC but it`s not connecting. It gives the following
error "ORA-01019: unable to allocate memory in the user "
And some time blank error message box.

Here is system information:
OS: Winsows 7
Oracle Database 10g Express Edition
PL SQL Developer 8.0.3.1510

Login Setting

User Name: book
Password: oracle
Database: XE
Connect as: Normal


Please advice me the settings.
Thanks
Re: ORA-01019: unable to allocate memory in the user [message #526084 is a reply to message #526076] Sat, 08 October 2011 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.


As this is windows, then increase your RAM or decrease the SGA/PGA parameters.
Also XE allows only a limited amount of 1GB memory.

Regards
Michel
Re: ORA-01019: unable to allocate memory in the user [message #526085 is a reply to message #526084] Sat, 08 October 2011 02:09 Go to previous messageGo to next message
m3nhaq
Messages: 20
Registered: September 2011
Location: Pakistan
Junior Member
As this is windows, then increase your RAM or decrease the SGA/PGA parameters.
Also XE allows only a limited amount of 1GB memory.


Kindly tell me the steps how can I increase RAM or decrease the SGA/PGA parameters??

Please
Re: ORA-01019: unable to allocate memory in the user [message #526086 is a reply to message #526085] Sat, 08 October 2011 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Increase RAM: go to shop and buy chipset
2/ Parameters: connect / as sysdba and execute
show paramater sga
show parameter pga

I advise you to watch Stephane Faroult's YouTube videos named "Oracle DBA Lite: an introduction to Oracle" (parts 1 to 7); they are based on Oracle XE.

Regards
Michel
Re: ORA-01019: unable to allocate memory in the user [message #526092 is a reply to message #526086] Sat, 08 October 2011 03:07 Go to previous messageGo to next message
m3nhaq
Messages: 20
Registered: September 2011
Location: Pakistan
Junior Member
I have already 2GB of memory Sad. How much it needs to run?
Re: ORA-01019: unable to allocate memory in the user [message #526095 is a reply to message #526092] Sat, 08 October 2011 03:40 Go to previous message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please see the videos I pointed you to and then come back.

Regards
Michel
Previous Topic: ASM instance did not access raw devices
Next Topic: role can not login
Goto Forum:
  


Current Time: Thu Apr 24 10:29:19 CDT 2014

Total time taken to generate the page: 0.09568 seconds