I have an Oracle 10g R2 database that I run on Linux Enterprise Edition 2.4.21-4.ELsmp. I recently 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." I modified the kernel parameter shmmax from 2147483648 to 3221225472, but the error still persists. Would you help me please?

    Requires Free Membership to View

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."

This was first published in June 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: