DBA Sensation

April 12, 2012

Set Oracle SGA > 256GB

Filed under: [Installation] — Tags: , , — zhefeng @ 2:06 pm

I had a installation request for installing Oracle 11gR2 on a 2TB memory server. The installation failed on DBCA with complains about can’t reach shared memory.

Check the metalink didn’t find any solution. My colleague told me he was having the same issue before. Oracle told him to set SGA less than 256 GB as a “workaround”.

I followed “workaround” and continued my installation. Later I did some research and I found this:

 

Solution

Checking the swap and the kernel parameters, everything was adjusted as per recommended by oracle, investigating the issue further, seems that This is caused by the prelink command. It calculates shared library load addresses, and updates the shared libraries with them. Simplest thing to do is to undo what prelink did, and disable it.
prelink -ua
sed -i ‘s/PRELINKING=yes/PRELINKING=no/’ /etc/sysconfig/prelink

 

From: https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocTitle=Why%20not%20able%20to%20allocate%20a%20more%20SGA%20than%20193G%20on%20Linux%2064?&from=BOOKMARK&bmDocType=HOWTO&bmDocID=1241284.1&viewingMode=1143&bmDocDsrc=KB%29%29

Doc ID: 1241284.1

I haven’t tried it yet. anyone is having the same problem can give a try and let me know.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: