Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 About Oracle Database Appliance

• Oracle Database Appliance Software
• Overview of Oracle Database Appliance Deployment
• About the Web Console
• Viewing Job Activity

2 Preparing for Oracle Database Appliance Installation and Deployment

• Registering Your Support Identifier on My Oracle Support
• Planning Oracle Database Appliance Configuration Options
  • Selecting an Oracle Database Appliance Configuration
  • Selecting Operating System Groups and Users
  • Selecting Database Deployment Options
  • Selecting Database Shapes for Oracle Database Appliance
• Gathering System Requirement Information
  • List of Information You Need Before Deployment
    • Security Requirements
    • Storage Administration Requirements
    • Network Administration Requirements for Single Node Systems
    • Network Administration Requirements for Multi-Node Systems
  • Checklist for System Details
  • Checklist for Custom Network Address Configuration
• Creating a Configuration File for a Virtualization Platform
  • About the Standalone Oracle Database Appliance Configurator
  • Running the Standalone Oracle Database Appliance Configurator

3 Readying Oracle Database Appliance for Deployment

• About Interconnect Cabling
• Attaching Network Cables to Oracle Database Appliance X7-2-HA
• Attaching Network Cables to Oracle Database Appliance X7-2S or X7-2M
• First Startup of Oracle Database Appliance
  • Attaching Power Cords and Initializing Components
  • Powering On Oracle Database Appliance the First Time
• Configuring Oracle Integrated Lights Out Manager
• Plumbing the Network

4 Deploying Oracle Software on Oracle Database Appliance

• About Deploying Oracle Database Appliance 18.1
• Re-imaging Oracle Database Appliance with an Oracle Database 18.1 Image
• Updating the Repository with the GI and RDBMS Files
• Deploying a Single Node Bare Metal Platform
• Deploying a Multi-Node Bare Metal Platform

5 Oracle Database Appliance Postinstallation Tasks

• Changing the Oracle Installation Owner Passwords
• Changing the oda-admin User Password

6 Managing Oracle Databases

• Administrative Groups and Users on Oracle Database Appliance
• Data Migration and Management and Oracle Database Appliance
• Working with Databases
  • Viewing Databases
  • Creating a Database
  • Creating an Instance Only Database
  • Upgrading a Database
  • Deleting a Database
• Working with Database Homes
  • About Managing Multiple Oracle Homes on Oracle Database Appliance
  • Downloading an RDBMS Clone File
  • Viewing Database Homes
  • Creating a Database Home
  • Deleting a Database Home
• Migrating Databases
  • About Migrating Databases
  • Configuring a Static Listener
  • Migrating a Database
  • Registering a Database
• About Managing Multiple Database Instances Using Instance Caging
• Oracle EM Express and DB Console

7 Managing Storage

• About Managing Storage
• Storage on Single Node Platforms
  • Memory and Storage Options for Single Node Systems
• Storage on Multi Node Platforms
  • About Expanding Storage on Multi-Node Systems
  • Preparing for a Storage Upgrade for a Virtualized Platform

8 Managing Networks

• About Managing Networks
• Viewing Configured Networks and Network Interfaces
• Creating a Network
• Updating a Network
• Deleting a Network

9 Backup, Restore and Recover Databases

• About Database Backup, Restore and Recover
• Preparing for Database Backup to Disk
• Preparing for Database Backup to Oracle Cloud
• Backing Up a Database
• Deleting Backups
• Recovering a Database
• Restoring a Database

10 Oracle Database Appliance Command-Line Interface

• About Oracle Database Appliance Command-Line Interface
• Managing ODACLI Privileges and Security with SUDO
• Configure Command
  • configure-firstnet
• odacli Apply Patch and Update Commands
  • odacli describe-component
  • odacli describe-latestpatch
  • odacli update-dcsagent
  • odacli update-repository
  • odacli update-server
  • odacli update-storage
• odacli Appliance Commands
  • odacli create-appliance
  • odacli describe-appliance
