Sunday 18 March 2018

Patching Oracle Database Appliance (ODA) Stack


Oracle Database Appliance stack patching is very simple and straight forward. The ODA patching process is fully automated and single patch contains updates for all system components such as OS, Firmware, BIOS, ILOM, Storage, Grid Infrastructure and Database. ODA patches are released every quarter and one should always consult the MOS note 888888.1 for recommended patches.

Oracle Database Appliance stack Patching consists of following major steps:

  1. Patching ODA Nodes (Includes Grid Infrastructure Patching)
  2. Patching Storage Shelve(s)
  3. Patching Database


In this article we will demonstrate the steps for patching entire Oracle Database Appliance stack to 12.2.1.2.0.

Steps for Patching Oracle Database Appliance (ODA) Stack




Step 1: ODA Nodes Patching

  • As root user, note down the current version of the ODA on both nodes
# oakcli show version -detail
  • As root user, Verify the shared disks status on both nodes. There shouldn't be any bad disk.

# oakcli show disk
# oakcli show diskgroup

  • As root user, Validate the ODA infrastructure on both nodes
# oakcli validate -d
  • Ensure that sufficient space is available in the following file sytems on both nodes
# df -h -P / /opt /u01 /boot
  • Download and stage the ODA patches on the both nodes
# mkdir -p /u01/app/oracle/software/ODA
  • Ensure root user equivalence is working on both nodes

From node 1
ssh 192.168.16.25 hostname
 


From node 2
ssh 192.168.16.24 hostname
 

  • Copy software to node 2
# mkdir -p /u01/app/oracle/software/ODA
# scp /u01/app/oracle/software/ODA/p* 192.168.16.25:/u01/app/oracle/software/ODA/
  • Unpack software on both nodes

# /opt/oracle/oak/bin/oakcli unpack –package /u01/app/oracle/software/ODA/p27119652_122120_Linux-x86-64_1of3.zip
# /opt/oracle/oak/bin/oakcli unpack –package /u01/app/oracle/software/ODA/p27119652_122120_Linux-x86-64_2of3.zip
# /opt/oracle/oak/bin/oakcli unpack –package /u01/app/oracle/software/ODA/p27119652_122120_Linux-x86-64_3of3.zip

  • Stop databases
$ srvctl stop database -d <name>
  • Umount the NFS mounts if any
# umount /nsf
  • Verify the patch
# oakcli update -patch 12.2.1.2.0 -verify
  • Run from the patching from ILOM CLI

ssh odanode1-ilom
enter the root password when prompted
-> start /SP/console
enter y and hit return to confirm
# oakcli update -patch 12.2.1.2.0 -server -local 

Note: Node will be rebooted as part of patching

  • Ensure that CRS is Up and Running
# $GRID_HOME/bin/crsctl stat res -t
  • Perform patching post checks
# oakcli update -patch 12.2.1.2.0 -verify
  • Check the inventory looks as expected:
# oakcli show version -detail
  • Check GI patches

$ $GRID_HOME/OPatch/opatch lspatches


*****Repeat the above steps on the second node before continuing...*******




Step 2: Storage patching



Once both ODA nodes are patched successfully, we can continue with the storage patching. 
 

  • As root user on node 1 only, execute the following command:
# oakcli update -patch 12.2.1.2.0 -storage
  • Post Storage Patching, ensure that CRS is up and running on both nodes
# $GRID_HOME/bin/crsctl stat res -t
  • Verify that the patching sucessful on both nodes.
# oakcli show version -detail



Step 3: Database Patching:



Once both ODA nodes and Storage Patching completed successfully, we can now patch databases.
 

  • As root user on execute the following command:
# /opt/oracle/oak/bin/oakcli update -patch  12.2.1.2.0  --database --local
  • Verify the versions of the databsae homes

# oakcli show databases -detail 
# oakcli show dbhomes -detail


Conclusion
 

In this article we have learned to patch an Oracle Database Appliance. Oracle Database Appliance stack patching is very simple and straight forward. The ODA patching process is fully automated and single patch contains updates for all system components. The Patching is also known as One-Button patching process as it is fully automated with just few steps.



No comments:

Post a Comment

Comparing Oracle Database Appliance X8-2 Model Family

September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources com...