Dell Integrated Systems for Oracle Business Analytics - Owner’s Guide v1.
Revisions Date Description December 2014 Initial release 1.0 © 2014 Dell Inc. All rights reserved. Reproduction of this material in any manner whatsoever without the express written permission of Dell Inc. is strictly forbidden. For more information, contact Dell. Dell™, the Dell logo, PowerEdge™, and Force10™ are trademarks of Dell Inc. Other Dell trademarks may be used in this document. Intel® and Xeon® are registered trademarks of Intel Corporation in the U.S. and other countries.
Table of contents 1 Overview - Dell Integrated Systems for Oracle Business Analytics (DISOBA) ................................................................ 4 2 DISOBA Hardware Components ............................................................................................................................................. 7 2.1 Business Analytics (OBIEE) (R730) ................................................................................................................................ 7 2.
1 Overview - Dell Integrated Systems for Oracle Business Analytics (DISOBA) Dell Integrated Systems for Oracle Business Analytics (DISOBA) is a fully integrated hardware stack that is purpose built as a high performance Oracle Business analytical solution by integrating Oracle OBIEE and Oracle Database 12c. The following figure shows the 1.0 release of DISOBA that is a 21 rack-units solution.
DISOBA provides an out-of-box experience to customers where everything up to the point of the Oracle Business analytics and Database software installation is pre-configured. DISOBA ships with the following pre-integrated, pre-configured, racked, stacked and cabled hardware and software: Business Analytics (OBIEE): One Dell PowerEdge R730 server pre-installed and configured with Oracle Linux 6.5 running Unbreakable Enterprise Kernel operating system.
By providing integrated and pre-configured hardware and software solutions, DISOBA provides a fast and easy-to-deploy Oracle Business Analytics integrated with Oracle Database rack solution to the customers. Dell Integrated Systems for Oracle Business Analytics (DISOBA) – Owner’s Guide 1.
2 DISOBA Hardware Components This section provides the hardware details of each of the DISOBA components 2.1 Business Analytics (OBIEE) (R730) The DISOBA solution rack ships with one Dell PowerEdge R730 server that is used as OBIEE server. The following table shows the details of the hardware components within each of these servers: Table 1 OBIEE Server (R730) Hardware Details Database Nodes Hardware Components Servers UP to 1 x 2S Dell PowerEdge R730 CONFIG SMALL Config 1 x E5-2637 v3 3.
The R730 OBIEE servers is pre-installed and pre-configured with Oracle Linux running Unbreakable Enterprise Kernel. For more details on the OS configuration, refer to section OBIEE Server (R730) Configuration 2.2 Database Servers (R920) The DISOBA solution rack ships with two Dell PowerEdge R920 servers that are used as Oracle Database 12c nodes.
The R920 database servers are pre-installed and pre-configured with Oracle Linux running Unbreakable Enterprise Kernel. For more details on the OS configuration, refer to section Database Nodes (R920) Configuration 2.3 Shared Storage – Dell Acceleration Appliances for Databases (DAAD) DISOD ships with Dell Acceleration Appliances for Databases (DAAD) storage array as the high performance, low-latency backend shared storage. The following table lists the DAAD storage array components.
the hardware in the rack. Table 2 shows the model of switches that are used for all the traffic that flows in and out, and within the DISOD Solution rack. DISOD Network Switches LAN Switches (ToR) 2 x Dell Networking S6000 40Gb Ethernet Switches SAN Switches 2 x Brocade 6510 16GB Fibre Channel Switches Management Switch 1 x Dell Networking S60 1Gb Ethernet Switch Table 2 DISOD Network Switches The following sub-sections describe these switches in more detail. 2.4.
Using one of the Fibre Channel switches as an example, the following figure shows the pre-defined port connectivity configuration between 6510 and the database nodes, and between 6510 and the DAAD storage array nodes. The two database nodes are referred to as DB-N1 and DB-N2, and the two DAAD storage array nodes are referred to as DAAD1 and DAAD2. Port range 0-7 are used for connecting to the DAAD storage array nodes and port range 8-15 are used to connect to the database nodes.
Remote Management RAID Controller Local Storage iDRAC7 Enterprise PERC H310 (RAID 1) 2 x 500 GB 7.2K 3Gbps SAS 3.5in Hot-plug Hard Drives Per Server Operating System Oracle Linux 6.
3 DISOBA Network Configuration This section provides the hardware and software networking details that DISOBA ships with. It provides details on the following network configuration: 3.
Switches DISOBA Component Port IP Address Netmask Network Address Subnet Class U41-S6000 Management 192.168.211.1 255.255.255.224 192.168.211.0 /27 U40-S6000 Management 192.168.211.2 255.255.255.224 192.168.211.0 /27 U39-S60 Management 192.168.211.3 255.255.255.224 192.168.211.0 /27 U16-6510 Management 192.168.211.4 255.255.255.224 192.168.211.0 /27 U15-6510 Management 192.168.211.5 255.255.255.224 192.168.211.
3.2 S6000 Switch Configurations This section provides the details of the configuration that the S6000 switches ship with. 3.2.1 S6000 Pre-defined Port Functions Using one of the S6000 switches as an example, the following figure shows the details of the pre-defined port functions and configuration.
3.2.2 S6000 VLAN and Port Channel Configuration 124 84 80 120 76 72 116 68 64 108 60 56 112 52 48 104 44 40 92 36 32 100 28 24 96 20 88 12 8 16 0 4 Though it is typically recommended to have dedicated switches for the Oracle database’s public and private traffic, in this pre-integrated solution, the S6000 switches are used for handling both types of traffic.
VLT Backup Link Mgmt 0/0 Fo 0/100 Fo 0/108 U41-S6000 Fo 0/116 Fo 0/124 Te 0/68 Fo 0/100 VLTi Trunk Po 128 Mgmt 0/0 Fo 0/108 U40-S6000 Fo 0/116 Fo 0/124 Tagged VLAN 10 Tagged VLAN 10 VLT Peer LAG Po 1 Te 0/68 Po 1 VLT Domain 1 Po = Port Channel Po 1 Te 0/48 Tagged VLAN 10 Tagged VLAN 10 U39-S60 (Front) Te 0/50 U39-S60 (Rear) U39-S60 S6000 VLT Domain Configuration 3.2.
3.4 Management and Monitoring Network DISOBA solution rack has a built-in single point of management using a dedicated infrastructure management network and management node. Using the DISOBA management infrastructure, Customers and Dell Services/Support can remotely manage and monitor any of the hardware components. Figure 12 shows how the DISOBA management infrastructure is setup for providing the remote access to manage and monitor the solution rack.
ports 0/4 and 0/5 on the S60 management switch is connected to the public network adapters on the R320 management server. This is the route in to the management server from the customer’s public environment that is isolated as VLAN 10 network traffic. Once connected to the management server, any of the DISOBA hardware components that are on the isolated private rack network VLAN 30 can be accessed for management or monitoring.
4 DISOBA Software Configuration This section describes all the software configuration that the following hardware components in the DISOD ships with: 4.1 DAAD Storage Array Configuration OBIEE Server (R730) Configuration Database Nodes (R920s) Configuration Management Server (R320) Configuration DAAD Storage Array Configuration This section provides the details of the DAAD storage array that is configured using Dell and Fusion-io’s best practices for Oracle Database.
us to balance the workloads evenly over two storage array nodes while maintaining redundancy for high availability. Each of these eight volumes is created with the same size as they will be presented to the Oracle database nodes to form Oracle ASM disks of an ASM disk group.
fcion1_v_c1 fcion1_v_c2 fcion1_v_d1 fcion1_v_d2 Eight volumes of size 1.5TB each, giving a total raw storage capacity of 12TB are mapped to the database nodes for Oracle Database usage. Refer to section Shared Storage Volume Partitions for further details on how these eight volumes are configured on the database nodes. 4.2 OBIEE Server (R730) Configuration This section described the OS pre-configuration that is applied on the OBIEE server to ease the Oracle Business Analytics deployment at the customer.
Create special oracle user with specific groups and permissions for Oracle BI To supplement the Oracle BI 11g preinstall utility, an additional customized deployment utility is used. This utility builds on top of the preinstall utility, and takes additional steps to ensure that the environment is setup properly. Some of the steps include: 4.2.
4.3.2 BIOS matches our supported configuration All hardware firmware matches the supported version Each R920 has two 900GB local HDDs in RAID 1 Logical volume configuration: o 60GB /usr/home o 17GB swap (minimum 16GB + 1KB required by Oracle) o Rest dedicated to /u01 to be used for Oracle database software installation Oracle Database 12c Pre-Installation Setup The database nodes come pre-installed with OL 6.5 running UEK3 (3.8.13-44).
2. Eight 1485 GB partitions or disks, for a total of 11.88 TB, that are available for data files, FRA, REDO log files, etc. NOTE: Though DISOBA provides up to eight partitions or disks for OCR and VDs, it is recommended to create its ASM diskgroup with Normal Redundancy. DAAD’s HA feature provides three additional mirrored copies residing on separate disks on top of the Normal Redundancy, giving all-together six copies. 4.3.
networks over two cards, we are able to eliminate the possibility of a downed card resulting in lost communication. The public interfaces are in Linux bonded mode 1, which is an active-backup configuration. This means that if a single public interface loses connection, there is always an alternate path that takes over to ensure continuous communication. NOTE: The public network interface is not pre-assigned with an IP address and requires to be assigned at the customer’s site.
A DISOBA Rack Hardware Cabling Diagrams DISOBA components are pre-cabled before they are shipped out to the customer. This section provides the rack cabling diagrams for reference. The diagrams are divided on the following logical basis: A.
Cabling Diagram – LAN Infrastructure A.2 Cabling Diagram - SAN Infrastructure This section provides the cabling diagram for the hardware components that are part of the SAN infrastructure.
A.3 Cabling Diagram - Management Infrastructure This section provides the cabling diagram for the hardware components that are part of the management infrastructure. Data Center Public Network P68-AAAA ToR (S6000u41) P68-AAAA ToR (S6000u40) Mgmt. (S60u39-Front) Mgmt. (S60u39-Rear) Mgmt.
B DISOBA Authentication Settings The hardware components in the DISOBA solution rack ship with the following default authentication settings: root/oracle : BI node (R730), Database nodes (R920s) and management server (R320) admin/oracle : DAAD storage array nodes admin/password: Management switch (S60), Top-of-Rack S6000 switches and the SAN Brocade 6510 switches root/calvin : iDRAC It is highly recommended to change these default settings before connecting the DISOBA solution rack to the custome