ORA-27102 error after increasing memory
I increased the RAM from 2GB to 3GB, but when I try to increase the sga_max_size I get the following error on startup: "ORA-27102: out of memory."
If you are running the 64-bit version of Linux and Oracle, then check the SHMALL Kernel setting. It may be set too low. It should be set to value of SHMMAX divided by the page size. To get your systems page size run the following command.
getconf PAGE_SIZE
If you are not running the 64-bit version, you are getting this error because with the 32-bit version of Oracle, there is a 1.7 Gig SGA memory limitation. There is a way to increase this limitation to 2.7 Gig but you have to lower the base mapped memory address of Oracle and then relink Oracle software. The following metalink document goes into the detail on how to do this but you still will not be able to increase it to 3 Gig: "200266.1 - Increasing Usable Address Space for Oracle on 32-bit Linux."
Dig Deeper on Oracle error messages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments