Home » RDBMS Server » Server Administration » "ORA-27102: out of memory" and SGA (Oracle 10.2.0.4, 32-bit, Solaris 10x86)
"ORA-27102: out of memory" and SGA [message #389207] Fri, 27 February 2009 10:56 Go to next message
gatsby
Messages: 21
Registered: March 2006
Junior Member
I am running a Oracle 10.2.0.4 database instance (32-bit) on a Solaris 10x86 machine. I have about 16GB of RAM on this machine.

When I set my sga_max_size and sga_target to a value over ~3000M (something like 7000M) and try to start it through SQL*Plus, I get a "ORA-27102: out of memory" error. The database will not start. The only resolution I have found for this error is to lower the SGA parameters back to ~3000M or below, and the database then starts up normally. I would like to assign more than 3GB of memory to the SGA if possible.

I created a project that should be assigning my oracle user access to 10GB of memory, but this does not seem to be working.

%> prctl -n project.max-shm-memory -i project user.oracle
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 10.0GB - deny -
system 16.0EB max deny -

Is there something in the 32-bit version of Oracle that does not allow the SGA to exceed ~3GB? Am I overlooking something? Thanks in advance.
Re: "ORA-27102: out of memory" and SGA [message #389208 is a reply to message #389207] Fri, 27 February 2009 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Is there something in the 32-bit version of Oracle that does not allow the SGA to exceed ~3GB?
Yes, It is a compile/link time "variable".
Visit Metalink to find NOTE which provides steps to re-link Oracle to allow larger than default SGA.
Re: "ORA-27102: out of memory" and SGA [message #389229 is a reply to message #389207] Fri, 27 February 2009 12:41 Go to previous message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html
Previous Topic: moving to new database after reducing table spaces
Next Topic: datafile resize
Goto Forum:
  


Current Time: Tue Dec 06 00:15:06 CST 2016

Total time taken to generate the page: 0.04892 seconds