List of Examples

• 4-1        Example of a Bonded Configuration
• 4-2        Example of a Non-Bonded Configuration
• 4-3        Example of Configuring VLAN
• 9-1        Options for the Secure Erase Tool
• 10-1      Sample output of TDE-enabled database registered in bare metal deployments
• 10-2      Sample output of TDE-enabled database registered in Oracle Database Appliance DB System deployments
• 10-3      Sample output of TDE-enabled database registered in Oracle Database Appliance when password-protected wallet (ewallet.p12) exists but not the autologin TDE wallet (cwallet.sso)
• 16-1      JSON File to Create a Single-Node Oracle KVM Database System with Role Separation
• 16-2      JSON File to Create a Single-Node Oracle KVM Database System without Role Separation
• 16-3      JSON File to Create Two-Node Oracle KVM Database System without Role Separation
• 16-4      JSON File to Create Two-Node Oracle KVM Database System with Role Separation
• 17-1      Example of Showing the Status of All Shared Repositories
• 17-2      Example of Showing the Status of a Selected Shared Repository
• 17-3      Example of Starting a Shared Repository
• 17-4      Example of Stopping a Shared Repository
• 17-5      Example of Deleting a Shared Repository
• 17-6      Example of Increasing the Size of a Shared Repository
• 17-7      Example of Creating a Shared Virtual Disk
• 17-8      Example of Displaying the Information for All Vdisks
• 17-9      Example of Displaying Information for a Single Vdisk
• 17-10    Example of Cloning a Virtual Disk
• 17-11    Example of Attaching a Virtual Disk To a Virtual Machine
• 17-12    Example of Deleting a Virtual Disk from a Shared Repository
• 17-13    Example of Importing Virtual Machine Templates from an External Repository Assembly File
• 17-14    Example of Importing a Virtual Machine Template from Dom0
• 17-15    Example of Importing a Virtual Machine Template Using an External Repository URL
• 17-16    Example of Creating a Virtual Machine Clone from a Virtual Machine Template
• 17-17    Example of Creating a Snap Clone From a Virtual Machine Template
• 17-18    Example of Creating a Snap Clone From an Existing Virtual Machine
• 17-19    Example of Configuring a Virtual Machine
• 17-20    Example of Migrating a Virtual Machine from the Currently Running Node to Another Node
• 17-21    Example of Showing CPU Pools on a Node
• 17-22    Example of Creating a New CPU Pool on Oracle Database Appliance Virtualized Platform Nodes
• 17-23    Example of Showing CPUs Assigned to Defined CPU Pools on Oracle Database Appliance Virtualized Platform Nodes
• 17-24    Example of Changing the Number of CPUs Assigned to a CPU Pool on Oracle Database Appliance Virtualized Platform Nodes
• 17-25    Example of Assigning a Virtual Machine to a CPU Pool on Oracle Database Appliance Virtualized Platform
• 18-1      Command-Line Interface Syntax
• 18-2      SUDO Example 1: Allow a User to Perform Any ODACLI Operation
• 18-3      SUDO Example 2: Allow a User to Perform Only Selected ODACLI Operations
• 18-4      Configuring the First Network as a Bonded Network
• 18-5      Configuring the First Network as a Non-Bonded Network
• 18-6      Configure PMEM
• 18-7      Creating a Network
• 18-8      Creating a VLAN Network
• 18-9      Deleting a Network
• 18-10    Deleting a Network Interface
• 18-11    Deleting btbond1 Network Interface is Not Allowed
• 18-12    Deleting Network Interface When Network Exists is Not Allowed
• 18-13    Displaying Network Details
• 18-14    Displaying Network Details
• 18-15    Displaying Network Details
• 18-16    Displaying a List of Networks
• 18-17    Displaying a List of Network Interfaces
• 18-18    Updating a Network
• 18-19    
• 18-20    
• 18-21    
• 18-22    
• 18-23    
• 18-24    
• 18-25    
• 18-26    
• 18-27    
• 18-28    
• 18-29    
• 18-30    
• 18-31    
• 18-32    
• 18-33    
• 18-34    
• 18-35    
• 18-36    
• 18-37    
• 18-38    
• 18-39    
• 18-40    
• 18-41    Deleting RDBMS and GI components for a specific release
• 18-42    Deleting Clone Files
• 18-43    Creating Pre-Check Report
• 18-44    Patch pre-checks report with rolling mode patching supported when Expander or Controller upgrade is not required
• 18-45    Patch pre-checks report with rolling mode patching not supported when Expander or Controller upgrade is required
• 18-46    Displaying the Patch Pre-Checks Report for Operating System, Oracle Grid Infrastructure, and ORAchk
• 18-47    Example of a successful patch pre-checks report
• 18-48    Displaying All Patch Pre-Checks Reports
• 18-49    Deleting A Patch Pre-Checks Report
• 18-50    Displaying All Patch Pre-Checks Reports
• 18-51    Displaying local and shared storage components and the required updates
• 18-52    Displaying patch details for components for High-Availability Oracle Database Appliance Systems for a release
• 18-53    List DB Home Details
• 18-54    List the Server Components and Versions
• 18-55    Listing the Latest Supported Versions
• 18-56    Displaying the HttpProxyPort
• 18-57    Displaying the agent configuration
• 18-58    Displaying Oracle ASM configuration
• 18-59    Setting Multiple Parameters
• 18-60    Setting Oracle RDBMS Parameters
• 18-61    Updating the RDBMS Parameter for all DB systems in the Bare Metal System
• 18-62    Deleting configuration parameters
• 18-63    Deleting processes configuration parameter
• 18-64    Updating an Oracle Database Home
• 18-65    Updating DCS Admin
• 18-66    Updating the Agent
• 18-67    Updating DCS Components
• 18-68    Updating the Registry with the -force option
• 18-69    Updating the Repository
• 18-70    Updating the Server
• 18-71    Updating the Storage
• 18-72    Running odaadmcli orachk
• 18-73    Running odaadmcli orachk for a component
• 18-74    Resetting the oda-admin Password in Interactive Mode
• 18-75    Example Command to View the Bill of Materials from the Command Line for Bare Metal Deployments
• 18-76    Example Command to View the Features Report from the Command Line
• 18-77    Create a Manual Database Backup
• 18-78    Create a Level 0 Database Backup
• 18-79    Create a Backup of only the TDE Wallet
• 18-80    Create a Backup of the database and TDE Wallet
• 18-81    Create a Backup Configuration for disk
• 18-82    Create a Backup Configuration for NFS location
• 18-83    Create a Backup Configuration with separate backup locations for database backup and TDE Wallet backup
• 18-84    Create a Backup Configuration with single backup location for database backup
• 18-85    Delete a Level 0 or Level 1 Backup
• 18-86    Delete a Long Term Backup Report
• 18-87    Deleting a Backup Configuration
• 18-88    Display Details of a Specific Backup Report
• 18-89    Deleting the Oracle Object Store Credentials
• 18-90    Display Schedule Details
• 18-91    Restoring a Database to the Same System
• 18-92    Restoring a Database to a Different System
• 18-93    Restoring a Database with TDE Wallet backup from a backup report
• 18-94    Restoring a Database with TDE Wallet backup specified on the CLI
• 18-95    Restoring to a standby database when Oracle Data Guard is configured
• 18-96    Recovering a Database that was associated with a CPU Pool
• 18-97    Displaying a List of Backup Configuration
• 18-98    Display a List of all Backup Reports
• 18-99    Displaying a List of ObjectStore Swift Credentials
• 18-100  Display a List of Scheduled Database Backups
• 18-101  Viewing the TDE backup report
• 18-102  Recovering a Database to a Point-in-Time
• 18-103  Recovering a Database to the latest
• 18-104  Recovering a Database to an SCN
• 18-105  Restoring the TDE Wallet while performing database recovery, if TDE wallets are lost
• 18-106  Recovering a Database that was associated with a CPU Pool
• 18-107  Restoring archivelog
• 18-108  Restoring TDE wallet for a database from a backup location
• 18-109  Revise a Backup Configuration for Disk
• 18-110  Changing the Oracle Casper ObjectStore Password
• 18-111  Changing the Oracle ObjectStore User Name
• 18-112  Change What Time the Backup Occurs
• 18-113  Disable Scheduled Database Backups
• 18-114  Configuring Oracle Data Guard interactively on the commad line
• 18-115  Configuring Oracle Data Guard using JSON file
• 18-116  Sample JSON for configuring Oracle Data Guard on Oracle Database Appliance High-Availability Deployments
• 18-117  Deconfiguring Oracle Data Guard on the Primary Machine
• 18-118  Viewing Oracle Data Guard configuration status
• 18-119  Performing Failover Oracle Data Guard
• 18-120  Viewing Oracle Data Guard status on primary and standby databases
• 18-121  Performing reinstate operation on Oracle Data Guard
• 18-122  Switching over Oracle Data Guard
• 18-123  Displaying a List of Cores
• 18-124  Displaying the Current Core Configuration
• 18-125  Enabling CPU Cores
• 18-126  Cloning a Database
• 18-127  Cloning a Database and associating it with the same CPU Pool as the parent database
• 18-128  Cloning a Database and associating it with a different CPU Pool
• 18-129  Cloning a TDE-Enabled Database
• 18-130  Creating a TDE-enabled database
• 18-131  Creating a Database in Interactive Mode
• 18-132  Creating a Database Against a Different Version
• 18-133  Creating a Database associated with a CPU Pool
• 18-134  Deleting a Database Named hrmsdb
• 18-135  
• 18-136  Displaying Database Details
• 18-137  Displaying a List of Databases
• 18-138  Modifying the Database Shape (Template) and Database Class
• 18-139  Converting Oracle RAC or Oracle RAC One Node Database to Single-instance Oracle Database
• 18-140  Specifying the target node when converting database
• 18-141  Changing the TDE Wallet Password
• 18-142  Re-keying the TDE Master Encryption Password
• 18-143  Removing a CPU pool
• 18-144  Moving a Database from one Oracle home to another
• 18-145  Registering a Migrated Database
• 18-146  Upgrading an Oracle Database
• 18-147  Creating Database Home Storage
• 18-148  Listing Database Home Storage on a Single-Node System
• 18-149  Listing Database Home Storage on a High-Availability System
• 18-150  Describing Database Home Storage
• 18-151  Modifying Database Home Storage
• 18-152  Creating an Oracle Database Home
• 18-153  Deleting an Empty Database Home
• 18-154  Displaying Oracle Database Home Details
• 18-155  Displaying a List of Oracle Home Directories
• 18-156  Creating Database Storage
• 18-157  Deleting Empty Database Storage
• 18-158  Displaying Database Oracle ACFS Storage Details
• 18-159  Displaying Database Oracle ASM Storage Details
• 18-160  Displaying Disk Group Storage
• 18-161  Displaying a List of all Database Storage
• 18-162  Displaying Disk Group Storage
• 18-163  Modifying the Database Storage
• 18-164  Releasing a physical disk HDD_E0_S10_577135552 which has two logical partitions on two different disk groups
• 18-165  Creating a default policy to purge all the jobs and scheduled executions older than 30 days
• 18-166  Set up a retention policy of 10 days for the schedule 'archive_log_backup'
• 18-167  Creating a job to purge job data
• 18-168  Purging job data older than 5 hours, including all jobs and scheduled executions related records
• 18-169  Purging job data for multiple jobs
• 18-170  Purging job data for specific job data schedules older than 5 days
• 18-171  Deleting the job data retention policies
• 18-172  Displaying Details for a Job
• 18-173  Displaying a List of Jobs
• 18-174  Displaying Specified Number of Older Jobs
• 18-175  Displaying Jobs in a Date Range
• 18-176  Listing all job retention policies
• 18-177  Listing history, statistics, and rules for job data purge jobs
• 18-178  Displaying a List of Scheduled and Executed Jobs
• 18-179  Masking Sensitive Data in Log Collection
• 18-180  Creating Automatic Jobs to Purge Logs
• 18-181  Creating Jobs to Purge Logs
• 18-182  Displaying Log Cleanup Jobs
• 18-183  Listing Jobs to Purge Logs
• 18-184  Listing Jobs to Purge Logs
• 18-185  Displaying a List of Logs
• 18-186  Configuring Oracle ASR with a Proxy Server
• 18-187  Configuring an External Oracle ASR
• 18-188  Deleting Oracle ASR From the System
• 18-189  Displaying Oracle ASR Details
• 18-190  Testing the Oracle ASR Configuration
• 18-191  Updating Oracle ASR with a New Proxy Server
• 18-192  Displaying a List of Configured and Suggested Memlock and HugePage Configurations
• 18-193  Updating the HugePage and Memlock Parameters to the Suggested Values
• 18-194  Displaying Environment and Hardware Details
• 18-195  Displaying Filesystem Details
• 18-196  Display Memory Details
• 18-197  Showing Network Details
• 18-198  Displaying Power Supply Details
• 18-199  Displaying Processor Details
• 18-200  Displaying Server Details
• 18-201  Listing All Available Disks on the System
• 18-202  Listing Disks with the Specified Disk Path on the System
• 18-203  Powering a Disk Off
• 18-204  Checking the Disk Status
• 18-205  Showing Controller Details
• 18-206  Displaying the Status of All Disks
• 18-207  Displaying the Status of a Single Disk
• 18-208  Listing All Diskgroups
• 18-209  Displaying DATA Configurations
• 18-210  Displaying the RAID SYNC Status
• 18-211  Displaying Storage Devices
• 18-212  Displaying NVMe Details
• 20-1      Preparing a Copy of the Configuration File
• 20-2      Creating a New Database Showing Prompts
• 20-3      Creating a New Database in an Existing Oracle Home
• 20-4      Creating a New Database from a Template
• 20-5      Deleting a Network
• 20-6      Deploying the Complete Oracle Database Appliance
• 20-7      Running the Configurator
• 20-8      Running the Offline Configurator with Advance Mode
• 20-9      Preloading an Existing Configuration File
• 20-10    Changing a User Group Name or ID
• 20-11    Viewing the Log File
• 20-12    Expanding Storage
• 20-13    Displaying the Write Cache Status of Disks
• 20-14    Locating an Oracle ASM Disk by Turning on the Disk’s LED
• 20-15    Example Command to View the Bill of Materials from the Command Line for Virtualized Platforms Deployments
• 20-16    Modifying the Database Type
• 20-17    Modifying the Database Size
• 20-18    Viewing the Current and Suggested Kernel Parameters
• 20-19    Reconfiguring the Kernel Based on Available RAM
• 20-20    Increasing the Size of the DATA Volume
• 20-21    Displaying Database Details
• 20-22    Displaying Database Details for Four Databases
• 20-23    Displaying DB Home Details
• 20-24    Displaying DB Home Details
• 20-25    Oracle Database Appliance with Non-CDB Databases
• 20-26    Displaying Information About the Local Disks
• 20-27    Displaying Information About the Shared Disks
• 20-28    Displaying Information About a Specific Shared Disk
• 20-29    Determining Which Node is the First Node
• 20-30    Displaying Power Supply Information
• 20-31    Displaying the Available Virtual Machine Repositories
• 20-32    Displaying Details About a Specific Shared Repository
• 20-33    Determining if Storage Validation is Enabled
• 20-34    Starting ODA_BASE on the Local Node
• 20-35    Starting a Shared Repository on Node 0
• 20-36    Forcing a Virtual Machine to Stop
• 20-37    Stopping a Shared Repository
• 20-38    Stopping the Local ODA_Base
• 20-39    Running Diagnostic Tests on a Disk in the Expansion Storage Shelf
• 20-40    Unpacking Packages into the Oracle Appliance Manager Repository
• 20-41    Verify the Contents of a Patch Bundle
• 20-42    Enabling 12 CPU Cores for Oracle Database Appliance
• 20-43    Enabling All CPU Cores for Oracle Database Appliance
• 20-44    Cloning a Virtual Disk
• 20-45    Displaying Information for All Virtual Disks
• 20-46    Displaying Information for a Single Virtual Disk
• 20-47    Creating a Virtual Machine Image
• 20-48    Creating a Virtual Machine Image in Driver Domain Mode
• 20-49    Sending a Message to a Running Virtual Machine
• 20-50    Displaying Details for All Virtual Machines
• 20-51    Displaying Information for a Single Virtual Machine
• 20-52    Opening a Virtual Machine Console
• 20-53    Starting a Virtual Machine on Node 0
• 20-54    Importing a Virtual Machine Template from Dom0
• 20-55    Importing a Virtual Machine Template from a Remote Server
• 20-56    Importing Virtual Machine Templates from an Assembly on a Remote Server
• 20-57    Importing Virtual Machine Templates Into a Shared Repository From an Assembly on a Remote Server
• 20-58    Modifying the Network Defined in a Virtual Machine Template
• 20-59    Display Information About a Virtual Template
• 20-60    Displaying Details of Available Virtual Area Networks (VLANs)
• 21-1      Example Command to View the Bill of Materials from the Command Line for Bare Metal Deployments
• 21-2      Example Command to View the Bill of Materials from the Command Line for Virtualized Platforms
• 21-3      Example Command to View the Bill of Materials Report from the Stored Location
• 21-4      Block dumps before redaction
• 21-5      Block dumps after redaction
• 21-6      Redo dumps before redaction
• 21-7      Redo dumps after redaction
• 21-8      Describing current status of ACR
• 21-9      Enabling ACR:
• 21-10    Disabling ACR
• 21-11    Enabling ACR during provisioning of the appliance
• 21-12    Masking or Sanitizing Sensitive Data in a Specific Collection
• 21-13    Sanitizing Sensitive Information in Specific Collection IDs
• 21-14    Sanitizing a File with Relative Path
• 21-15    Sanitizing Oracle Autonomous Health Framework Debug Log
• 21-16    Running Full Sanity Check
• 21-17    Printing the Reverse Map of Sanitized Elements
• 21-18    Collecting log file information for a time period, masking sensitive data
• C-1        Oracle ACFS Storage Space
• C-2        Determining Storage on the DATA Disk Group
• D-1        JSON File to Create a Single Node Oracle Database Appliance with Role Separation
• D-2        JSON File to Create a Single Node Oracle Database Appliance without Role Separation
• D-3        JSON File to Create a Multi-Node Oracle Database Appliance with Role Separation