Table of Contents

• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Introduction to Oracle Database Appliance
  • About Oracle Database Appliance
  • Oracle Database Appliance Software Terminology
  • About the Browser User Interface
• 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
• 4 Provisioning Oracle Database Appliance Bare Metal System
  • Plumbing the Network
  • Verifying Cabling and Network Connections
  • Downloading Oracle Database Appliance Software
  • Installing Oracle Database Appliance Software
  • Creating the Appliance
• 5 Oracle Database Appliance Postinstallation Tasks
  • Configuring CPU Core Count
  • Securing Oracle ILOM Service Processors
  • Changing Oracle Database Appliance Passwords
• 6 Patching Oracle Database Appliance
  • About Patching Oracle Database Appliance
  • About Patching Pre-Checks
  • Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line
  • Patching Oracle Database Appliance Bare Metal Systems Using the Browser User Interface
  • Updating Oracle Database Appliance Repository with Database Clone Files For Bare Metal Systems
  • Patching Existing Database Homes on Bare Metal Systems Using the Browser User Interface
  • Applying Additional Patches and Updates on Bare Metal Systems
    • Enabling Kernel Updates
    • Applying Out-of-Cycle Database Patches
  • Cleaning Up the Patch Repository
  • About Upgrading to a Different Database Home
• 7 Re-imaging Oracle Database Appliance
  • Uninstalling Oracle Database Appliance Components
  • Restoring an Oracle Database Appliance Baremetal System
  • Performing Secure Erase of Data on Storage Disks
• 8 Managing Oracle Databases
  • About Administrative Groups and Users on Oracle Database Appliance
  • About Data Migration Options for Oracle Database Appliance
  • About Standard Edition High Availability for Oracle Database Appliance
  • About Transparent Database Encryption (TDE) in Oracle Database Appliance
  • Working with Databases
    • Viewing Databases
    • Creating a Database Using the Browser User Interface
    • Creating a Database Using ODACLI Commands
    • Cloning a Database from Backup
    • Cloning an Oracle ACFS Database Using the Browser User Interface
    • Cloning an Oracle ACFS Database Using Command Line Interface
    • Modifying a Database
    • Moving a Database from One Oracle Home to Another
    • Upgrading a Database
    • Deleting a Database
  • Working with Database Homes
    • About Managing Multiple Oracle Homes on Oracle Database Appliance
    • 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
• 9 Managing Storage
  • About Storage Expansion Options for Oracle Database Appliance X6-2
  • Adding NVMe Storage Disks
• 10 Managing Networks
  • About Network Infrastructure and VLANs on Oracle Database Appliance
  • Viewing Configured Networks
  • Creating a Network
  • Updating a Network
  • Deleting a Network
• 11 Backup, Restore and Recover Databases
  • About Database Backup and Recovery Options
  • Creating a Mount Point for NFS Backup Location
  • Configuring Agent Proxy Settings for Object Store Access
  • Creating a Database Backup Policy
  • Updating a Database with a Backup Policy
  • Updating a Database Backup Policy
  • Backing Up a Database Using the Browser User Interface
  • Viewing Backup Reports
  • Recovering a Database Using the Browser User Interface
  • Deleting a Backup Using the Browser User Interface
  • Deleting a Backup Policy
  • Using the CLI to Backup, Restore, and Recover
    • Preparing for Database Backup to Disk
    • Preparing for Database Backup to NFS Location
    • Preparing for Database Backup to Oracle Cloud
    • Backing Up a Database with the CLI
    • Recovering a Database with the CLI
    • Restoring a Database with the CLI
    • Restoring Archivelog with the CLI
    • Deleting Backups with the CLI
