Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to Oracle Database Appliance
-
2
Preparing for Oracle Database Appliance Installation and Deployment
- Registering Your Support Identifier on My Oracle Support
- Planning Oracle Database Appliance Configuration Options
- Gathering System Requirement Information
- 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
- 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 Provisioning an Oracle Database Appliance Virtualized Platform
- 7 Oracle Database Appliance Postinstallation Tasks
-
8
Patching Oracle Database Appliance
- About Patching Oracle Database Appliance
- About Patching Pre-Checks
- 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
- Patching Oracle Database Appliance Virtualized Platform
- 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
- Cleaning Up the Patch Repository
- About Upgrading to a Different Database Home
- 9 Re-imaging Oracle Database Appliance
-
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 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 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
- Migrating Databases
- About Registering a TDE-Enabled Database
- About Managing Multiple Database Instances Using Instance Caging
- Oracle EM Express and DB Console
- 11 Managing Storage
-
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
-
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
- 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 Database 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
- 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
Managing an Oracle Database Appliance Virtualized Platform
- About Oracle Database Appliance Virtualized Platform
- Oracle Database Appliance Virtualized Platform Architecture
- About Network Infrastructure and VLANs on Oracle Database Appliance Virtualized Platform
- Configuring Additional Networks on Virtualized Platform
- Adding a Network Interface on Virtualized Platform
- Deleting a Network on Virtualized Platform
- Deleting a Network Interface on Virtualized Platform
- How to Create and Manage Shared Repositories
- How to Manage Virtual Disks in Shared Repositories
- How to Manage Virtual Machine Templates
- How to Create Clones and Snap Clones of a Template
-
How to Manage Virtual Machines on Oracle Database Appliance Virtualized Platform
- About Managing Virtual Machines on Oracle Database Appliance Virtualized Platform
- Listing the Virtual Machines in Your Repositories
- Creating a Virtual Machine
- Configuring a Virtual Machine
- Starting and Stopping a Virtual Machine
- Externally Configuring a Virtual Machine
- Opening a Virtual Machine Console for a Virtual Machine
- Creating an Image for a New Virtual Machine
- Setting Up a Virtual Machine for Access from eth0 Using an IP Address
- Adding or Removing a Virtual Disk to or from a Virtual Machine
- Removing a Virtual Machine from a Shared Repository
- Performing a Live Migration for an Oracle Database Appliance Virtual Machine
- How to Create Driver Domain Virtual Machines
- How to Manage High Availability on Oracle Database Appliance Virtualized Platform
-
How to Manage CPU Pools on Oracle Database Appliance Virtualized Platform
- About Managing CPU Pools for Resource Allocation
- About Over-Subscribed CPU Pools
- Creating a New CPU Pool on Oracle Database Appliance Virtualized Platform Nodes
- Showing the CPU Pools Configured on Oracle Database Appliance Virtualized Platform Nodes
- Changing the Number of CPUs Assigned to a CPU Pool on Oracle Database Appliance Virtualized Platform Nodes
- Assigning a Virtual Machine to a CPU Pool on Oracle Database Appliance Virtualized Platform
-
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 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
- odaadmcli orachk
- odacli Appliance Commands
-
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
- 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 Job Commands
- Log Commands
- odacli Oracle Auto Service Request Commands
- odacli OS Commands
- odaadmcli Hardware Monitoring Commands
- Storage Commands
-
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 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
-
19
Oracle Appliance Manager Command-Line Interface for Virtualization
- About the Oracle Appliance Manager Command-line Interface (OAKCLI)
- Managing OAKCLI Privileges and Security with SUDO
- oakcli add disk -local
- oakcli configure commands
- oakcli copy
- oakcli create commands
- oakcli delete commands
- oakcli deploy
- oakcli expand storage
- oakcli diskwritecache
- oakcli locate disk
- oakcli manage diagcollect
- oakcli describe-system
- oakcli modify database
- oakcli orachk
- oakcli reconfigure osparams
- oakcli resize dbstorage
- oakcli restart oda_base
-
oakcli show commands
- oakcli show asr
- oakcli show cooling
- oakcli show controller
- oakcli show cpupool
- oakcli show databases
- oakcli show db_config_params
- oakcli show dbhomes
- oakcli show dbstorage
- oakcli show disk
- oakcli show diskgroup
- oakcli show enclosure
- oakcli show env_hw
- oakcli show expander
- oakcli show ismaster
- oakcli show fs
- oakcli show memory
- oakcli show network
- oakcli show power
- oakcli show processor
- oakcli show raidsyncstatus
- oakcli show repo
- oakcli show server
- oakcli show storage
- oakcli show validation storage
- oakcli show validation storage errors
- oakcli show validation storage failures
- oakcli show version
- oakcli start commands
- oakcli stop command
- oakcli stordiag
- oakcli test asr
- oakcli unpack
- oakcli update
- oakcli update-cpucore
- oakcli upgrade
- oakcli validate
- oakcli Virtual Disk Commands
- oakcli Virtual Machine Commands
- oakcli Virtual Machine Template Commands
- oakcli VLAN Management Commands for Virtual Platform
-
20
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
- A ODACLI Command Reference for OAKCLI Migration
- B Oracle Database Appliance Software Configuration Defaults
- C Oracle Database Appliance Storage Defaults
- D Creating an Appliance Using JSON File
- E Database Templates for Oracle Database Appliance
- Index