This section describes the recommended zoning configuration on the Dell EMC Connectrix DS6x10-B FC switches that this Ready Solutions for Oracle supports. The recommended configuration ensures that a path is always available for the Oracle database servers to reach the storage, even if failure occurs with an HBA port, HBA, switch, XtremIO controller, or XtremIO X-Brick.
The following figure shows the logical connectivity view between the initiators on the database servers and the target front-end FC ports on the XtremIO after the recommended zoning configurations are created on the redundant FC switches. It shows the logical view of the two-node Oracle RAC production database environment. The same design and configuration is used for the XVC database and the virtual database servers setup.
Zoning is configured so that each host initiator in the database server is zoned to four target front-end FC ports that are on four separate XtremIO storage controllers.
Figure 11. SAN setup: Zoning logical view
To implement the recommended zoning on each FC switch:
DS6510B_U36:admin> alicreate "R940-Phy-N1-S2P0", "10:00:00:90:fa:c7:b7:bb"
where R940 represents the PowerEdge server type, Phy represents the environment (physical) the server is used in, N1 represents the node number (node 1), S2 represents the PCIe slot (slot 2) that the HBA is populated in, and P0 represents the port (port 0) on the HBA that is connected to the FC switch.
DS6510B_U36:admin> alicreate "XIOX2-X2-SC2-P3", "51:4f:0c:50:37:67:83:11"
where XIOX2 represents XtremIO X2, X2 represents X-Brick number 2, SC2 represents the controller number 2, and P3 represents the port number on the front-end HBA within the controller.
As shown in Figure 11, in each zone set you must include one initiator (alias) from the database server and four target front-end FC ports that belong to four separate controllers on the XtremIO X2 array.
DS6510B_U36:admin> zonecreate "R940-Phy-N1-XIOX2-P3-Zone1", "R940-Phy-N1-S2P0; XIOX2-X1-SC1-P3; XIOX2-X1-SC2-P3; XIOX2-X2-SC1-P3; XIOX2-X2-SC2-P3"
where R940-Phy-N1-S2P0 represents a single initiator on one of the database servers and XIOX2-X1-SC1-P3; XIOX2-X1-SC2-P3; XIOX2-X2-SC1-P3; XIOX2-X2-SC2-P3represents the FC port 3 on each of the four XtremIO controllers that are connected to this switch.
DS6510B_U36:admin> cfgcreate "DBZONE_RS-Oracle-XIOX2_CONFIG", " R940-Phy-N1-XIOX2-P3-Zone1; R940-Phy-N1-XIOX2-P3-Zone2; R940-Phy-N2-XIOX2-P3-Zone1; R940-Phy-N2-XIOX2-P3-Zone2; R940-Virt-XIOX2-P3-Zone1; R940-Virt-XIOX2-P3-Zone2; R940-XVC-XIOX2-P3-Zone1; R940-XVC-XIOX2-P3-Zone1;"