• 12 Using Oracle Data Guard for Disaster Management and Recovery on Oracle Database Appliance
  • About Oracle Data Guard on Oracle Database Appliance
  • Configuring Oracle Data Guard on Oracle Database Appliance
  • Viewing Oracle Data Guard Status on Oracle Database Appliance
  • Performing Oracle Data Guard Operations
  • Creating an Oracle Data Guard Network
  • Migrating an Oracle Data Guard Database from One System to Another
  • Patching Oracle Data Guard Databases on Oracle Database Appliance
  • Upgrading Oracle Data Guard Databases on Oracle Database Appliance
  • Enabling Oracle Active Data Guard on Existing Configurations
  • Deconfiguring Oracle Data Guard on Oracle Database Appliance
• 13 Managing CPU Pools on Oracle Database Appliance Bare Metal and KVM Deployments
  • About CPU Pools
  • Creating a CPU Pool in a Bare Metal or KVM Deployment
  • Viewing CPU Pools in a Bare Metal or KVM Deployment
  • Modifying a CPU Pool in a Bare Metal or KVM Deployment
  • Deleting a CPU Pool in a Bare Metal or KVM Deployment
  • Viewing CPU Pool Audit Records in a Bare Metal or KVM Deployment
  • About Over-Subscribed CPU Pools
• 14 Managing an Oracle Database Appliance KVM Deployment
  • About Oracle Database Appliance KVM Deployment
  • About Oracle Database Appliance KVM Virtualization Architecture
  • About Virtual Machines and Oracle Database Appliance KVM Deployments
  • About KVM Database Systems on Oracle Database Appliance
  • Managing Database Systems in KVM Deployment
    • Creating a Database System in a KVM Deployment
    • Listing Database Systems in a KVM Deployment
    • Describing a Database System in a KVM Deployment
    • Starting a Database System in a KVM Deployment
    • Stopping a Database System in a KVM Deployment
    • Deleting a Database System in a KVM Deployment
  • Setting Up and Configuring a KVM Deployment for Applications
  • Managing VM Storage in KVM Deployment
    • Creating a VM Storage in a KVM Deployment
    • Viewing VM Storage in a KVM Deployment
    • Modifying a Virtual Storage in a KVM Deployment
    • Deleting a VM Storage in a KVM Deployment
  • Managing Virtual Networks in KVM Deployment
    • Creating a Virtual Network in a KVM Deployment
    • Viewing Virtual Networks in a KVM Deployment
    • Starting and Stopping Virtual Networks in a KVM Deployment
    • Modifying a Virtual Network in a KVM Deployment
    • Deleting a Virtual Network in a KVM Deployment
  • Managing Virtual Disks in KVM Deployment
    • Creating a Virtual Disk in a KVM Deployment
    • Viewing Virtual Disks in a KVM Deployment
    • Cloning a Virtual Disk in a KVM Deployment
    • Modifying a Virtual Disk in a KVM Deployment
    • Deleting a Virtual Disk in a KVM Deployment
  • Managing Virtual Machines in KVM Deployment
    • Creating a Virtual Machine in a KVM Deployment
    • Cloning a Virtual Machine in a KVM Deployment
    • Modifying a Virtual Machine in a KVM Deployment
    • Viewing Virtual Machines in a KVM Deployment
    • Starting and Stopping Virtual Machines in a KVM Deployment
    • Deleting a Virtual Machine in a KVM Deployment
  • Example JSON File to Create a Single-Node DB System
  • Example JSON File to Create a High-Availability DB System
