Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
  • Backus-Naur Form Syntax
  • Changes in Oracle Big Data SQL 4.1
• 1 Introduction
  • 1.1 Supported System Combinations
  • 1.2 Oracle Big Data SQL Master Compatibility Matrix
  • 1.3 Installing on Oracle Big Data Appliance
  • 1.4 Prerequisites for Networking
    • 1.4.1 Port Access Requirements
  • 1.5 Prerequisites for Installation on the Hadoop Cluster
    • 1.5.1 Software Package Requirements for all DataNodes
    • 1.5.2 Python Requirements for the Cluster Management Node
      • 1.5.2.1 Adding Python 2.7.5 or Greater as a Secondary Installation
      • 1.5.2.2 When You May Need to Use scl to Invoke the Correct Python Version
    • 1.5.3 Environment Settings
    • 1.5.4 Proxy-Related Settings
    • 1.5.5 CPU, Memory, and Networking Requirements
  • 1.6 Prerequisites for Installation on Oracle Database Nodes
  • 1.7 Downloading Oracle Big Data SQL and Query Server
  • 1.8 Upgrading From a Prior Release of Oracle Big Data SQL
  • 1.9 Important Terms and Concepts
  • 1.10 Installation Overview
  • 1.11 Using the Installation Quick Reference
• 2 Installing or Upgrading the Hadoop Side of Oracle Big Data SQL
  • 2.1 About Support for Multiple Database Versions (19c, 18c, 12.2, and 12.1)
  • 2.2 Before You Start
    • 2.2.1 Check for Hadoop-Side Prerequisites With bds_node_check.sh
    • 2.2.2 Greater Memory Requirement if You Intend to Support Oracle Database 12.1.
    • 2.2.3 Plan the Configuration and Edit the Jaguar Configuration File
  • 2.3 About the Jaguar Utility
    • 2.3.1 Jaguar Configuration Parameter and Command Reference
  • 2.4 Steps for Installing on the Hadoop Cluster
• 3 Installing or Upgrading the Oracle Database Side of Oracle Big Data SQL
  • 3.1 Before You Start the Database-Side Installation
    • 3.1.1 Check for Required Grid Patches With bds-validate-grid-patches.sh
    • 3.1.2 Potential Requirement to Restart Grid Infrastructure
      • 3.1.2.1 Understanding When Grid or Database Restart is Required
    • 3.1.3 Special Considerations When a System Under Grid Infrastructure has Multiple Network Interfaces of the Same Type
  • 3.2 About the Database-Side Installation Directory
  • 3.3 Steps for Installing on Oracle Database Nodes
    • 3.3.1 Command Line Parameter Reference for bds-database-install.sh
    • 3.3.2 About Using an Alternate Kerberos Principal on the Database Side
  • 3.4 Granting User Access to Oracle Big Data SQL
  • 3.5 Enabling Object Store Access
  • 3.6 Installing and Configuring Oracle SQL Access to Kafka
• 4 Post-Installation Tasks
  • 4.1 Validating the Installation With bdschecksw and Other Tests
  • 4.2 Checking the Installation Log Files
  • 4.3 Installing and Configuring Oracle SQL Access to Kafka (OSAK)
  • 4.4 Perform Network ACL Setup for Object Store Access
  • 4.5 Run bds_cluster_node_helper.sh to Get Information About the Oracle Big Data SQL Installation on a Node
  • 4.6 Maintaining WebLogic Server
  • 4.7 Other Post-Installation Steps to Consider
• 5 Expanding or Shrinking an Installation
  • 5.1 Adding or Removing Oracle Big Data SQL on Hadoop Cluster Nodes
  • 5.2 Adding or Removing Oracle Big Data SQL on Oracle Database Nodes
• 6 Reconfiguring an Installation
  • 6.1 Reconfiguring an Existing Oracle Big Data SQL Installation
• 7 Uninstalling Oracle Big Data SQL
  • 7.1 General Guidelines for Removing the Software
  • 7.2 Uninstalling From an Oracle Database Server
  • 7.3 Uninstalling From a Hadoop Cluster
• 8 Securing the Oracle Big Data SQL Installation
  • 8.1 Security Overview
  • 8.2 Big Data SQL Communications and Secure Hadoop Clusters
    • 8.2.1 Connecting a Database to Both Secure and Unsecured Clusters
  • 8.3 Configuring Oracle Big Data SQL in a Kerberos-Secured Environment
    • 8.3.1 Enabling Oracle Big Data SQL Access to a Kerberized Cluster
    • 8.3.2 Installing a Kerberos Client on the Oracle Database Nodes
  • 8.4 Using Oracle Secure External Password Store to Manage Database access for Oracle Big Data SQL
  • 8.5 About Data Security on Oracle Big Data Appliance
  • 8.6 Authentication Between Oracle Database and Oracle Big Data SQL Offload Cell Server Processes
  • 8.7 Securing Object Store Access
• 9 Additional Tools Installed
  • 9.1 Copy to Hadoop and OHSH
    • 9.1.1 Completing the OHSH Configuration on Oracle Database Nodes
    • 9.1.2 Completing the OHSH Configuration on the Hadoop Cluster
    • 9.1.3 Getting Started Using Copy to Hadoop and OHSH
    • 9.1.4 Configuring OHSH to Enable Job Monitoring
  • 9.2 Oracle SQL Access to Kafka
• A Installation Quick Reference
• B bds-config.json Configuration Example
• C Oracle Big Data SQL Installation Example
• D Downloading the Correct Versions of the Hadoop, Hive, and HBase Clients for a Local Repostory
• E Oracle Big Data SQL Licensing
  • E.1 ANTLR 4.7.2
  • E.2 Kafka 2.3.0
  • E.3 Apache Licensed Code
  • E.4 Apache License
• Index