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

November 7, 2008

10g RAC installation – copy files to remote node error

Filed under: [Installation] — zhefeng @ 9:36 am

When i installed the database software on two nodes RAC, got error like below:

When copying files to remote nodes during a 10.2 RAC installation you may see the following error on the screen and in the installActions.log file:

INFO: Saving Cluster Inventory
SEVERE: oracle.sysman.oii.oiip.oiipg.OiipgRemoteFileOperationException: Bootstrapping installer to nodes failed.Dir path
is /tmp/OraInstall2005-06-01_04-11-13PM. [PRKC-1002 : All the submitted commands did not execute successfully]
———————————————————————————-
opcbrh2:
/bin/tar: ./common/rulemap.xml: time stamp 2005-06-01 16:11:22 is 609 s in the future
/bin/tar: ./common: time stamp 2005-06-01 16:13:24 is 731 s in the future
/bin/tar: ./cpuinfo.txt: time stamp 2005-06-01 16:13:29 is 736 s in the future
…continued…

That’s because the two nodes have different time. The solution is using NTP on both nodes and sync the time to the same.

1. edit /etc/ntp.conf

add one line:

server ntpdhost.rd.crystald.net  #you can also use other NTP servers like http://www.pool.ntp.org/

2. sync the time with NTP server

#ntpdate -u ntpdhost.rd.crystald.net

3. start the NTP service

#service ntpd start

4.test date for both node

bash-3.1$ date;ssh vanpgvmrac02 date
Fri Nov  7 09:35:33 PST 2008
Fri Nov  7 09:35:33 PST 2008

After the time has been synchronized, the installation could be completed successfully.

November 6, 2008

Bypassing syscheck when install oracle 10g on Redhat EL5

Filed under: [Installation] — zhefeng @ 1:17 pm

When you do oracle 10g installation on Redhat EL5, you may failed to pass the syscheck because 10g is not certified on EL5. The eaiest way to bypass it is adding a switch:

$runInstaller -ignoreSysPrereqs

Create a free website or blog at WordPress.com.