• odacli Backup and Recovery Commands
  • odacli create-backup
  • odacli create-backupconfig
  • odacli create-objectstoreswift
  • odacli delete-backup
  • odacli delete-backupconfig
  • odacli delete-objectstoreswift
  • odacli describe-backupreport
  •  odacli describe-schedule
  • odacli irestore-database
  • odacli list-backupreports
  • odacli list-backupconfigs
  • odacli list-objectstoreswifts
  •  odacli list-schedules
  •  odacli list-schedule
  • odacli recover-database
  • odacli update-backupconfig
  • odacli update-database
  • odacli update-objectstoreswift
  •  odacli update-schedule
• odacli CPU Core Commands
  • odacli list-cpucores
  • odacli describe-cpucore
  • update-cpucore
• odacli Database Commands
  • odacli list-databases
  • odacli describe-database
  • odacli create-database
  • odacli register-database
  • odacli delete-database
• odacli DBHome Commands
  • odacli list-dbhomes
  • odacli describe-dbhome
  • odacli create-dbhome
  • odacli delete-dbhome
• odacli Database Storage Commands
  • odacli list-dbstorages
  • odacli describe-dbstorage
  • odacli create-dbstorage
  • odacli delete-dbstorage
• odacli Job Commands
  • odacli list-jobs
  • odacli describe-job
• odacli Network Commands
  • odacli list-networks
  • odacli describe-network
  • odacli create-network
  • odacli update-network
  • odacli delete-network
• odacli Oracle Auto Service Request Commands
  • odacli configure-asr
  • odacli update-asr
  • odacli describe-asr
  • odacli test-asr
  • odacli delete-asr
• odacli validate-storagetopology
• odaadmcli Hardware Monitoring Commands
  • odaadmcli show cooling
  • odaadmcli show env_hw
  • odaadmcli show fs
  • odaadmcli show memory
  • odaadmcli show network
  • odaadmcli show power
  • odaadmcli show processor
  • odaadmcli show server
• odaadmcli Storage Commands
  • odaadmcli expand storage
  • odaadmcli show disk
  • odaadmcli show diskgroup
  • odaadmcli show controller
  • odaadmcli show raidsyncstatus
  • odaadmcli show storage
  • odaadmcli stordiag
  • odaadmcli manage diagcollect
  • odaadmcli power disk
• odaadmcli VLAN Management Commands
  • odaadmcli create vlan
  • odaadmcli delete vlan
  • odaadmcli show vlan
• odacli-adm set-credential

11 Validating and Troubleshooting Oracle Database Appliance

• Logging into the Web Console
• Troubleshooting Tools and Commands
  • ORAchk Health Check Tool
  • Disk Diagnostic Tool
  • Trace File Analyzer Collector
  • Oracle Database Appliance Hardware Monitoring Tool
• Preparing Log Files for Oracle Support Services

A Oracle Database Appliance Software Configuration Defaults

• Directory Paths for Oracle Database Appliance
• Location of Log Files
• Oracle Groups and User Configurations for Oracle Database Appliance
• System Configuration for Oracle Database Appliance
• Changing the Password

B Storage on Oracle Database Appliance

• About Oracle Database File Storage
  • About Database File Storage
  • Oracle ACFS Mount Points and Storage Space
  • Displaying Mounted Disk Details
• Usable Space on Oracle Database Appliance X7-2S and X7-2M
• Usable Space on Oracle Database Appliance X7-2-HA

C Create Appliance Using JSON File

• Readme for the Command odacli create-appliance
• Example JSON Files to Create a Single Node Appliance with the CLI
• Example JSON File to Create a Multi-Node Appliance with the CLI

D Oracle Database Appliance Cleanup Script

• Cleanup Script for a Virtualized Platform Deployment

E Database Shapes for Oracle Database Appliance

• About Database Shapes and Classes
• Database Shapes for the OLTP Class
• Database Shapes for the In-Memory Class
• Database Shapes for the DSS Class

Index