Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex

• 1

  Business case
• 2

  Dell EMC PowerFlex
• 3

  Oracle Big Data SQL
• 4

  Document purpose
• 5

  Audience
• 6

  Deployment workflow
• 7

  We value your feedback

• 1

  Overview
• 2

  Logical architecture

• 1

  Hardware components
• 2

  Data center requirements

• 1

  Phase I: Infrastructure design and deployment
• 2

  PowerFlex Hardware components
• 3

  PowerFlex software components
• 4

  Flexible deployment options
• 5

  Deploying the PowerFlex hyperconverged infrastructure
• 6

  Configuring ESXi hosts
• 7

  Creating the VMs

• 1

  Overview
• 2

  VM networking
• 3

  Network design

• 1

  Phase II: Storage design
• 2

  Database application storage design
• 3

  VM operating system data store and hard disks design
• 4

  For VM hosting Oracle: Operating system devices and Oracle ASM disk group design

• 1

  Phase III: Oracle 19c database design and deployment
• 2

  Deploying an Oracle 19c Standalone Server with Oracle Linux 7.6 on vSphere 7
• 3

  Creating the Oracle 19c Standalone PROD database

• 1

  Introduction
• 2

  Configuring the Cloudera Manager Server
• 3

  Configuring Cloudera Hadoop from Cloudera Manager Server

• 1

  Introduction
• 2

  Configuring Big Data SQL on Hadoop clusters
• 3

  Configuring Big Data SQL on the Oracle Database host

• 1

  Introduction
• 2

  Configuring Oracle NOSQL

• 1

  Microsoft SQL Server design and deployment
• 2

  Microsoft SQL Server database layer best practices

• 1

  Oracle Gateways design and deployment

• 1

  Generate and load data
• 2

  Installing and loading TPCH data using DBGEN
• 3

  Cleaning the data
• 4

  Loading TPCH data in Oracle NoSQL
• 5

  Loading TPCH data in Hadoop
• 6

  Loading TPCH data into the Oracle database
• 7

  Loading TPCH Schema on Microsoft SQL Server
• 8

  Creating Oracle external tables pointing to Oracle NoSQL kvstore
• 9

  Creating Oracle external tables pointing to HDFS
• 10

  Accessing Microsoft SQL Server tables using Oracle Gateways
• 11

  Data virtualization with Big Data SQL

• 1

  Dell Technologies documentation
• 2

  VMware documentation
• 3

  Oracle documentation
• 4

  Cloudera documentation

• 1

  Appendix A
• 2

  Linux kernel parameters for the Oracle database
• 3

  Initialization parameter settings for the Oracle database