• 15 Oracle Database Appliance Command-Line Interface
  • About Oracle Database Appliance Command-Line Interface
  • Managing ODACLI Privileges and Security with SUDO
  • odacli Network Commands
    • odacli configure-firstnet
    • odacli create-network
    • odacli delete-network
    • odacli delete-networkinterface
    • odacli describe-network
    • odacli describe-networkinterface
    • odacli list-networks
    • odacli list-networkinterfaces
    • odacli update-network
  • odacli Apply Patch and Update Commands
    • odacli cleanup-patchrepo
    • odacli create-prepatchreport
    • odacli delete-agentconfig-parameters
    • odacli delete-prepatchreport
    • odacli describe-component
    • odacli describe-latestpatch
    • odacli describe-prepatchreport
    • odacli list-agentconfig-parameters
    • odacli list-availablepatches
    • odacli list-prepatchreports
    • odacli update-agentconfig-parameters
    • odacli update-dbhome
    • odacli update-dcsadmin
    • odacli update-dcsagent
    • odacli update-dcscomponents
    • odacli update-registry
    • odacli update-repository
    • odacli update-server
    • odacli update-storage
    • odaadmcli orachk
  • odacli Appliance Commands
    • odacli set-credential
    • odacli create-appliance
    • odacli describe-system
    • odacli list-featuretracking
  • odacli Backup and Recovery Commands
    • odacli create-backup
    • odacli create-backupconfig
    • odacli create-objectstoreswift
    • odacli delete-backup
    • odacli delete-backupconfig
    • odacli describe-backupreport
    • odacli delete-objectstoreswift
    •  odacli describe-schedule
    • odacli irestore-database
    • odacli list-backupconfigs
    • odacli list-backupreports
    • odacli list-objectstoreswifts
    •  odacli list-schedules
    • odacli list-tdebackupreports
    • odacli recover-database
    • odacli restore-archivelog
    • odacli restore-tdewallet
    • odacli update-backupconfig
    • odacli update-objectstoreswift
    •  odacli update-schedule
  • Oracle Data Guard odacli Commands
    •  odacli configure-dataguard
    •  odacli deconfigure-dataguard
    •  odacli describe-dataguardstatus
    •  odacli failover-dataguard
    •  odacli list-dataguardstatus
    •  odacli reinstate-dataguard
    •  odacli switchover-dataguard
  • odacli CPU Core Commands
    • odacli list-cpucores
    • odacli describe-cpucore
    • update-cpucore
  • odacli CPU Pool Commands for Bare Metal and KVM
    • odacli create-cpupool
    • odacli list-cpupools
    • odacli describe-cpupool
    • odacli modify-cpupool
    • odacli delete-cpupool
    • odacli list-auditrecords
    • odacli describe-auditrecord
  • odacli Database Commands
    • odacli clone-database
    • odacli create-database
    • odacli delete-database
    • odacli describe-database
    • odacli list-databases
    • odacli modify-database
    • odacli move-database
    • odacli register-database
    • odacli upgrade-database
  • odacli DBHome Commands
    • odacli create-dbhome
    • odacli delete-dbhome
    • odacli describe-dbhome
    • odacli list-dbhomes
  • odacli Database Storage Commands
    • odacli create-dbstorage
    • odacli delete-dbstorage
    • odacli describe-dbstorage
    • odacli describe-dgstorage
    • odacli list-dbstorages
    • odacli list-dgstorages
    • odacli modify-dbstorage
    • odacli update-dgstorage
  • odacli Job Commands
    • odacli create-jobdata-retention-policy
    • odacli create-purge-jobdata-job
    • odacli delete-jobdata-retention-policy
    • odacli describe-job
    • odacli list-jobs
    • odacli list-jobdata-retention-policy
    • odacli list-purge-jobdata-job
    • odacli list-scheduled-executions
  • Log Commands
    • odaadmcli manage diagcollect
    • odacli create-auto-logclean-policy
    • odacli create-logcleanjob
    • odacli describe-logcleanjob
    • odacli list-auto-logclean-policy
    • odacli list-logcleanjobs
    • odacli list-logspaceusage
  • odacli Oracle Auto Service Request Commands
    • odacli configure-asr
    • odacli delete-asr
    • odacli describe-asr
    • odacli test-asr
    • odacli update-asr
  • odacli OS Commands
    • odacli list-osconfigurations
    • odacli update-osconfigurations
  • 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
  • Storage Commands
    • odaadmcli expand storage
    • odacli list-dgdisks
    • odacli validate-storagetopology
    • odaadmcli power disk
    • odaadmcli show controller
    • odaadmcli show disk
    • odaadmcli show diskgroup
    • odaadmcli show raidsyncstatus
    • odaadmcli show storage
    • odaadmcli stordiag
