List of Examples

• 4-1        Example of a Bonded Configuration
• 4-2        Example of Configuring VLAN
• 5-1        JSON File to Create a Single Node Oracle Database Appliance with Role Separation and Passwordless Multi-User Access
• 5-2        JSON File to Create a Single Node Oracle Database Appliance without Role Separation and with Passwordless Multi-User Access
• 5-3        JSON File to Create a High-Availability Oracle Database Appliance with Role Separation and with Passwordless Multi-User Access
• 5-4        JSON File to Create a Single-Node Oracle KVM Database System with Role Separation and Passwordless Multi-User Access
• 5-5        JSON File to Create a Single-Node Oracle KVM Database System without Role Separation and with Passwordless Multi-User Access
• 5-6        JSON File to Create Two-Node Oracle KVM Database System without Role Separation and with Passwordless Multi-User Access
• 5-7        JSON File to Create Two-Node Oracle KVM Database System with Role Separation and with Passwordless Multi-User Access
• 7-1        Options for the Secure Erase Tool
• 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 a Single-Node Oracle KVM Database System with the --template/-t option
• 16-4      JSON File to Create a Single-Node Oracle KVM Database System with the --template-annotated/-ta option
• 16-5      JSON File to Create a High-Availability DB system without Role Separation
• 16-6      JSON File to Create a High-Availability DB system with Role Separation
• 16-7      JSON File to Create a High-Availability DB system with Standard Edition High-Availability Enabled
• 16-8      JSON File to Create a High-Availability DB system with Oracle RAC Database
• 16-9      JSON File to Create a High-Availability DB system with the --template/-t option
• 16-10    JSON File to Create a High-Availability DB system with the --template/-t option
• 16-11    JSON File to Create a High-Availability DB system with the --template-annotated/-ta option
• 17-1      SUDO Example 1: Allow a User to Perform Any ODACLI Operation
• 17-2      SUDO Example 2: Allow a User to Perform Only Selected ODACLI Operations
• 17-3      Configuring the First Network as a Bonded Network
• 17-4      Configuring the First Network as a Non-Bonded Network
• 17-5      Configuring the Speed of the Network Interface
• 17-6      Creating a Network
• 17-7      Creating a VLAN Network
• 17-8      Deleting a Network
• 17-9      Deleting a Network Interface
• 17-10    Deleting btbond1 Network Interface is Not Allowed
• 17-11    Deleting Network Interface When Network Exists is Not Allowed
• 17-12    Displaying Network Details
• 17-13    Displaying Network Details
• 17-14    Displaying Network Details
• 17-15    Displaying a List of Networks
• 17-16    Displaying a List of Network Interfaces
• 17-17    Modifying a Network
• 17-18    
• 17-19    
• 17-20    
• 17-21    
• 17-22    
• 17-23    
• 17-24    
• 17-25    
• 17-26    
• 17-27    
• 17-28    
• 17-29    
• 17-30    
• 17-31    
• 17-32    
• 17-33    
• 17-34    
• 17-35    
• 17-36    
• 17-37    
• 17-38    
• 17-39    
• 17-40    Deleting RDBMS and GI components for a specific release
• 17-41    Deleting Clone Files
• 17-42    Creating Pre-Check Report
• 17-43    Creating Pre-Check Report for Updating Database and Applying Datapatch
• 17-44    Patch pre-checks report with rolling mode patching supported when expander upgrade is not required
• 17-45    Patch pre-checks report with rolling mode patching not supported when expander upgrade is required
• 17-46    Displaying the Patch Pre-Checks Report for Operating System, Oracle Grid Infrastructure, and ORAchk
• 17-47    Pre-checks report for storage
• 17-48    Pre-checks report for updating database home
• 17-49    Displaying All Patch Pre-Checks Reports
• 17-50    Deleting A Patch Pre-Checks Report
• 17-51    Displaying All Available Patches on Bare Metal System
• 17-52    Displaying All Available Patches on DB System
• 17-53    Displaying patch details for components for High-Availability Oracle Database Appliance Systems for a release
• 17-54    List DB Home Details
• 17-55    List the Server Components and Versions
• 17-56    Listing the Latest Supported Versions
• 17-57    Displaying the HttpProxyPort
• 17-58    Displaying the agent configuration
• 17-59    Displaying Oracle ASM configuration
• 17-60    Setting Multiple Parameters
• 17-61    Setting Oracle RDBMS Parameters
• 17-62    Updating the RDBMS Parameter for all DB systems in the Bare Metal System
• 17-63    Deleting configuration parameters
• 17-64    Deleting processes configuration parameter
• 17-65    Updating an Oracle Database
• 17-66    Updating an Oracle Database Home
• 17-67    Updating DCS Admin
• 17-68    Updating the Agent
• 17-69    Updating DCS Components
• 17-70    Update Registry Report
• 17-71    Updating the Repository
• 17-72    Updating the Server
• 17-73    Updating the Storage
• 17-74    Running odaadmcli orachk
• 17-75    Running odaadmcli orachk for a component
• 17-76    Creating a diagnostics collection
• 17-77    Command output details
• 17-78    Command output details on Oracle Database Appliance high-availability system
• 17-79    Command output details on Oracle Database Appliance single-node system
• 17-80    Command output details on bare metal system and DB system
• 17-81    Resetting the oda-admin Password in Interactive Mode
• 17-82    Example Command to View the Bill of Materials from the Command Line for Bare Metal Deployments
• 17-83    
• 17-84    
• 17-85    Example Command to View the Features Report from the Command Line
• 17-86    Create a Manual Database Backup
• 17-87    Create a Level 0 Database Backup
• 17-88    Create a Backup of only the TDE Wallet
• 17-89    Create a Backup of the database and TDE Wallet
• 17-90    Create a Backup Configuration for disk
• 17-91    Create a Backup Configuration for NFS location
• 17-92    Create a Backup Configuration with separate backup locations for database backup and TDE Wallet backup
• 17-93    Create a Backup Configuration with single backup location for database backup
• 17-94    Describing a Backup Configuration
• 17-95    Delete a Level 0 or Level 1 Backup
• 17-96    Delete a Long Term Backup Report
• 17-97    Deleting a Backup Configuration
• 17-98    Backup report for a TDE-enabled database (contains a keystoreType attribute)
• 17-99    Display Details of a Specific Backup Report
• 17-100  Describing the Swift Object Store
• 17-101  Deleting the Oracle Object Store Credentials
• 17-102  Display Schedule Details
• 17-103  Restoring a Database to the Same System
• 17-104  Restoring a Database to a Different System
• 17-105  Restoring a Database with TDE Wallet backup from a backup report
• 17-106  Restoring a Database with TDE Wallet backup specified on the CLI
• 17-107  Restoring to a standby database when Oracle Data Guard is configured
• 17-108  Recovering a Database that was associated with a CPU Pool
• 17-109  Recovering a Database that was associated with a CPU Pool
• 17-110  Displaying a List of Backup Configuration
• 17-111  Display a List of all Backup Reports
• 17-112  Displaying a List of ObjectStore Swift Credentials
• 17-113  Display a List of Scheduled Database Backups
• 17-114  Viewing the TDE backup report
• 17-115  Recovering a Database to a Point-in-Time
• 17-116  Recovering a Database to the latest
• 17-117  Recovering a Database to an SCN
• 17-118  Restoring a TDE wallet when performing database recovery is not supported for TDE-enabled databases with TDE keys stored in Oracle Key Vault
• 17-119  Restoring the TDE Wallet while performing database recovery, if TDE wallets are lost
• 17-120  Recovering a Database that was associated with a CPU Pool
• 17-121  Restoring archivelog
• 17-122  Restoring TDE wallet for a database from a backup location
• 17-123  Revise a Backup Configuration for Disk
• 17-124  Changing the Oracle Casper ObjectStore Password
• 17-125  Changing the Oracle ObjectStore User Name
• 17-126  Modify the Time the Backup Occurs
• 17-127  Disable Scheduled Database Backups
• 17-128  Configuring Oracle Data Guard interactively on the command line
• 17-129  Configuring Oracle Data Guard with two standby configurations
• 17-130  Configuring Oracle Data Guard using JSON file
• 17-131  Sample JSON for configuring Oracle Data Guard with two standby databases
• 17-132  Deconfiguring Oracle Data Guard with one standby database
• 17-133  Viewing Oracle Data Guard configuration status
• 17-134  Performing Failover Oracle Data Guard
• 17-135  Viewing Oracle Data Guard status on primary and standby databases
• 17-136  Performing reinstate operation on Oracle Data Guard
• 17-137  Switching over Oracle Data Guard
• 17-138  Displaying a List of Cores
• 17-139  Displaying the Current Core Configuration
• 17-140  Enabling CPU Cores
• 17-141  Cloning a Database in a new database home
• 17-142  Cloning a Database in an existing database home
• 17-143  Cloning a Database and associating it with the same CPU Pool as the parent database
• 17-144  Cloning a Database and associating it with a different CPU pool
• 17-145  Cloning a TDE-enabled database
• 17-146  Cloning a database and opening the clone in read only mode
• 17-147  Creating a TDE-Enabled Database with Software Keystore
• 17-148  Creating a Database in Interactive Mode
• 17-149  Creating a Database Against a Different Version
• 17-150  Creating a Database associated with a CPU Pool
• 17-151  Creating a TDE-Enabled Database with Credentials of a User on Oracle Key Vault
• 17-152  Creating a TDE-Enabled Database with keys stored in Oracle Key Vault
• 17-153  Deleting a Database Named hrmsdb
• 17-154  
• 17-155  Displaying Database Details
• 17-156  Displaying a List of Databases
• 17-157  Modifying the Database Shape (Template) and Database Class
• 17-158  Converting Oracle RAC or Oracle RAC One Node Database to Single-instance Oracle Database
• 17-159  Specifying the target node when converting database
• 17-160  Changing the TDE Wallet Password
• 17-161  Re-keying the TDE Master Encryption Password
• 17-162  Removing a CPU pool
• 17-163  Moving a Database from one Oracle home to another
• 17-164  Registering a TDE-enabled Database with TDE keys stored on Oracle Key Vault
• 17-165  Registering a TDE-enabled Database with TDE keys stored on Oracle Key Vault
• 17-166  Registering a Migrated Database
• 17-167  Upgrading an Oracle Database
• 17-168  Creating Database Home Storage
• 17-169  Listing Database Home Storage on a Single-Node System
• 17-170  Listing Database Home Storage on a High-Availability System
• 17-171  Describing Database Home Storage
• 17-172  Modifying Database Home Storage
• 17-173  Creating an Oracle Database Home
• 17-174  Deleting an Empty Database Home
• 17-175  Displaying Oracle Database Home Details
• 17-176  Displaying a List of Oracle Home Directories
• 17-177  Creating Database Storage
• 17-178  Deleting Empty Database Storage
• 17-179  Displaying Database Oracle ACFS Storage Details
• 17-180  Displaying Database Oracle ASM Storage Details
• 17-181  Displaying Disk Group Storage
• 17-182  Displaying a List of all Database Storage
• 17-183  Displaying Disk Group Storage
• 17-184  Modifying the Database Storage
• 17-185  Releasing a physical disk HDD_E0_S10_577135552 which has two logical partitions on two different disk groups
• 17-186  Creating a diagnostics collection
• 17-187  Describing a diagnostics collection
• 17-188  Listing all diagnostics collections
• 17-189  Deleting a diagnostics collection
• 17-190  Creating a default policy to purge all the jobs and scheduled executions older than 30 days
• 17-191  Set up a retention policy of 10 days for the schedule 'archive_log_backup'
• 17-192  Creating a job to purge job data
• 17-193  Purging job data older than 5 hours, including all jobs and scheduled executions related records
• 17-194  Purging job data for multiple jobs
• 17-195  Purging job data for specific job data schedules older than 5 days
• 17-196  Deleting the job data retention policies
• 17-197  Displaying Details for a Job
• 17-198  Viewing Error Correlation Report
• 17-199  Displaying a List of Jobs
• 17-200  Displaying Specified Number of Older Jobs
• 17-201  Displaying Jobs in a Date Range
• 17-202  
• 17-203  Listing all job retention policies
• 17-204  Listing history, statistics, and rules for job data purge jobs
• 17-205  Displaying a List of Scheduled and Executed Jobs
• 17-206  Creating an Oracle Key Vault server configuration
• 17-207  Copying the TDE wallet in the same Oracle Key Vault server and owned by the same Oracle Key Vault user
• 17-208  Copying the TDE wallet on the same Oracle Key Vault server but using a different Oracle Key Vault user
• 17-209  Copying the TDE wallet to a different Oracle Key Vault server
• 17-210  Deleting Oracle Key Vault server configuration
• 17-211  Viewing Oracle Key Vault server configuration details in a multi-user access enabled system
• 17-212  Viewing Oracle Key Vault server configuration details in a non-multi user access enabled system
• 17-213  Viewing Oracle Key Vault server configuration details with the -j option
• 17-214  Viewing all Oracle Key Vault server configurations
• 17-215  Masking Sensitive Data in Log Collection
• 17-216  Creating Automatic Jobs to Purge Logs
• 17-217  Creating Jobs to Purge Logs
• 17-218  Displaying Log Cleanup Jobs
• 17-219  Listing Jobs to Purge Logs
• 17-220  Listing Jobs to Purge Logs
• 17-221  Displaying a List of Logs
• 17-222  Configuring Oracle ASR with a Proxy Server
• 17-223  Configuring an External Oracle ASR
• 17-224  Displaying Oracle ASR Details for ASR Type Internal
• 17-225  Deleting Oracle ASR From the System
• 17-226  Exporting the Internal Oracle ASR Configuration
• 17-227  Modifying Oracle ASR to use a New Proxy Server
• 17-228  Testing the Oracle ASR Configuration
• 17-229  
• 17-230  
• 17-231  
• 17-232  
• 17-233  
• 17-234  Displaying a List of Configured and Suggested Memlock and HugePage Configurations
• 17-235  Updating the HugePage and Memlock Parameters to the Suggested Values
• 17-236  Displaying Environment and Hardware Details
• 17-237  Displaying Filesystem Details
• 17-238  Display Memory Details
• 17-239  Showing Network Details
• 17-240  Displaying Power Supply Details
• 17-241  Displaying Processor Details
• 17-242  Displaying Server Details
• 17-243  Listing All Available Disks on the System
• 17-244  Listing Disks with the Specified Disk Path on the System
• 17-245  Powering a Disk Off
• 17-246  Checking the Disk Status
• 17-247  Showing Controller Details
• 17-248  Displaying the Status of All Disks
• 17-249  Displaying the Status of a Single Disk
• 17-250  Listing All Diskgroups
• 17-251  Displaying DATA Configurations
• 17-252  Displaying the RAID SYNC Status
• 17-253  Displaying Storage Devices
• 17-254  Displaying NVMe Details
• 20-1      Example Command to View the Bill of Materials from the Command Line for Bare Metal Deployments
• 20-2      Example Command to View the Bill of Materials from the Command Line for Virtualized Platforms
• 20-3      Example Command to View the Bill of Materials Report from the Stored Location
• 20-4      Block dumps before redaction
• 20-5      Block dumps after redaction
• 20-6      Redo dumps before redaction
• 20-7      Redo dumps after redaction
• 20-8      Describing current status of ACR
• 20-9      Enabling ACR:
• 20-10    Disabling ACR
• 20-11    Enabling ACR during provisioning of the appliance
• 20-12    Masking or Sanitizing Sensitive Data in a Specific Collection
• 20-13    Sanitizing Sensitive Information in Specific Collection IDs
• 20-14    Sanitizing a File with Relative Path
• 20-15    Sanitizing Oracle Autonomous Health Framework Debug Log
• 20-16    Running Full Sanity Check
• 20-17    Printing the Reverse Map of Sanitized Elements
• 20-18    Collecting log file information for a time period, masking sensitive data
• B-1        Oracle ACFS Storage Space
• B-2        Determining Storage on the DATA Disk Group
• C-1        JSON File to Create a Single Node Oracle Database Appliance with Role Separation
• C-2        JSON File to Create a Single Node Oracle Database Appliance without Role Separation
• C-3        JSON File to Create a high-availability Oracle Database Appliance with Role Separation
• C-4        JSON File to Create a high-availability Oracle Database Appliance with Enterprise Edition High Availability Enabled
• C-5        JSON File to Create a high-availability Oracle Database Appliance with Standard Edition High Availability Enabled