Patching Oracle Database Appliance

7 Patching Oracle Database Appliance

To keep Oracle Database Appliance running with the latest software, check for and apply Oracle Database Appliance patch bundles when they are released.

About Patching Oracle Database Appliance
Use the Oracle Database Appliance Patch Bundle to patch your appliance.
About Patching Prechecks
Patching prechecks are designed to detect and flag problems that might be encountered during patching.
About Enabling NUMA on Oracle Database Appliance
Understand how you can enable NUMA on bare metal, KVM, and DB Systems on Oracle Database Appliance.
Minimizing Downtime When Patching Oracle Database Appliance
Understand best practices to minimize downtime when you apply patches to your Oracle Database Appliance deployment.
Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line
Follow these steps to apply patches to your Oracle Database Appliance bare metal deployment and existing Oracle Database homes, using CLI commands.
Patching Oracle Database Appliance DB Systems Using the Command-Line
Follow these steps to apply patches to your Oracle Database Appliance DB system deployment and existing Oracle Database home in the DB system, using CLI commands.
Patching Oracle Database Appliance Bare Metal Systems Using the Browser User Interface
Upload the Oracle Database Appliance Server Patch to the patch repository, deploy the patch bundle using the Browser User Interface, and then update the DCS agent and components using CLI commands.
Patching Oracle Database Appliance DB Systems Using the Browser User Interface
Upload the Oracle Database Appliance Server Patch to the patch repository, deploy the patch bundle using the Browser User Interface, and then update the DCS agent and components using CLI commands.
Updating Oracle Database Appliance Repository with Database Clone Files For Bare Metal Systems
Follow these steps to update the Oracle Database Appliance repository with Oracle Database clone files for the latest release using CLI commands.
Patching Existing Database Homes on Bare Metal Systems Using the Browser User Interface
Use the Browser User Interface to patch database homes to the latest release on bare metal systems.
Patching Non-Provisioned Oracle Database Appliance Systems
Oracle Database Appliance supports patching of non-provisioned single-node or high availablity systems by running odacli update-server command.
Applying Additional Patches and Updates on Bare Metal Systems
Configure additional patch repositories and patch your operating system and databases to ensure that your deployment has the latest updates and security fixes.
Cleaning Up the Patch Repository
Use the Browser User Interface or Command Line Interface to delete obsolete or old patches from the repository.
About Upgrading to a Different Database Home
Understand how to upgrade to a different database home using either the Browser User Interface or odacli commands.
Setting Dynamic Default Parameters
You can set dynamic default parameters using the BUI.

Related Topics

Checklist for Patching Oracle Database Appliance Bare Metal Deployments

About Patching Oracle Database Appliance

Use the Oracle Database Appliance Patch Bundle to patch your appliance.

Patches offer new features and may improve the functionality of existing features.

About Out of Place Patching

Starting with Oracle Database Appliance release 19.11, Oracle Database Appliance uses the out-of-place patching model. This means that a new software Oracle home is created when patching an Oracle Grid Infrastructure or Oracle Database home. Starting with Oracle Database Appliance release 19.11, the patches for Oracle Grid Infrastructure and Oracle Database are available as images. All procedures remain the same.

About MySQL Server and DCS Agent

Starting with Oracle Database Appliance release 19.10, DCS Agent uses MySQL server as its metadata store. MySQL server is automatically installed and configured, during provisioning, when creating the appliance. Similarly, during patching, the odacli update-dcscomponents command automatically installs and configures MySQL server. MySQL server processes do not run with root operating system user account. Instead, MySQL server processes run with a new operating system user account called odamysql. Note that the odamysql operating system user is created only for ownership purposes and the odamysql user account owns only the MySQL directories. The odamysql operating system user cannot log into the appliance. The odamysql operating system user account for MySQL ensures role separation between the user owning Oracle databases on the appliance and the metadata used for DCS operations.

About Oracle Database Appliance Patch Bundles

The Oracle Database Appliance Patch Bundle contains the latest patches for DCS Admin, DCS Components, OAK, Oracle ILOM, firmware, enhancements, and fixes.

The Oracle Database Appliance Release Notes include information about the latest Oracle Database Appliance patch bundle and a list of component versions in the patch bundle. Oracle recommends updating the appliance with the latest Oracle Database Appliance software version to take advantage of new features, fixes, and the latest supported component versions. See the Oracle Database Appliance Release Notes for the upgrade paths.

Caution:

Do not patch Oracle Database Appliance using generic patches for Oracle Grid Infrastructure or Oracle Linux. Also do not use individual infrastructure patches, such as firmware patches. You must only use Oracle Database Appliance patches. If you use patches that are not intended for Oracle Database Appliance, or if you use OPatch, or a similar patching tool, then the metadata maintained by Oracle Database Appliance is not updated, and you cannot complete future patch updates. If you apply out-of-cycle Oracle Database Release Update (RU), then ensure that you also follow the recommendations described in the Readme for the RU.

The patch bundle provides all relevant patches for the entire system, including the following:

Oracle Database Appliance server
BIOS
Hardware drivers
Hardware Management Pack (HMP) and firmware drivers for various components
Oracle Appliance Manager
Oracle Linux
Java Runtime Environment (JRE)
Oracle Integrated Lights Out Manager (Oracle ILOM)
Oracle Auto Service Request (Oracle ASR)
Oracle Intelligent Platform Management Interface (Oracle IPMI)
Network Card Patches for relevant hardware models

About Updating Oracle Linux RPMs

While not recommended, you can update some Oracle Linux RPMs for Oracle Database Appliance. Do not update or customize Oracle Linux kernel, Oracle Optimal Flexible Architecture, Oracle InfiniBand, or related software. Other software may be installed, updated, or customized. However, the Oracle Database Appliance update may not carry newer version dependencies of customized components. Therefore, you might be required to remove and subsequently reapply site-specific changes to successfully update Oracle Database Appliance in the future.

Caution:

For Oracle Database Appliance, do not update the following:

Oracle Linux Kernel (kernel)
Oracle Optimal Flexible Architecture (ofa)
Oracle RDMA packages (oracle-rdma-release)

For storage, do not apply any RPM updates.

Parent topic: Patching Oracle Database Appliance

About Patching Prechecks

Patching prechecks are designed to detect and flag problems that might be encountered during patching.

The prechecks view the state of the appliance, including the version and hardware specific upgrades, verify that the necessary conditions and checks are complete before attempting an upgrade, and identify conditions that might cause an upgrade to fail. You can avoid potential patching problems by correcting the conditions and resolving the issues before applying the patch.

The prechecks commands are available on Oracle Database Appliance release 12.2.1.2.0 or later. Update the DCS Agent to ensure that the latest updated prechecks are available when you run these commands.

Components Verified by Patching Prechecks

