Last time, all components (network, storage, Grid infrastructure…) are prepared for Oracle database RAC installation with a minimal time and effort thanks to Flashgrid’s wizard which, behind the scene, is using Cloud Formation template to setup everything, including installation of all necessary patches available at the time of installation.
You can find more on the following link:
This time I’ll continue with database creation assistant (dbca) wizard to install the database itself.
For the purpose of this test, I didn’t change much from default (besides switching from Automatic Memory Management to Automatic Shared Memory Management, some parameters, log size and fiel location).
The only surprise during the database installation is a Linux swap – which is deliberately disabled while running code-as-a-template wizzard (check my previous blog), because it might cause node eviction and similar issues when running Oracle RAC under the heavy load.
For that reason you should ignore Oracle’s prerequisite check as you can see on the following picture.
Next task is to generate Simple Order Entry schema which is part of the Swingbench stress testing tool created by Dominic Giles.
More information about Swingbench you can find on the following link:
You should generate at least 100 GB of data for stress test to be valid, where 1 TB is preferred but also time consuming and costly (we are in the Cloud where you pay per minute/load).
For that reason I stayed at 100 GB which is quite enough for the purpose of this test.
Here are the steps to create SOE schema
Next time I’ll present results from the performance test.