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 and Oracle Database 18.1

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

2 Preparing to Deploy Oracle Database Appliance

• 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
  • Checklist for System Details
  • Checklist for Custom Network Address Configuration

3 Readying to Deploy Oracle Database Appliance

• About Interconnect Cabling
• Attaching Network Cables to Oracle Database Appliance
• Attaching Peripheral Devices
• 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
• Configuring an Initial Network Connection

4 Deploying a Bare Metal Platform on an X6-2S, X6-2M, or X6-2L Server

• 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

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 NVMe Storage Disks

8 Managing Networks

• Viewing Configured Networks
• 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 Appliance Manager Command-Line Interface

• About Oracle Appliance Manager 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
  • update-image
  • odacli update-repository
  • odacli update-server
• 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 update-tdekey
  • 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 OS Commands
  • odacli list-osconfigurations
  • odacli update-osconfigurations
• 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 iraid
  • odaadmcli show raidsyncstatus
  • odaadmcli show storage
  • odaadmcli stordiag
  • odaadmcli manage diagcollect
  • odaadmcli power disk
• 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 Appliance Storage
  • About Database File Storage
  • Oracle ACFS Mount Points and Storage Space
  • Displaying Mounted Disk Details
• Determining Usable Disk Capacity on Oracle Database Appliance for X6-2S, X6-2M, and X6-2L

C Create Appliance Using JSON File

• Readme for the odacli create-appliance Command
• Example JSON Files for the odacli create-appliance Command

D Oracle Database Appliance Cleanup Script

E Database Shapes for Oracle Database Appliance

• About Database Shapes
• OLTP Database Shapes
• In-Memory Database Shapes
• DSS Database Shapes

Index