OraFAQ Forum: Server Administration » ORA-01019: unable to allocate memory in the user

Home » RDBMS Server » Server Administration » ORA-01019: unable to allocate memory in the user (Oracle 10g)

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

ORA-01019: unable to allocate memory in the user [message #526076]

Sat, 08 October 2011 01:42

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

Report message to a moderator

Re: ORA-01019: unable to allocate memory in the user [message #526084 is a reply to message #526076]

Sat, 08 October 2011 01:59

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: ORA-01019: unable to allocate memory in the user [message #526085 is a reply to message #526084]

Sat, 08 October 2011 02:09

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

Report message to a moderator

Re: ORA-01019: unable to allocate memory in the user [message #526086 is a reply to message #526085]

Sat, 08 October 2011 02:36

Michel Cadot
Messages: 68645
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

Report message to a moderator