Check	Component Verified
System patching prechecks	Checks that the DCS Agent is online on all nodes Checks that there is sufficient space for the update Validates the minimum agent version and validates the patching tag
Server patching prechecks	For operating system: Validates supported versions Validates minimum supported versions Validates patching tag Validates whether patch location is available Verifies OS patch Validates command execution For Oracle ILOM: Validates supported versions Validates minimum supported versions Validates patching tag Validates whether patch location is available Checks for Oracle ILOM patch version Validates Patch location Validates command execution Validates connectivity to Oracle ILOM For Oracle Grid Infrastructure: Validates supported Oracle Grid Infrastructure versions Validates available space Validates whether Oracle Clusterware is running Validates patching tag Validates whether system is provisioned Validates whether Oracle ASM is online Validates the minimum agent version Validates the central inventory Validates patching locks Validates whether clones location exists Validates DB start dependencies Validates DB stop dependencies Validates command execution For Oracle ORAchk: Runs the ORAchk tool that performs operating system level prechecks. Validates command execution For server: Validates whether server patching can be performed in local mode or not Validates command execution Confirms that the bare metal system is upgraded, in the case of DB systems. Verifies and confirms that the database start/stop dependencies are correct. Confirms that patching locks are not present. Verifies that the central inventory is accurate.
Database home patching prechecks	Confirms that Oracle Grid Infrastructure is installed Confirms that the DCS Agent is at the required version Confirms that Oracle Clusterware is running on all nodes Confirms that Oracle Grid Infrastructure is upgraded Validates that there is sufficient disk space available Checks if the disk group for database homes on Oracle ACFS is configured Checks whether the clone file is present in the repository Checks whether the `/u01/app/odaorabase` directory exists. If the directory exists, then the check confirms that there is a valid symbolic link.
Database home patching with out-of-place patching prechecks	The check creates a database home and verifies that all databases can be moved from the source home to new home. This check validates that the `--local` option can be used for the database home.
Storage prechecks	Validates storage patch location and tag Validates patching location and tag Validates command execution Validates Oracle ASM disk groups status Validates rolling patch (for high-availability deployment)

Parent topic: Patching Oracle Database Appliance

About Enabling NUMA on Oracle Database Appliance

Understand how you can enable NUMA on bare metal, KVM, and DB Systems on Oracle Database Appliance.

NUMA (Non-Uniform Memory Access) can help facilitate efficient use of the underlying NUMA hardware. On Oracle Database Appliance, you can enable NUMA for databases on bare metal and DB systems, CPU pools, and for KVM applications.

About Enabling NUMA During Provisioning of Oracle Database Appliance

When you provision Oracle Database Appliance with release 19.16, NUMA is automatically enabled on the database, DB system and CPU pools. Hence, when you create a database, DB system, or CPU pool on an Oracle Database Appliance release 19.16 deployment, NUMA is automatically enabled and no additional configuration is required. NUMA is not enabled by default for application VMs.

About Enabling NUMA After Patching Oracle Database Appliance

NUMA is enabled by default on Oracle Database Appliance release 19.12. When you patch to Oracle Database Appliance release 19.16 from 19.11 or earlier, the odacli update-server command sets NUMA at the system level. New databases created after patching are NUMA-enabled. For existing databases, enable NUMA by running the command alter system set "enable_numa_support"=true on the database.

After patching the bare metal system to release 19.16 from 19.11 or earlier, as a one-time activity, you must run the command odacli remap-cpupools to enable NUMA on all existing CPU pools (BM, VM, dbsystem).

For existing DB systems, run the command odacli modify-dbsystem --enable-numa to enable NUMA for the dbsystem and the database of the DB system.

NUMA is not enabled by default for application VMs. For new and existing application VMs, run the command odacli modify-vm --enable-numa to enable NUMA for the VM configuration. You must also enable NUMA for the components inside the VM such as operating system and application running inside the VM. The command odacli modify-dbsystem --enable-numa is only supported on application VMs with even number of CPU cores so that CPU cores can be evenly distributed to NUMA nodes. In Oracle Database Appliance, one CPUcore is equal to 2 vCPU.

See the topic Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line for more details about the steps to patch your deployment and enable NUMA.

Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line

Patching Oracle Database Appliance DB Systems Using the Command-Line

Remapping CPU Pools in a Bare Metal or KVM Deployment

odacli modify-vm

odacli remap-cpupools

odacli modify-dbsystem

odacli create-cpupool

Parent topic: Patching Oracle Database Appliance

Minimizing Downtime When Patching Oracle Database Appliance

Understand best practices to minimize downtime when you apply patches to your Oracle Database Appliance deployment.

Recommendations for Minimizing Downtime During Patching

To minimize database patching downtime, it is recommended that you use Oracle RAC or Oracle RAC One Node on an Oracle Database Appliance high-availability system.
If available, use Oracle Data Guard and patch the standby system first. After you patch the standby system, switch the workload to the standby system, patch the primary system, and then switch the workload back to the primary system.
Always use Oracle Database Appliance Backup and Recovery (ODABR) to back up the system disks to ensure easy restore, if the patching operation fails. ODABR restores the system disk to pre-patching state.
The odacli update-storage command has a --rolling option for storage devices (SSD and HDD) to minimize patching downtime. There could be other shared storage component firmware that require a system restart and do not support rolling. Oracle Database Appliance storage patching can be deferred, but it is not recommended. Note that the --rolling option cannot be used with the odacli update-storage command on single-node Oracle Database Appliance systems.

Minimizing Downtime using the --local Option During Patching

To minimize downtime, use the --local option with the odacli update-server and odacli update-dbhome commands. Update the DCS components and then run the odacli create-prepatchreport command. There is no downtime during the prepatch process. After analyzing the prepatch report, use the --local option to continue patching Oracle Database Appliance.

Patching Oracle Database Appliance Bare Metal Systems Using the Command-Line

Follow these steps to apply patches to your Oracle Database Appliance bare metal deployment and existing Oracle Database homes, using CLI commands.

To patch your Oracle Database Appliance deployment and your existing database homes to the current release, you must download the Oracle Database Appliance Server patch, Oracle Grid Infrastructure clone files, and Oracle Database clone files and update the repository on the bare metal system.

Note:

Run the steps in this procedure in the same order as documented. Run the odacli update-dcsadmin, odacli update-dcscomponents, and

odacli
                    update-dcsagent

commands before running the

odacli
                    update-server

command.

Note:

Note that for DCS Agent update to be complete, both the odacli update-dcscomponents and

odacli
                    update-dcsagent

commands must be run. Ensure that both commands are run in the order specified.

Important:

Ensure that there is sufficient space on your appliance to download the patches.

The Oracle Database Appliance Backup Recovery (ODABR) tool helps recover a system to the pre-patch state, should any potential errors occur during the patching process that may render the system unusable. Download and install the latest version of the Oracle Database Appliance Backup Recovery (ODABR) tool to enable creation of snapshots before patching. See My Oracle Support Note 2466177.1 for the procedure to install ODABR.

https://support.oracle.com/rs?type=doc&id=2466177.1

