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 Database Deployment Options for Oracle Database Appliance
    • Selecting Database Shapes for Oracle Database Appliance
    • Calculating Required Cores
    • Selecting Operating System Groups and Users
  • 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 Supplied Cables for Oracle Database Appliance
    • Attaching Cables for Oracle Database Appliance X5-2
    • Attaching Cables for Oracle Database Appliance Models X4-2
    • Cabling Oracle Database Appliance to Connect to Fiber Public Networks (Optional)
  • Attaching a Storage Expansion Shelf to Oracle Database Appliance
    • About Attaching and Cabling Storage Shelves
    • Installing and Cabling a Storage Expansion Shelf
  • Attaching Peripheral Devices
  • Attaching Power Cords and Initializing Components
  • Powering On Oracle Database Appliance the First Time
  • Defining Your Public Network Interface Type
  • 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 Implementing Multi-User Access on Oracle Database Appliance
  • About Multi-User Access on Oracle Database Appliance
  • About Users, Roles, Entitlements, and Operations on a Multi-User Access Enabled Oracle Database Appliance System
  • About Granting and Revoking Resource Access
  • Provisioning Oracle Database Appliance with Multi-User Access
  • Creating, Viewing, and Deleting Users on Oracle Database Appliance with Multi-User Access
  • Activating a New User on Oracle Database Appliance with Multi-User Access
  • Granting and Revoking Resource Access on Oracle Database Appliance with Multi-User Access
  • Viewing Roles, Operations, and Entitlements on Oracle Database Appliance with Multi-User Access
  • Managing Databases and Database Homes on Oracle Database Appliance with Multi-User Access
  • Changing the Password for a User Account on Oracle Database Appliance with Multi-User Access
  • Resetting the Password for a Locked User Account on Oracle Database Appliance with Multi-User Access
• 6 Oracle Database Appliance Postinstallation Tasks
  • Configuring CPU Core Count
  • Securing Oracle ILOM Service Processors
  • Changing Oracle Database Appliance Passwords
• 7 Patching Oracle Database Appliance
  • About Patching Oracle Database Appliance
  • About Patching Prechecks
  • About Enabling NUMA on Oracle Database Appliance
  • Minimizing Downtime When Patching Oracle Database Appliance
  • Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line
  • Patching Oracle Database Appliance DB Systems Using the Command-Line
  • Patching Oracle Database Appliance Bare Metal Systems Using the Browser User Interface
  • Patching Oracle Database Appliance DB 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
  • Patching Non-Provisioned Oracle Database Appliance Systems
  • 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
  • Setting Dynamic Default Parameters
• 8 Re-imaging Oracle Database Appliance
  • Uninstalling Oracle Database Appliance Components
  • Reimaging an Oracle Database Appliance Baremetal System
  • Performing Secure Erase of Data on Storage Disks
  • Redeployment of Oracle Database Appliance
• 9 Upgrading Oracle Database Appliance Using Data Preserving Reprovisioning
  • About Upgrading Using Data Preserving Reprovisioning
  • Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning
  • Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning
  • Step 3: Provisioning Nodes Using Data Preserving Reprovisioning Method
• 10 Managing Oracle Databases
  • About Administrative Groups and Users on Oracle Database Appliance
  • About Data Migration Options for Oracle Database Appliance
  • About Creating Database Homes on Oracle ACFS Storage
  • About Standard Edition High Availability for Oracle Database Appliance
  • About Enterprise 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
    • Managing Database Homes on Oracle ACFS Storage
    • Creating a Database Using ODACLI Commands
    • Cloning a Database from Backup
    • Cloning an Oracle ACFS Database
    • 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 Registering a TDE-Enabled Database
  • About Managing Multiple Database Instances Using Instance Caging
  • Oracle EM Express and DB Console
• 11 Managing Storage
  • About Managing Storage
  • Preparing for Storage Expansion
• 12 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 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
• 13 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 Database from One System to Another Using Integrated Oracle Data Guard
  • 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
  • Registering Oracle Data Guard on Oracle Database Appliance
  • Deconfiguring Oracle Data Guard on Oracle Database Appliance
• 14 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
  • Remapping CPU Pools 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
• 15 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
    • Modifying a DB System in a KVM Deployment
    • Attaching and Detaching a Network for 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
    • Managing Shared CPU Pool with Database System in a KVM Deployment
    • Managing Backup, Restore, and Recovery on a Database System in a KVM Deployment
    • Managing Oracle Data Guard on 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 VM 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
  • About Overcommitting Memory or CPUs in an Oracle Database Appliance KVM System
  • Example JSON File to Create a Single-Node DB System
  • Example JSON File to Create a High-Availability DB System
• 16 Migrating from Virtualized Platform to KVM on Oracle Database Appliance
  • About Migrating Oracle Database Appliance from Virtualized Platform to KVM
  • Migrating from Virtualized Platform to KVM on Oracle Database Appliance