• 16 Oracle Database Appliance Command-Line Interface for KVM
  • About Command-Line Interface for Kernel-Based Virtual Machine (KVM)
  • About ODACLI Commands Supported on Oracle KVM Database System
  • odacli Database System Commands for KVM
    • odacli create-dbsystem
    • odacli list-dbsystems
    • odacli describe-dbsystem
    • odacli describe-dbsystem-image
    • odacli start-dbsystem
    • odacli stop-dbsystem
    • odacli delete-dbsystem
  • odacli VM Storage Commands for KVM
    • odacli create-vmstorage
    • odacli list-vmstorages
    • odacli describe-vmstorage
    • odacli modify-vmstorage
    • odacli delete-vmstorage
  • odacli Virtual Disk Commands for Oracle KVM
    • odacli create-vdisk
    • odacli list-vdisks
    • odacli describe-vdisk
    • odacli modify-vdisk
    • odacli clone-vdisk
    • odacli delete-vdisk
  • odacli CPU Pool Commands for Bare Metal and KVM
    • odacli create-cpupool
    • odacli list-cpupools
    • odacli describe-cpupool
    • odacli modify-cpupool
    • odacli delete-cpupool
    • odacli list-auditrecords
    • odacli describe-auditrecord
  • odacli VM Network Commands for KVM
    • odacli create-vnetwork
    • odacli list-vnetworks
    • odacli describe-vnetwork
    • odacli start-vnetwork
    • odacli stop-vnetwork
    • odacli modify-vnetwork
    • odacli delete-vnetwork
  • odacli Virtual Machine Commands for Oracle KVM
    • odacli create-vm
    • odacli list-vms
    • odacli describe-vm
    • odacli modify-vm
    • odacli start-vm
    • odacli stop-vm
    • odacli migrate-vm
    • odacli clone-vm
    • odacli delete-vm
• 17 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
• 18 Troubleshooting Oracle Database Appliance
  • Resolving Errors When Updating DCS Components During Patching
  • Viewing Component Information on the Appliance
  • Errors When Logging into the Browser User Interface
  • Errors when re-imaging Oracle Database Appliance
  • Using Oracle Autonomous Health Framework for Running Diagnostics
    • About Installing Oracle Autonomous Health Framework
    • Using the Oracle ORAchk Health Check Tool
    • Generating and Viewing Oracle ORAchk Health Check Tool Reports in the Browser User Interface
    • Generating and Viewing Database Security Assessment Reports in the Browser User Interface
    • Running Oracle Trace File Analyzer (TFA) Collector Commands
    • Sanitizing Sensitive Information in Diagnostic Collections
    • Sanitizing Sensitive Information in Oracle Trace File Analyzer Collections
    • Sanitizing Sensitive Information in Oracle ORAchk Output
  • Running the Disk Diagnostic Tool
  • Running the Oracle Database Appliance Hardware Monitoring Tool
  • Configuring a Trusted SSL Certificate for Oracle Database Appliance
    • Option 1: Creating a Key and Java Keystore and Importing a Trusted Certificate
    • Option 2: Packaging an Existing PEM-format Key and Certificates in a New Java Keystore
    • Option 3: Converting an Existing PKCS or PFX Keystore to a Java Keystore
    • Configuring the DCS Server to Use Custom Keystore
    • Configuring the DCS Agent for Custom Certificate
  • Disabling the Browser User Interface
  • 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
• B Oracle Database Appliance Storage Defaults
  • 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 Creating an Appliance Using JSON File
  • Loading and Saving Appliance Configurations
  • 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 Database Shapes for Oracle Database Appliance
  • About Database Shapes
  • OLTP Database Shapes
  • In-Memory Database Shapes
  • DSS Database Shapes
• Index