Follow these steps to apply patches to your Oracle Database Appliance and update existing database homes.

Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 34376263), Oracle Grid Infrastructure clone files (patch 30403673), and Oracle Database clone files (patch 30403662) from My Oracle Support to a temporary location on an external client. Refer to the release notes for details about the patch numbers and software for the latest release.
For example, download the server patch for 19.16:
```
p34376263_1916000_Linux-x86-64.zip
```
Unzip the software — it contains README.html and one or more zip files for the patch.
```
unzip p34376263_1916000_Linux-x86-64.zip
```
The zip file contains the following software file:
```
oda-sm-19.16.0.0.0-date-server.zip
```
Copy all the software files from the external client to Oracle Database Appliance. For High-Availability deployments, copy the software files to only one node. The software files are copied to the other node during the patching process. Use the scp or sftp protocol to copy the bundle.
Example using scp command:
```
# scp software_file root@oda_host:/tmp
```
Example using sftp command:
```
# sftp root@oda_host
```
Enter the root password, and copy the files.
```
put software_file
```

Update the repository with the server software file:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/software_file

For example, for 19.16:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/oda-sm-19.16.0.0.0-date-server.zip

Confirm that the repository update is successful:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID

Update DCS admin:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.16.0.0.0

Update the DCS components:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.16.0.0.0
```
If you are patching from Oracle Database Appliance release 19.9, then the odacli update-dcscomponents command updates the Zookeeper, installs MySQL, migrates metadata from Derby to MySQL and updates other DCS components such as the DCS Agent, DCS CLI, and DCS Controller on Oracle Database Appliance.

If you are patching from Oracle Database Appliance release 19.10 or later, then the odacli update-dcscomponents command updates the Zookeeper, MySQL, and updates other DCS components such as the DCS Agent, DCS CLI, and DCS Controller on Oracle Database Appliance.

If the DCS components are updated, then the message "status" : "Success" is displayed on the command line. For failed updates, fix the error and then proceed with the update by re-running the odacli update-dcscomponents command. See the topic Resolving Errors When Updating DCS Components During Patching about more information about DCS components checks errors.

Note:
Note that for DCS Agent update to be complete, both the odacli update-dcscomponents and odacli update-dcsagent commands must be run. Ensure that both commands are run in the order specified in this procedure.

Update the DCS agent:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.16.0.0.0

Update the repository with the Oracle Grid Infrastructure clone file and the Oracle Database clone file:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/software_file

For example, for 19.16:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-19.16.0.0.0-date-GI-19.16.0.0.zip
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-19.16.0.0.0-date-DB-19.16.0.0.zip

Run patching pre-checks. You must run the odacli create-prepatchreport command before you patch your server; otherwise, the odacli update-server command fails with an error message prompting you to run the patching pre-checks. Note that odacli create-prepatchreport supports the -l option, which runs the prechecks on the local node only. However, to be able to patch the system by running the command odacli update-server, the command odacli create-prepatchreport must be run without the -l option, so that the prechecks can be performed on both nodes before patching is started on any of the two nodes.
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v version
```
For example, for 19.16:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.16.0.0.0
```

Verify that the patching pre-checks ran successfully:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-prepatchreport

For example:

[root@oda1 opt]# odacli describe-prepatchreport -i 20d59005-f7f1-421d-bbb1-bfc4b5a26293
Patch pre-check report                                           
------------------------------------------------------------------------
                 Job ID:  20d59005-f7f1-421d-bbb1-bfc4b5a26293
            Description:  Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER, SERVER]
                 Status:  SUCCESS
                Created:  July 13, 2022 7:31:24 AM HKT
                 Result:  All pre-checks succeeded

Node Name       
---------------
node1 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__OS__ 
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is patch location available     Success   Patch location is available.          
Verify OS patch                 Success   Verified OS patch                     
Validate command execution      Success   Validated command execution           

__ILOM__ 
Validate ILOM server reachable  Success   Successfully connected with ILOM      
                                          server using public IP and USB        
                                          interconnect                          
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.15.0.0.0.  
Is patch location available     Success   Patch location is available.          
Checking Ilom patch Version     Success   Successfully verified the versions    
Patch location validation       Success   Successfully validated location       
Validate command execution      Success   Validated command execution           

__GI__ 
Validate GI metadata            Success   Successfully validated GI metadata    
Validate supported GI versions  Success   Validated minimum supported versions. 
Validate available space        Success   Validated free space under /u01       
Is clusterware running          Success   Clusterware is running                
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate ASM in online          Success   ASM is online                         
Validate kernel log level       Success   Successfully validated the OS log     
                                          level                                 
Validate minimum agent version  Success   GI patching enabled in current        
                                          DCSAGENT version                      
Validate Central Inventory      Success   oraInventory validation passed        
Validate patching locks         Success   Validated patching locks              
Validate clones location exist  Success   Validated clones location             
Validate DB start dependencies  Success   DBs START dependency check passed     
Validate DB stop dependencies   Success   DBs STOP dependency check passed      
Evaluate GI patching            Success   Successfully validated GI patching    
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution           

__SERVER__ 
Validate local patching         Alert     Rolling patching is not possible: in  
                                          IB enabled environments               
Validate command execution      Success   Validated command execution           

Node Name       
---------------
node2 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__OS__ 
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is patch location available     Success   Patch location is available.          
Verify OS patch                 Success   Verified OS patch                     
Validate command execution      Success   Validated command execution           

__ILOM__ 
Validate ILOM server reachable  Success   Successfully connected with ILOM      
                                          server using public IP and USB        
                                          interconnect                          
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is patch location available     Success   Patch location is available.          
Checking Ilom patch Version     Success   Successfully verified the versions    
Patch location validation       Success   Successfully validated location       
Validate command execution      Success   Validated command execution           

__GI__ 
Validate GI metadata            Success   Successfully validated GI metadata    
Validate supported GI versions  Success   Validated minimum supported versions. 
Validate available space        Success   Validated free space under /u01       
Is clusterware running          Success   Clusterware is running                
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate ASM in online          Success   ASM is online                         
Validate kernel log level       Success   Successfully validated the OS log     
                                          level                                 
Validate minimum agent version  Success   GI patching enabled in current        
                                          DCSAGENT version                      
Validate Central Inventory      Success   oraInventory validation passed        
Validate patching locks         Success   Validated patching locks              
Validate clones location exist  Success   Validated clones location             
Validate DB start dependencies  Success   DBs START dependency check passed     
Validate DB stop dependencies   Success   DBs STOP dependency check passed      
Evaluate GI patching            Success   Successfully validated GI patching    
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution           

__SERVER__ 
Validate local patching         Alert     Rolling patching is not possible: in  
                                          IB enabled environments               
Validate command execution      Success   Validated command execution

Use the command odacli describe-prepatchreport to view details of the pre-patch report. Fix the warnings and errors mentioned in the report and proceed with the server patching.

Apply the server update. Note that you can use the --local option with the odacli update-server command to update the local node.
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-server -v version
```
For example, for 19.16:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-server -v 19.16.0.0.0
```
Confirm that the server update is successful:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID
```
Note:
After successful server update, it is recommended that you delete any ODABR snapshot you created before starting the server update. If you want to retain any ODABR snapshot when you update the storage and other components, then consider that the presence of active ODABR snapshots may affect system performance. See My Oracle Support Note 2466177.1 for the procedure to create and delete ODABR snapshots: https://support.oracle.com/rs?type=doc&id=2466177.1