• 17 Oracle Database Appliance Command-Line Interface
  • About Oracle Database Appliance Command-Line Interface
  • Managing ODACLI Privileges and Security with SUDO
  • ODACLI Command Changes with Multi-User Access on Oracle Database Appliance
  • 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 Multi-User Access Commands
    • odacli list-domains
    • odacli describe-domain
    • odacli list-tenants
    • odacli describe-tenant
    • odacli create-user
    • odacli activate-user
    • odacli list-users
    • odacli describe-user
    • odacli authorize-user
    • odacli delete-user
    • odacli list-user-roles
    • odacli describe-user-role
    • odacli list-user-entitlements
    • odacli describe-user-entitlement
    • odacli list-user-operations
    • odacli describe-user-operation
    • odacli list-resources-access
    • odacli describe-resource-access
    • odacli grant-resource-access
    • odacli revoke-resource-access
    • odacli reset-password
    • odacli change-password
  • odacli Apply Patch and Update Commands
    • odacli cleanup-patchrepo
    • odacli create-prepatchreport
    • odacli describe-prepatchreport
    • odacli list-prepatchreports
    • odacli delete-prepatchreport
    • odacli list-availablepatches
    • odacli describe-component
    • odacli describe-latestpatch
    • odacli list-agentconfig-parameters
    • odacli update-agentconfig-parameters
    • odacli delete-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
    • odacli update-server-postcheck
    • odaadmcli orachk
  • Data Preserving Reprovisioning Commands
    • odacli restore-node
    • odaupgradeutil
    • odaupgradeutil run-prechecks
    • odaupgradeutil describe-precheck-report
    • odaupgradeutil detach-node
    • odaupgradeutil reinitialize
  • odacli Appliance Commands
    • odacli set-credential
    • odacli create-appliance
    • odacli describe-system
    • odacli ping-agent
    • odacli list-nodes
    • odacli list-featuretracking
  • odacli Backup and Recovery Commands
    • odacli create-backup
    • odacli create-backupconfig
    • odacli create-objectstoreswift
    • odacli describe-backupconfig
    • odacli delete-backup
    • odacli delete-backupconfig
    • odacli describe-backupreport
    • odacli describe-objectstoreswift
    • 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
  • odacli Oracle Data Guard Commands
    •  odacli configure-dataguard
    •  odacli deconfigure-dataguard
    •  odacli describe-dataguardstatus
    •  odacli failover-dataguard
    •  odacli list-dataguardstatus
    •  odacli reinstate-dataguard
    •  odacli register-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 remap-cpupools
    • 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 configure-dbhome-storage
    • odacli list-dbhome-storages
    • odacli describe-dbhome-storage
    • odacli modify-dbhome-storage
    • 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-pendingjobs
    • odacli list-jobdata-retention-policy
    • odacli list-purge-jobdata-jobs
    • odacli list-scheduled-executions
  • Adaptive Classification and Redaction (ACR) Commands
    • odacli describe-acr
    • odacli enable-acr
    • odacli redact-acr
    • odacli list-acr
    • odacli disable-acr
  • Log Commands
    • odaadmcli manage diagcollect
    • odacli create-auto-logclean-policy
    • odacli delete-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 localdisk
    • 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 asmops diskgroup
    • 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
• 18 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 modify-dbsystem
    • odacli modify-dbfileattributes
    • odacli list-dbsystems
    • odacli describe-dbsystem
    • odacli describe-dbsystem-image
    • odacli start-dbsystem
    • odacli stop-dbsystem
    • odacli delete-dbsystem
  • odacli Commands for Migration from Virtualized Platform to KVM
    • odacli migrate-ovm2kvm
    • odacli describe-ovm2kvm
  • 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 remap-cpupools
    • 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
• 19 Troubleshooting Oracle Database Appliance
  • Viewing Details About DCS Error Messages
  • Collecting Diagnostics Data Using the BUI
  • 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
    • Enabling Adaptive Classification and Redaction (ACR)
    • 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
• 20 Troubleshooting Data Preserving Reprovisioning on Oracle Database Appliance
  • Errors When Running odaupgradeutil on Oracle Database Appliance
  • Errors Detected by the Prechecks Option of the Upgrade Utility
  • Errors When Running odaupgradeutil detach-node Command on Oracle Database Appliance
  • Errors When Running odacli restore-node Command on Oracle Database Appliance
• 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
  • Database Disk Group Sizes for Oracle Database Appliance
  • Usable Storage on Oracle Database Appliance X5-2
  • About Oracle Database Appliance Storage
  • Oracle ACFS Mount Points and Storage Space
  • Oracle ACFS Space Management
• 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 Templates for Oracle Database Appliance
  • Types of Database Templates for Oracle Database Appliance
• Index