Testing for Availability - Expert Oracle RAC Performance Diagnostics and Tuning - page 69

■ this is a critical test and should not be compromised. all failure points should be tested until the expected
results are achieved. a detailed sample spreadsheet containing the failure points to be tested is provided in appendix D.

Note

Workshop
RAP Phase I checks for availability of the components and indirectly tests the stability of the cluster under load. In this
workshop, we cover scenarios of testing a few components of the hardware.
This phase of the testing can be completed very early in the RAC migration process. Once the production
hardware is ready and configured, this test should be completed. Under no circumstances should any of the
RAP phases be ignored or compromised. The opportunity to identify and fix problems may not be available once
the environment is in production; and it could become really late in the game when components start failing in
production, defeating the entire goal of providing HA to the database.

Step 1
Gather all the required component information and create a test plan for those components that are prone to failures.
List all components that can fail and interrupt the HA of the database environment. Examples of such components are

1. Interconnect or private NIC

2. HBA

3. Public NIC

4. Host/nodes

Table 3-1. RAP Phase 1—Test Results Recorder

Test # Host Name Interface Test Method Expected

Behavior

Observation /
Result

Status Node1 Node2 Node3

The list should be created using a spreadsheet and all interfaces, including IP address (see Table 3-1 ).

Test # : Because there will be a sequence of tests, this column contains the test number.

Host name : This is the physical name assigned to the host. For example, if we are testing the
private interconnect, the name here would be prddb1-priv.summersky.com or the short
name prrddb1-priv.

Interface : This is the name of the physical interface. For example, if the private interface is
being tested, and the interface name assigned by the O/S is eth24, list eth24 in this column.

Test Method : What kind of testing method do you plan to use to simulate failure of this
interface?

a. Physically pull the cable.

b. Disable the port from the O/S: From the O/S prompt, disable the port.