Before you update the storage components, run the

odacli
                        create-prepatchreport

command with the -st option.

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v version

For example, for 19.16:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.16.0.0.0

Verify that the patching pre-checks ran successfully:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-prepatchreport

For example:

[root@oda1 opt]# odacli describe-prepatchreport -i 95887f92-7be7-4865-a311-54318ab385f2

Patch pre-check report                                           
------------------------------------------------------------------------
                 Job ID:  95887f92-7be7-4865-a311-54318ab385f2
            Description:  Patch pre-checks for [STORAGE]
                 Status:  SUCCESS
                Created:  July 13, 2022 12:52:37 PM HKT
                 Result:  All pre-checks succeeded

Node Name       
---------------
node1 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__STORAGE__ 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Patch location validation       Success   Verified patch location               
Patch tag validation            Success   Verified patch tag                    
Storage patch tag validation    Success   Verified storage patch location       
Verify ASM disks status         Success   ASM disks are online                  
Validate rolling patch          Success   Rolling mode patching allowed as      
                                          there is no expander and controller   
                                          upgrade.                              
Validate command execution      Success   Validated command execution           

Node Name       
---------------
node2 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__STORAGE__ 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Patch location validation       Success   Verified patch location               
Patch tag validation            Success   Verified patch tag                    
Storage patch tag validation    Success   Verified storage patch location       
Verify ASM disks status         Success   ASM disks are online                  
Validate rolling patch          Success   Rolling mode patching allowed as      
                                          there is no expander and controller   
                                          upgrade.                              
Validate command execution      Success   Validated command execution

Use the command odacli describe-prepatchreport to view details of the pre-patch report. The pre-patch report also indicates whether storage patching can be rolling or not, based on whether an Expander or Controller update is also required.

Fix the warnings and errors mentioned in the report and proceed with the storage components patching.

Update the storage components.
Specify the --rolling option to patch shared disks in a rolling fashion. Note that if you patch from an Oracle Database Appliance release that requires the expander to be patched, then you cannot use the --rolling option during storage patching.
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-storage -v version --rolling
```
For example, for 19.16:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-storage -v 19.16.0.0.0 --rolling
```
Starting with Oracle Database Appliance release 19.11, Oracle Database homes are not created on the local disk. Oracle Database homes are created on an Oracle ACFS-managed file system. For a database user oracle, the new database homes are created under /u01/app/odaorahome/oracle/.
If the database home is not already configured on Oracle ACFS, then before patching the database home, configure the database home storage with the odacli configure-dbhome-storage command. For example:
```
[root@oda1 opt]# odacli configure-dbhome-storage -dg DATA
```
The command does not cause storage allocation or creation of volumes or file systems. The command only sets the disk group location in the metadata.

For information about managing database homes on Oracle ACFS, see the topic Managing Database Home Storage.

To patch existing Oracle Database Homes to release 19.16:

Ensure that the repository is updated with the Oracle Database clone files. If you have not updated the repository with the Oracle Database clone files, then update the repository. Note that you must update the DCS agent before you update the repository with the Oracle Database clone files.
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/DB_software_file
```
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-19.16.0.0.0-date-DB-19.16.0.0.zip
```

Run the patching pre-checks and review the prepatch report. You must run the odacli create-prepatchreport command before you patch your Oracle Database homes; otherwise, the

odacli
                                update-dbhome

command fails with an error message prompting you to run the patching pre-checks.

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid DB_Home_ID -v release_number
[root@oda1 opt]# odacli describe-prepatchreport -i Job_ID

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid d03d5187-1c20-470a-9d51-49a0d6f60772 -v 19.16.0.0.0
[root@oda1 opt]# odacli describe-prepatchreport -i 6f040374-d271-4711-a7db-e6c04597ad69

Patch pre-check report                                           
------------------------------------------------------------------------
                 Job ID:  6f040374-d271-4711-a7db-e6c04597ad69
            Description:  Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1
                 Status:  SUCCESS
                Created:  July 13, 2022 8:59:48 AM HKT
                 Result:  All pre-checks succeeded

Node Name       
---------------
node1 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__DB__ 
Validate DB Home ID             Success   Validated DB Home ID:                 
                                          d03d5187-1c20-470a-9d51-49a0d6f60772  
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate minimum agent version  Success   Validated minimum agent version       
Is GI upgraded                  Success   Validated GI is upgraded              
Validate available space for    Success   Validated free space required under   
db                                        /u01/app/odaorahome                   
Validate dbHomesOnACFS          Success   User has configured diskgroup for     
configured                                Database homes on ACFS                
Validate Oracle base            Success   Successfully validated Oracle Base    
Is DB clone available           Success   Successfully validated clone file     
                                          exists                                
Evaluate DBHome patching with   Success   Successfully validated updating       
RHP                                       dbhome with RHP.  and local patching  
                                          is possible                           
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution           

Node Name       
---------------
node2 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__DB__ 
Validate DB Home ID             Success   Validated DB Home ID:                 
                                          d03d5187-1c20-470a-9d51-49a0d6f60772  
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate minimum agent version  Success   Validated minimum agent version       
Is GI upgraded                  Success   Validated GI is upgraded              
Validate available space for    Success   Validated free space required under   
db                                        /u01/app/odaorahome                   
Validate dbHomesOnACFS          Success   User has configured diskgroup for     
configured                                Database homes on ACFS                
Validate Oracle base            Success   Successfully validated Oracle Base    
Is DB clone available           Success   Successfully validated clone file     
                                          exists                                
Evaluate DBHome patching with   Success   Successfully validated updating       
RHP                                       dbhome with RHP.                      
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution

If the disk group for database homes on Oracle ACFS is not set up as described in step 17, then the prepatch report lists the error

The system is not set up to create database homes on
                                ACFS

. Run the

odacli
                                configure-dbhome-storage

command to configure the disk group for database homes on Oracle ACFS.

If the pre-patch report does not show any errors, then update the database home to the latest release. You need not use the -f option with the odacli update-dbhome command. Note that you can use the --local option with the odacli update-dbhome command to update the local node.
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid DB_Home_ID -v release_number
```
For example, for 19.16:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e -v 19.16.0.0.0
```

Confirm that the patch jobs are successful:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli list-jobs

If you are patching your appliance from Oracle Database Appliance release 19.11 or earlier, then run the following steps. You must also run these steps if your appliance was previously patched to Oracle Database Appliance release 19.12 or later, but you did not run these steps when patching to release 19.12.
1. After patching the bare metal systems and database homes, enable NUMA (Non-Uniform Memory Access) on existing databases of release 19.12 or earlier, by running the following SQL*Plus command:
```
SQL> alter system set "_enable_numa_support"=true scope=spfile sid='*';
```
  Restart the database after running the command to ensure that the changes take effect.
  
  For more information about enabling NUMA, see the topic About Enabling NUMA on Oracle Database Appliance.
2. If you have deployed DB systems, VMs, or CPU pools, perform the following steps:
  1. Run the odacli remap-cpupools command:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli remap-cpupools
