Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- 1 Oracle Database Appliance Checklists
- 2 Introduction to Oracle Database Appliance
- 3 Readying Oracle Database Appliance for Deployment
- 4 Provisioning Oracle Database Appliance Bare Metal System
-
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
-
Using Passwordless Multi-User
Access on Oracle Database Appliance
- About Passwordless Multi-User Access on Oracle Database Appliance
- Provisioning Oracle Database Appliance with Passwordless Multi-User Access
- Creating, Viewing, and Deleting Users on Oracle Database Appliance with Passwordless Multi-User Access
- Changing the Password for a User Account on Oracle Database Appliance with Passwordless Multi-User Access
- Example JSON Files to Create a Single-Node Passwordless Multi-User Enabled Appliance
- Example JSON File to Create a High-Availability Passwordless Multi-User Enabled Appliance
- Example JSON Files to Create a Single-Node Passwordless Multi-User Enabled DB System
- Example JSON File to Create a High-Availability Passwordless Multi-User Enabled DB System
- 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
- 7 Re-imaging Oracle Database Appliance
-
8
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
- About Updating Databases and Database Homes
- Updating ESTES-EXT Firmware Before Patching Oracle Database Appliance Server
- 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 Databases Using ODACLI Commands or the BUI
- Patching Existing Database Homes Using ODACLI or the BUI
- Patching Non-Provisioned Oracle Database Appliance Systems
- Applying Additional Patches and Updates on Bare Metal Systems
- Cleaning Up the Patch Repository
- About Upgrading to a Different Database Home
- Setting Dynamic Default Parameters
-
9
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
-
Storing Transparent Database
Encryption Keys on Oracle Key Vault Server
- About Oracle Key Vault
- Creating TDE-Enabled Databases With User Credentials
- Creating TDE-Enabled Databases Using Oracle Key Vault With Endpoints in Oracle Key Vault
- Managing Oracle Key Vault Server Configuration Operations Using ODACLI Commands
-
Managing Database Operations on
TDE-enabled Databases with TDE keys stored on Oracle Key Vault
- Changing the Password for TDE-enabled Databases
- Re-keying TDE Master Encryption Key for TDE-Enabled Databases
- Performing Backup and Recovery of TDE-enabled Databases
- Restoring TDE-Enabled Databases Using Oracle Key Vault User Credentials
- Restoring TDE-Enabled Databases With Endpoints and Wallet Manually Created in Oracle Key Vault
- Deleting TDE-enabled Databases
- Creating an Oracle Key Vault User Using BUI
- Creating Oracle Key Vault Server Configuration Object Using the BUI
- Granting and Revoking Access on Oracle Key Vault Server Configuration Using BUI
- Managing Oracle Key Vault Server Configuration Operations Using BUI
-
Manual Migration and Encryption of
Data into TDE-Enabled Database
- Migrating Tablespaces from Non-TDE Oracle ACFS Database to Oracle ACFS Database on Oracle Database Appliance
- Migrating Tablespaces from Non-TDE Oracle ASM Database to Oracle ASM Database on Oracle Database Appliance
- Migrating Tablespaces from Non-TDE Oracle ASM Database to Oracle ASM CDB Database on Oracle Database Appliance
- Migrating Tablespaces from Non-TDE Oracle ACFS Database to Oracle ACFS CDB Database on 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
- Upgrading a Database Manually Using AutoUpgrade
- Deleting a Database
- Working with Database Homes
- Migrating Databases
- About Registering a TDE-Enabled Database
- About Managing Multiple Database Instances Using Instance Caging
- Oracle EM Express and DB Console
- 10 Managing Storage
- 11 Managing Networks
-
12
Backup, Restore and Recover Databases
- About Database Backup and Recovery Options
- Configuring NFS Backup and Restore on Oracle Database Appliance
- 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
-
13
Using Oracle Data Guard for
Disaster Management and Recovery on Oracle Database Appliance
- About Oracle Data Guard on Oracle Database Appliance
- Deploying Multiple Standby Databases with Oracle Data Guard on Oracle Database Appliance
- Configuring Oracle Data Guard on Oracle Database Appliance
- Configuring Oracle Data Guard on Oracle Database Appliance Using BUI
- Viewing Oracle Data Guard Status on Oracle Database Appliance
- Viewing Oracle Data Guard Status on Oracle Database Appliance Using BUI
- Performing Oracle Data Guard Operations
- Performing Oracle Data Guard Operations Using BUI
- 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
- Enabling Oracle Active Data Guard on Existing Configurations
- Registering Oracle Data Guard on Oracle Database Appliance Using ODACLI Commands
- Registering Oracle Data Guard on Oracle Database Appliance Using BUI
- Deconfiguring Oracle Data Guard on Oracle Database Appliance
- Deconfiguring Oracle Data Guard on Oracle Database Appliance Using BUI
-
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 DB Systems on Oracle Database Appliance
- Deploying Multiple Databases on DB Systems on Oracle Database Appliance
-
Managing DB Systems in KVM
Deployment
- Creating a DB System in a KVM Deployment
- Listing DB Systems in a KVM Deployment
- Describing a DB System in a KVM Deployment
- Modifying a DB System in a KVM Deployment
- Attaching and Detaching a Network for a DB System in a KVM Deployment
- Starting a DB System in a KVM Deployment
- Stopping a DB System in a KVM Deployment
- Deleting a DB System in a KVM Deployment
- Managing Backup, Restore, and Recovery on a DB System in a KVM Deployment
- Managing Shared CPU Pool with DB System in a KVM Deployment
- Managing Oracle Data Guard on a DB System in a KVM Deployment
- Setting Up and Configuring a KVM Deployment for Applications
- Managing VM Storage in KVM Deployment
- Managing Virtual Networks in KVM Deployment
- Managing Virtual Disks in KVM Deployment
- Managing Virtual Machines in 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
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 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 modify-agentconfig-parameters
- odacli delete-agentconfig-parameters
- odacli update-database
- 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
- odacli Appliance Commands
-
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 modify-backupconfig
- odacli modify-objectstoreswift
- odacli modify-schedule
- odacli Oracle Data Guard Commands
- odacli CPU Core Commands
- odacli CPU Pool Commands for Bare Metal and KVM
- odacli Database Commands
- odacli DBHome Commands
- odacli Database Storage Commands
- odacli Diagnostics Collection Commands
- odacli Job Commands
- odacli Oracle Key Vault Server Configuration Commands
- Log Commands
- odacli Oracle Auto Service Request Commands
- Adaptive Classification and Redaction (ACR) Commands
- odacli OS Commands
- odaadmcli Hardware Monitoring Commands
- Storage Commands
-
17
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 DB System Commands for KVM
- odacli VM Storage Commands for KVM
- odacli Virtual Disk Commands for Oracle KVM
- odacli CPU Pool Commands for Bare Metal and KVM
- odacli VM Network Commands for KVM
- odacli Virtual Machine Commands for Oracle KVM
- 18 Configuring and Using Oracle Auto Service Request (Oracle ASR)
-
19
Troubleshooting Oracle Database Appliance
- About Oracle Database Appliance Configuration Collection Utility
- About Setting Up and Removing SSH Configuration
- Viewing Oracle Database Appliance Error Correlation Reports
- About Enabling Linux Kernel Core Extractor for Troubleshooting
- 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
- Redacting and Sanitizing Entities in the BUI
- Sanitizing Sensitive Information in Oracle ORAchk Output
- Running the Disk Diagnostic Tool
- Running the Oracle Database Appliance Hardware Monitoring Tool
- Disabling the Browser User Interface
- Preparing Log Files for Oracle Support Services
- A Oracle Database Appliance Software Configuration Defaults
- B Oracle Database Appliance Storage Defaults
- C Creating an Appliance Using JSON File
- D Database Shapes for Oracle Database Appliance
- Index