Re: RAC install on Linux

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 13 Feb 2018 12:26:00 +0000
Message-ID: <CABe10sazR8DDVpi9-pTrmSuuUHB2QS37hMe2_ws5PrKH6LTU8Q_at_mail.gmail.com>



Hi

The best guide is the official documentation. You can and should supplement this with the Cluster Verification Utility cluvfy https://docs.oracle. com/en/database/oracle/oracle-database/12.2/cwadd/cluster- -utility-reference.html#GUID-B445A858-
9F00-4423-990E-109545AC11C3 and the orachk tool which you can get from Note 1268927.2 - cluvfy will verify you meet the documented requirements as you describe. orachk adds some best practice type checks to the mix, in the case of cluvfy get the latest 12.1 version, in the case of orachk just get the latest. If you have a laptop and some time working through RACAttack might help you understand what is going on https://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_12c . At
this stage of the lifecyle, I'd definitely suggest you consider 12.2 rather than 12.1 unless you have a good reason to stick on 12.1.

Simulating production load is a hard task - and tools that do it well do cost quite a lot - if you have an in-house dev team you might be licensed for load testing tools already. You might however consider an artificial benchmark such as swingbench <http://dominicgiles.com/swingbench.html> and compare the performance of the existing setup with the new one. This won't be an exact guide to *your* application but should give you some idea of differences between the platforms. If you are changing processors I'm a fan of using the SLOB <https://kevinclosson.net/slob/> LIO benchmark to measure raw oracle CPU performance and if changing storage then using the PIO benchmark to measure that.

On Tue, Feb 13, 2018 at 4:33 AM, Orlando L <oralrnr_at_gmail.com> wrote:

> List
>
> We are planning to install Oracle RAC 12.1 on Linux 7.
>
> 1) I am looking for a step by step instruction guide if any one has it. Or
> point me to a good link. I am more interested in the OS settings,
> os patches, potential trips, etc,
>
> It should be straight forward till I saw today in the official Grid
> infrastructure install guide that you should disable Transparent Huge pages
> in Linux and that it is enabled by default. I started wondering what else
> I could have missed buried in there.
>
> 2) Another thing helpful would be any tool that we could use to simulate
> the current production load in the new env. I considered RAT, but that is
> out of qn because of the $
>
> Thanks
> Orlando.
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 13 2018 - 13:26:00 CET

Original text of this message