```
    If the odacli remap-cpupools command fails with the error DCS-10001:Internal error encountered: Not enough physical CPUs available for CPU Pool 'cpupool_name' on node 'node_name', run the odacli remap-cpupools command again with the --use_reserved-cores option. For information about the command options, see the chapter Oracle Database Appliance Command-Line Interface for KVM.
  2. If you have DB systems in your deployment, then run the odacli modify-dbsystem command. If you have VMs in your KVM deployment and you want to enable NUMA for the VMs, then run the odacli modify-vm --enable-numa command for VMs. That is:
    For DB systems:
```
odacli modify-dbsystem --enable-numa
```
    For VMs:
```
odacli modify-vm --enable-numa
```
Note:
For bare metal systems and DB systems on Oracle Database Appliance X6-2S, X7-2S, and X8-2S, the database init.ora parameter _enable_numa_support is set to FALSE even when NUMA is enabled. This is expected because these hardware models are single socket systems.

Patching Oracle Database Appliance DB Systems Using the Command-Line

Managing Database Homes on Oracle ACFS Storage

About Creating Database Homes on Oracle ACFS Storage

odacli modify-vm

odacli remap-cpupools

odacli modify-dbsystem

odacli create-cpupool

Parent topic: Patching Oracle Database Appliance

Patching Oracle Database Appliance DB Systems Using the Command-Line

Follow these steps to apply patches to your Oracle Database Appliance DB system deployment and existing Oracle Database home in the DB system, using CLI commands.

To patch your Oracle Database Appliance DB systems deployment and your existing database homes to the current release, you must download the Oracle Database Appliance Server Patch and update the bare metal system repository.

Note:

Run the commands in this topic in the same order as documented. Run the odacli update-dcsadmin, odacli update-dcscomponents, and

odacli
                    update-dcsagent

commands before running the

odacli
                    update-server

command.

Note:

Note that for DCS Agent update to be complete, both the odacli update-dcscomponents and

odacli
                    update-dcsagent

commands must be run. Ensure that both commands are run in the order specified.

Ensure that you have patched your Oracle Database Appliance bare metal deployment to release 19.16 before you patch your DB system.

Follow these steps to apply patches to your Oracle Database Appliance DB system deployment and update the existing database home in the DB system.

Ensure that the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 34376263), Oracle Grid Infrastructure clone files (patch 30403673), and Oracle Database clone files (patch 30403662) are available in the repository. Run the odacli list-availablepatches command in the bare metal system to view whether the clone files are available in the system.
```
[root@oda1 opt]# odacli list-availablepatches
```
Connect to the DB system.

Update DCS admin:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.16.0.0.0

Update the DCS components:
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.16.0.0.0
```
If the DCS components are updated, then the message "status" : "Success" is displayed on the command line. For failed updates, fix the error and then proceed with the update by re-running the odacli update-dcscomponents command. See the topic Resolving Errors When Updating DCS Components During Patching about more information about DCS components checks errors.

Note:
Note that for DCS Agent update to be complete, both the odacli update-dcscomponents and odacli update-dcsagent commands must be run. Ensure that both commands are run in the order specified.

Update the DCS agent:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.16.0.0.0

Run patching pre-checks. You must run the odacli create-prepatchreport command before you patch your server; otherwise, the odacli update-server command fails with an error message prompting you to run the patching pre-checks.
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v version
```
For example, for 19.16:
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.16.0.0.0
```

Verify that the patching pre-checks ran successfully:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli describe-prepatchreport

For example:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli describe-prepatchreport -i 88d0181a-3db7-4acb-81bd-f11e1bc25ee8

Patch pre-check report                                           
------------------------------------------------------------------------
                 Job ID:  88d0181a-3db7-4acb-81bd-f11e1bc25ee8
            Description:  Patch pre-checks for [OS, GI, ORACHKSERVER, SERVER]
                 Status:  SUCCESS
                Created:  July 17, 2022 11:22:24 AM AZT
                 Result:  All pre-checks succeeded

Node Name       
---------------
node1 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__OS__ 
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is patch location available     Success   Patch location is available.          
Verify OS patch                 Success   Verified OS patch                     
Validate command execution      Success   Validated command execution           

__GI__ 
Validate GI metadata            Success   Successfully validated GI metadata    
Validate supported GI versions  Success   Validated minimum supported versions. 
Validate available space        Success   Validated free space under /u01       
Is clusterware running          Success   Clusterware is running                
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate BM versions            Success   Validated BM server components        
                                          versions                              
Validate kernel log level       Success   Successfully validated the OS log     
                                          level                                 
Validate minimum agent version  Success   GI patching enabled in current        
                                          DCSAGENT version                      
Validate Central Inventory      Success   oraInventory validation passed        
Validate patching locks         Success   Validated patching locks              
Validate clones location exist  Success   Validated clones location             
Evaluate GI patching            Success   Successfully validated GI patching    
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution           

__SERVER__ 
Validate local patching         Success   Successfully validated server local   
                                          patching                              
Validate command execution      Success   Validated command execution           

Node Name       
---------------
node2 

Pre-Check                      Status   Comments                              
------------------------------ -------- -------------------------------------- 
__OS__ 
Validate supported versions     Success   Validated minimum supported versions. 
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is patch location available     Success   Patch location is available.          
Verify OS patch                 Success   Verified OS patch                     
Validate command execution      Success   Validated command execution           

__GI__ 
Validate GI metadata            Success   Successfully validated GI metadata    
Validate supported GI versions  Success   Validated minimum supported versions. 
Validate available space        Success   Validated free space under /u01       
Is clusterware running          Success   Clusterware is running                
Validate patching tag           Success   Validated patching tag: 19.16.0.0.0.  
Is system provisioned           Success   Verified system is provisioned        
Validate BM versions            Success   Validated BM server components        
                                          versions                              
Validate kernel log level       Success   Successfully validated the OS log     
                                          level                                 
Validate minimum agent version  Success   GI patching enabled in current        
                                          DCSAGENT version                      
Validate Central Inventory      Success   oraInventory validation passed        
Validate patching locks         Success   Validated patching locks              
Validate clones location exist  Success   Validated clones location             
Evaluate GI patching            Success   Successfully validated GI patching    
Validate command execution      Success   Validated command execution           

__ORACHK__ 
Running orachk                  Success   Successfully ran Orachk               
Validate command execution      Success   Validated command execution           

__SERVER__ 
Validate local patching         Success   Successfully validated server local   
                                          patching                              
Validate command execution      Success   Validated command execution

Use the command odacli describe-prepatchreport to view details of the pre-patch report. Fix the warnings and errors mentioned in the report and proceed with the server patching.

Apply the server update. Note that you can use the --local option with the odacli update-server command to update the local node.
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-server -v version
```
For example, for 19.16:
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-server -v 19.16.0.0.0
```
You can use the -f option to override precheck failures and complete the server patching.

Confirm that the server update is successful:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID

