Contents

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 Components
• Overview of Oracle Database Appliance Deployment
• About the Oracle Appliance Manager 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
  • Checklist for System Details
  • Checklist for Custom Network Address Configuration

3 Readying Oracle Database Appliance for Deployment

• 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
• Downloading Oracle Database Appliance Software

4 Deploying Oracle Software on Oracle Database Appliance

• About Deploying Oracle Database Appliance Software
• Verifying the DCS Agent Version
• Special Instructions for Upgrading from a 12.1.2.7.0 Environment
• Updating the Infrastructure with the Latest Patch Bundle
• Copying the Oracle Database Appliance Software
• Deploying Oracle Database Appliance

5 Oracle Database Appliance Postinstallation Tasks

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

6 Updating Oracle Database Appliance Software

• About Updating Oracle Database Appliance Software
• Updating Oracle Database Appliance from the Web Console
  • Updating the Patch Repository
  • Updating the Agent, Storage, and Database Components
  • Updating a Database Home
• Updating Oracle Database Appliance from the CLI
  • Step 1: Update the Patch Repository
  • Step 2: Update the Agent
  • Step 3: Update the Server
  • Step 4: Update Oracle Database
• Updating Components Without Using a Patch Update
• Performing a Bare Metal Restore
  • About Performing a Bare Metal Restore
  • Downloading the ISO Image for Bare Metal Restore
  • Re-imaging Oracle Database Appliance

7 Configuring and Using Oracle Auto Service Request (ASR)

• Configuring Oracle ASR in the Web Console
  • About Configuring Oracle ASR
  • Configuring Internal Oracle ASR
  • Registering with External Oracle ASR Manager
• Testing Oracle ASR
• Managing an Oracle ASR Configuration
• Additional Resources for Oracle ASR

8 Managing Oracle Databases

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

9 Managing Storage

• About Managing NVMe Storage Disks

10 Managing Networks

• Viewing Configured Networks
• Creating a Network
• Updating a Network
• Deleting a Network

11 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

12 Managing Oracle Database Appliance KVM Virtualization

• About KVM Virtualization

13 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

14 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

Glossary

Index