To patch existing Oracle Database Homes to release 19.16:
1. On the bare metal system, run the command odacli describe-dbsystem-image to check that the repository is updated with the required Oracle Database clone files. If the database clone file is not displayed in the command output, then run the command odacli update-repository on the bare metal system to update the repository with the database clone files:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/DB_software_file
```
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-19.16.0.0.0-date-DB-19.16.0.0.zip
```
2. Run the patching pre-checks and review the prepatch report. You must run the odacli create-prepatchreport command before you patch your Oracle Database homes; otherwise, the odacli update-dbhome command fails with the error message prompting you to run the patching pre-checks.
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid DB_Home_ID -v release_number
[root@dbsystem1 opt]# odacli describe-prepatchreport -i Job_ID
```
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e -v 19.16.0.0.0
[root@dbsystem1 opt]# odacli describe-prepatchreport -i 39ef1eeb-70d3-47ad-b3f5-48960ca0607b
```
3. Check whether the prepatch report contains a warning similar to the following:
```
Rolling patching is not possible: The database patching cannot be completed in a rolling manner because the target patched home at "/u01/app/odaorahome/oracle/product/  12.1.0.2/dbhome_2" contains non-rolling bug fixes "33613829,33808385" compared to the source home at "/u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_1".
```
  Check whether the prepatch report contains any of the following bugs:
```
30432118 (DSTV32-34)
31335037 (DST V35)
32327201 (DST V36 )
33613829 (DST V37)
33808367 (OJVM)
33808385 (OJVM)
```
  If the prepatch report contains only a combination of one or more bug numbers from the above-mentioned list and not any other bug numbers, then ignore the alert message, and continue updating the database home to the latest release either in the rolling or non-rolling mode. Use the odacli update-dbhome command with the --local option to update the database home in the rolling mode:
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid DB_Home_ID -v release_number -l
```
4. If there are no errors, then update the database home to the latest release. You need not use the -f option with the odacli update-dbhome command. Note that you can use the --local option with the odacli update-dbhome command to update the local node.
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid DB_Home_ID -v release_number
```
  For example, for 19.16:
```
[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e -v 19.16.0.0.0
```

Confirm that the patch jobs are successful:

[root@dbsystem1 opt]# /opt/oracle/dcs/bin/odacli list-jobs

About Enabling NUMA on Oracle Database Appliance

odacli modify-vm

odacli remap-cpupools

odacli modify-dbsystem

odacli create-cpupool

odacli describe-dbsystem-image

Parent topic: Patching Oracle Database Appliance

Patching Oracle Database Appliance Bare Metal Systems Using the Browser User Interface

Upload the Oracle Database Appliance Server Patch to the patch repository, deploy the patch bundle using the Browser User Interface, and then update the DCS agent and components using CLI commands.

Updating the Patch Repository Using the Browser User Interface

Download the Oracle Database Appliance patches from My Oracle Support and save them in a directory on the appliance. See the Oracle Database Appliance Release Notes for a list of available patches and links to download the patches.
Log into the Browser User Interface with the oda-admin user name and password.
```
https://Node0–host-ip-address:7093/mgmt/index.html
```
Click Patch Manager.
In the Update Patch Repository page, enter the absolute file path and patch name, then click Update Repository to start the update repository job. You can list more than one file to update to the repository with a comma separated list, without spaces, or you can update each file, one at a time.
Click Activity to monitor the progress. When the job completes successfully, the Patch Repository is updated.

Updating the DCS Admin and DCS Components After Updating the Repository and Before Patching

Before patching your appliance using the Browser User Interface, you must update the DCS admin and DCS components manually, through CLI commands.

Follow these steps:

Update DCS admin:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.16.0.0.0

Confirm that the update is successful:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID

Update the DCS components:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.16.0.0.0
```
If the DCS components are updated, then the message "status" : "Success" is displayed on the command line. For failed updates, fix the error and then proceed with the update.

Note:
You must log into the Browser User Interface again after running the odacli update-dcscomponents command.

Running Patching Prechecks and Patching Agent, Server, and Storage Using the Browser User Interface

Do not have any jobs running or pending during the update window.
Click the Appliance tab, and then click Patch Manager in the Browser User Interface.
Wait for the Component Details to load. If you just updated the Patch Repository, click Refresh in the Component Details section of the page.

After the patch is uploaded to the Patch Repository, the Component Details on the page are updated with the Installed Version and Available Version for each component.
On the Patch Manager page, click Refresh to refresh the Component Details. Select Update Server, then click Apply Patch to begin the job to patch the server components. Select Precheck to run patching prechecks. You must run the patching prechecks before updating the server and other components.

The DCS agent is automatically updated whenever the Server or Storage components are updated.

When the job finishes, go to the next step. Click Activity for job status.
On the Patch Manager page, click Refresh to refresh the Component Details. Select Update Storage, then click Apply Patch to begin the job to patch the storage components. Select Precheck if you want to run patching prechecks.

For high-availability environment, you can select the Rolling check box to perform rolling patching of storage components.
For high-availability systems, when updating the server on the bare metal system, you can select the Node to Update. You can choose the node that you want to update or you can choose to update both nodes.
Click Activity to monitor the progress, and verify that the job completes successfully.

All patching-related information is logged in the dcs-agent log file at /opt/oracle/dcs/log/dcs-agent.log.

Parent topic: Patching Oracle Database Appliance

Patching Oracle Database Appliance DB Systems Using the Browser User Interface

Upload the Oracle Database Appliance Server Patch to the patch repository, deploy the patch bundle using the Browser User Interface, and then update the DCS agent and components using CLI commands.

Updating the Patch Repository Using the Browser User Interface

Download the Oracle Database Appliance patches from My Oracle Support and save them in a directory on the appliance. See the Oracle Database Appliance Release Notes for a list of available patches and links to download the patches.
Log into the Browser User Interface within the bare metal system, with the oda-admin user name and password.
```
https://Node0–host-ip-address:7093/mgmt/index.html
```
Click Patch Manager.
In the Update Patch Repository page, enter the absolute file path and patch name, then click Update Repository to start the update repository job. You can list more than one file to update to the repository with a comma separated list, without spaces, or you can update each file, one at a time.
Click Activity to monitor the progress. When the job completes successfully, the Patch Repository is updated.

Updating the DCS Admin and DCS Components After Updating the Repository and Before Patching

Before patching your DB system using the Browser User Interface, you must update the DCS admin and DCS components manually, through CLI commands.

Follow these steps:

Update DCS admin:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.16.0.0.0

Confirm that the update is successful:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID

Update the DCS components:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.16.0.0.0
```
If the DCS components are updated, then the message "status" : "Success" is displayed on the command line. For failed updates, fix the error and then proceed with the update.

Note:
You must log into the Browser User Interface again after running the odacli update-dcscomponents command.

Running Patching Prechecks and Patching Server Using the Browser User Interface

Do not have any jobs running or pending during the update window.
Log into the Browser User Interface within the DB system with the oda-admin user name and password.
```
https://Node0–host-ip-address:7093/mgmt/index.html
```
Click the Appliance tab, and then click Patch Manager in the Browser User Interface.
Wait for the Component Details to load. If you just updated the Patch Repository, click Refresh in the Component Details section of the page.

After the patch is uploaded to the Patch Repository, the Component Details on the page are updated with the Installed Version and Available Version for each component.
Select Precheck to run patching prechecks.
On the Patch Manager page, click Refresh to refresh the Component Details. Select Update Server, then click Apply Patch to begin the job to patch the server components.

The DCS agent is automatically updated whenever the server components are updated.

When the job finishes, go to the next step. Click Activity for job status.
On the Patch Manager page, click Refresh to refresh the Component Details. Select Precheck if you want to run patching prechecks.
Click Activity to monitor the progress, and verify that the job completes successfully.

Parent topic: Patching Oracle Database Appliance

Updating Oracle Database Appliance Repository with Database Clone Files For Bare Metal Systems

Follow these steps to update the Oracle Database Appliance repository with Oracle Database clone files for the latest release using CLI commands.

To create new databases of a specific release version, you must update the Oracle Database Appliance repository with the Oracle Database clone files for a release. Follow these steps to update the repository with Oracle Database clone files for the latest release.

Download the Oracle Database clone software file for a release, for example, p30403662_1916000_Linux-x86-64.zip, and extract the Oracle Database clone software:
For example, download the Oracle Database clone software patch for 19.16:
```
unzip /tmp/p30403662_1916000_Linux-x86-64.zip
odacli-dcs-19.16.0.0.0-date-DB-19.16.0.0.zip
```
Copy all the software files from the external client to Oracle Database Appliance. For High-Availability deployments, copy the software files to only one node. The software files are copied to the other node during the patching process. Use the scp or sftp protocol to copy the bundle.
Example using scp command:
```
# scp software_file root@oda_host:/tmp
```
Example using sftp command:
```
# sftp root@oda_host
```
Enter the root password, and copy the files.
```
put software_file
```
Update the repository with latest release database software:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-db-clone-file.zip/
```
For example, for 19.16:
```
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli-dcs-19.16.0.0.0-date-DB-19.16.0.0.zip
```
Follow the same steps to update the repository with the database clone software for other supported database versions such as 12.2, 12.1, and so on.

Confirm that the repository update is successful:

[root@oda1 opt]# /opt/oracle/dcs/bin/odacli list-jobs
[root@oda1 opt]# /opt/oracle/dcs/bin/odacli describe-job -i job_ID

Delete the software zip files from the temporary location on the appliance to save space:
```
[root@oda1 opt]# rm software_file
rm: remove regular file software_file? y
```

Parent topic: Patching Oracle Database Appliance

Patching Existing Database Homes on Bare Metal Systems Using the Browser User Interface

Use the Browser User Interface to patch database homes to the latest release on bare metal systems.

Before patching the database home, upload the Oracle Database clone files for the database version, to the repository. See Updating Oracle Database Appliance Repository with Database Clone Files Using the CLI for the procedure to update the repository with the latest Oracle Database clone files.

Log into the Browser User Interface with the oda-admin user name and password.
```
https://Node0–host-ip-address:7093/mgmt/index.html
```
Navigate to the Database Home tab.
Select the database home you want to patch.
Select the Patch Version for the database home.
To patch multiple database homes, select each database home to be patched and the patch version for each database home.
Select the Node to Update. You can choose the node that you want to update or you can choose to update all nodes.
Click Patch. Select Precheck to run pre-checks before patching the database.
Click Activity for job status.
On the Patch page, for the database to be patched, click Actions and select View Pre-patch reports to view the pre-check report. Fix any errors, and then select Action as Apply to patch the database.
Click Ignore Precheck Failures to ignore failures reported in the prechecks reported. It is recommended that you fix errors reported in the precheck results.
Click Ignore Missing Patches to ignore missing patches.
Verify that the patching job completes successfully.

Related Topics

Parent topic: Patching Oracle Database Appliance

Patching Non-Provisioned Oracle Database Appliance Systems

Oracle Database Appliance supports patching of non-provisioned single-node or high availablity systems by running odacli update-server command.

A non-provisioned Oracle Database Appliance system does not have Oracle Grid Infrastructure or Oracle Database installed or running on it. You can upgrade Oracle ILOM and storage firmware on an unprovisioned system without running the odacli create-appliance command by reimaging the system using the bare metal ISO image of Oracle Database release 19.10 or later. Then patch the system with the server patches of the same release as the bare metal ISO image by running the odacli update-server command. When you reimage your system, the DCS infrastructure is updated automatically.

Follow these steps to update the firmware:

Reimage the Oracle Database Appliance using the bare metal ISO image for Oracle Database Appliance release 19.10 or later.
Update the repository with the server patch for the Oracle Database Appliance release you want to patch to, for example 19.10 or later.
For running odacli update-server on Oracle Database Appliance imaged with ISO of release 19.10:
```
odacli update-server -v 19.10.0.0.0 -sko -f
```
For Oracle Database Appliance release 19.10, you can use the -sko option to skip ORAchk failures and proceed with the server patching, and the -f option to override precheck failures and complete the server patching.
For running odacli update-server on Oracle Database Appliance imaged with ISO of release 19.11 or later, follow these steps:
1. Create the pre-patch report for the odacli update-server command by specifying the -s option.
```
odacli create-prepatchreport -v 19.11.0.0.0 -s
```
  Fix the warnings and errors mentioned in the report and proceed with the server patching.
2. Update the server:
```
odacli update-server -v 19.11.0.0.0 -f
```
  For Oracle Database Appliance release 19.11 or later, you can use the -f option to override precheck failures and complete the server patching.

Related Topics

Reimaging an Oracle Database Appliance Baremetal System

Parent topic: Patching Oracle Database Appliance

Applying Additional Patches and Updates on Bare Metal Systems

Configure additional patch repositories and patch your operating system and databases to ensure that your deployment has the latest updates and security fixes.

Enabling Kernel Updates
Oracle Ksplice enables you to update your systems with the latest kernel security and bug fix updates.
Applying Out-of-Cycle Database Patches
The out-of-cycle patching feature enables administrators to patch databases in the Oracle Database Appliance deployment with the latest Oracle Database Release Update, outside of the Oracle Database Appliance releases.

Parent topic: Patching Oracle Database Appliance

Enabling Kernel Updates

Oracle Ksplice enables you to update your systems with the latest kernel security and bug fix updates.

You can download and install the latest Oracle Ksplice updates (uptrack-updates) with either the local ULN repository or ULN channel.

Follow these steps to install Oracle KSplice:

Register your server with Unbreakable Linux Network (ULN). By default, you are registered for the Oracle Linux Latest channel for your operating system and hardware.
Log in to Unbreakable Linux Network:
https://www.oracle.com/in/linux/
Ensure that you have access to the Internet on the server where you want to use Ksplice. For example, if you are using a proxy server, then set the proxy server and port values in the shell with commands similar to the following:
```
# export http_proxy=http://proxy.company.com:port
# export https_proxy=http://proxy.company.com:port
```
Register the server:
```
# uln_register
```
Set up the local repository as described in the Oracle Ksplice user documentation. This enables you to download the latest Ksplice update packages at regular intervals without requiring a direct connection to the Oracle Uptrack server or to ULN.
To update a system to a specific effective kernel version, install the uptrack-updates package for the current kernel.
```
yum -y install uptrack-updates-'uname -r'
```
You can also download the uptrack-updates RPM from the Ksplice channel and install the RPM manually. For example:
```
# rpm -Uvh uptrack-updates-4.14.35-1902.11.3.1.el7uek.x86_64-20200325-0.noarch.rpm
```

Applying Out-of-Cycle Database Patches

The out-of-cycle patching feature enables administrators to patch databases in the Oracle Database Appliance deployment with the latest Oracle Database Release Update, outside of the Oracle Database Appliance releases.

You can apply Oracle Database Release Update (RU) patches manually using OPatch. Refer to the relevant section in this topic to run the OPatch for your database version.

Note:

The OPatch commands and procedures described in this topic are examples, and may need modifications based on a specific Oracle Database Release Update (RU). Always refer to the Readme of the Oracle Database Release Update (RU) for additional commands and steps.

Note:

It is strongly recommended that you patch your deployment through the Oracle Database Appliance releases, whenever possible.

Note:

You can apply out-of-cycle patches to baremetal and DB system deployments using this procedure.

Using OPatchauto to Manually Patch Oracle Database Release 12c and Later

Confirm that the dcs-agent and other components are updated to the latest release.
```
# odacli describe-component
# odacli list-dbhomes
```
Update OPatch to the latest version, if available:
1. Download the latest OPatch version from My Oracle Support.
2. Copy the files to the local host and extract them to the ORACLE_HOME/OPatch directory.
3. Update the OPatch tool as oracle user.
```
/bin/rm -rf $ORACLE_HOME/OPatch/
su - oracle -c /usr/bin/unzip -q -o OPatch_zip_location/p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME
```
Download the latest database patches from My Oracle Support and copy the files to the local host.
```
scp patchfilename root@hostname:directory
```
Unzip patches to an empty directory, for example, /tmp/patchesDir as oracle user.
This creates sub directories under /tmp/patchesDir with bug numbers. If the patch you are applying is a Release Update (RU), then the patch directory has multiple sub-directories.
```
/usr/bin/unzip -o location_of_patches/p29301631_180000_Linux-x86-64.zip -d /tmp/patchesDir
```
For Oracle Database Appliance High-Availability deployments, set up SSH Keys for secure connection.

Analyze the patches.

$ORACLE_HOME/OPatch/opatchauto apply directory_with_patches_extracted -analyze -oh $ORALCE_HOME -log /tmp/opatchAutoAnalyzePatch.log

As root user, apply the patches.

$ORACLE_HOME/OPatch/opatchauto apply directory_to_extract_patches -oh $ORACLE_HOME -inplace

When patching is completed on both nodes, run utlrp.sql and catcon.pl scripts to recompile invalid objects in the database.
Update the registry to ensure that system component values are registered.
```
# odacli update-registry -n dbhome -f
```

Parent topic: Applying Additional Patches and Updates on Bare Metal Systems

Cleaning Up the Patch Repository

Use the Browser User Interface or Command Line Interface to delete obsolete or old patches from the repository.

About Cleaning Up the Patch Repository

After patching Oracle Database Appliance with the latest patches, old unused clone files may remain and consume space in the repository. Cleanup repository deletes the unused clone/patch files to reclaim space. You can clean up the repository using the Browser User Interface or ODACLI commands.

Cleaning Up the Patch Repository Using ODACLI command

# odacli cleanup-patchrepo [-cl clones] | [-v version [-comp component]]| [-l local|-n NodeID]

Specify the clone file names and the node from which you want to delete the old patches.

For details about the command options, see the chapter Oracle Database Appliance Command-Line Interface.

Cleaning Up the Patch Repository Using the Browser User Interface

Follow these steps to clean up the patch repository:

In the Browser User Interface, click Patch Manager.
Click the Cleanup Repository tab, and then click Refresh to list the available patches in the repository.
Select the Components, such as old Oracle Grid Infrastructure or Oracle Database clone files that you want to clean up from the repository, and the Patch Version, for example, an older release of Oracle Database Appliance.
Click Cleanup Clone Files to clean up clone files for selected components from the repository at /opt/oracle/oak/pkgrepos/orapkgs/clones/.
Click Cleanup Repository to submit the cleanup repository job.
Click Activity to monitor the progress. When the job completes successfully, the Patch Repository is updated.

Related Topics

odacli cleanup-patchrepo

Parent topic: Patching Oracle Database Appliance

About Upgrading to a Different Database Home

Understand how to upgrade to a different database home using either the Browser User Interface or odacli commands.

Prerequisites for Upgrading Database Homes

You can upgrade database homes of the following releases:

Oracle Database 12.2 to 19c
Oracle Database 12.1 to 19c
Oracle Database 12.1 to 12.2

Before upgrading to a different database home, upload the Oracle Database clone files for the database version, to the repository, and then create the database home. See Patching Oracle Database Appliance Using the CLI for the procedure to update the repository with the latest Oracle Database clone files.

About Upgrading Database Homes Using the Browser User Interface

Follow these steps to upgrade to a different database home using the Browser User Interface.

Log into the Browser User Interface with the oda-admin user name and password.
```
https://Node0–host-ip-address:7093/mgmt/index.html
```
Click the Database tab, and then select a database, click Actions, and then click Upgrade.
Verify that the database upgrade job completes successfully.

About Upgrading Database Homes Using the Command-Line Interface

Run the following command to upgrade to a different database home using the CLI:

odacli upgrade-database -i Comma separated list of database ids -from source dbhome id -to destination dbhome id [-j] [-h]

For more information about the options for the upgrade-database command, see the chapter Oracle Database Appliance Command-Line Interface.

Related Topics

odacli upgrade-database

Parent topic: Patching Oracle Database Appliance

Setting Dynamic Default Parameters

You can set dynamic default parameters using the BUI.

Setting Dynamic Default Parameters Using the Browser User Interface

Follow these steps:

From the Appliance page, click Parameter Repository.
The Parameter Repository page lists all the parameters in the repository. Currently, parameters of type RDBMS are supported.
Select Update Parameter to create a new configuration property.
In the Update Parameter page, specify the Parameter Name and Value, and provide an optional Description. Specify whether you want to create the parameter for the Bare Metal or DB System. You can also specify the whether the parameter applies to All DB Systems or you can select the DB system for which you want to create the parameter.
Click OK.
Confirm the action to submit the job. Monitor the job progress and check that it completes successfully.
To update a parameter, select the Update option from the Actions menu.
You can edit the Value, Description, and select whether the parameter applies to Bare Metal or DB System. You can also select the DB system for which you want to update the parameter or choose to apply the parameter to All DB Systems.
Click Update.
To delete a parameter, select the Delete option from the Actions menu. You can delete the parameter from the Bare Metal or DB System. You can also select the DB system for which you want to delete the parameter or choose to delete the parameter from All DB Systems.
Click Delete.

Parent topic: Patching Oracle Database Appliance