The Oracle Database Appliance: Update & Patching


Patching or Updating an Oracle Database Appliance is normally an easy thing. The whole update procedure will be done in 4 steps.

  1. Unpacking patch to repository
  2. Patching Infrastructure (–infra)
    • Firmwares
    • ILOM
    • BIOS
    • Disks
  3. Patching Grid Infrastructure (–gi)
    • Oracle Grid Infrastructure
  4. Patching Databasehome and Databases (–database)
    • Database Homes and Databases

1. Check current version

[root@oak1 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version        
--------------  ---------------           ------------------        -----------------        
2.6.0.0.0                                                                                    
                Controller                11.05.02.00               Up-to-date               
                Expander                  0342                      Up-to-date               
                SSD_SHARED                E12B                      Up-to-date               
                HDD_LOCAL                 SA03                      Up-to-date               
                HDD_SHARED                A700                      Up-to-date               
                ILOM                      3.0.16.22.b r78329        Up-to-date               
                BIOS                      12010310                  Up-to-date               
                IPMI                      1.8.10.5                  Up-to-date               
                HMP                       2.2.6.1                   Up-to-date               
                OAK                       2.6.0.0.0                 Up-to-date               
                OEL                       5.8                       Up-to-date               
                TFA                       2.5.1.4                   Up-to-date               
                GI_HOME                   11.2.0.3.6(16056266,      Up-to-date               
                                          16083653)                                          
                DB_HOME                   11.2.0.3.6(16056266,      Up-to-date               
                                          16083653)                                          
                ASR                       4.4                       Up-to-date

2. Copy software, unpack and deploy to repository with oakcli

[root@oak1 ~]# oakcli unpack -package p16760967_27000_Linux-x86-64.zip
Unpacking takes a while, pls wait....
Successfully unpacked the files to repository.

[root@oak2 ~]# oakcli unpack -package p16760967_27000_Linux-x86-64.zip
Unpacking takes a while, pls wait....
Successfully unpacked the files to repository.

3. Verify components to update

[root@oak1 ~]# oakcli update -patch 2.7.0.0.0 --verify
Component Name            Installed Version         Proposed Patch Version   
---------------           ------------------        -----------------        
Controller                11.05.02.00               Up-to-date               
Expander                  0342                      Up-to-date               
SSD_SHARED                E12B                      Up-to-date               
HDD_LOCAL                 SA03                      Up-to-date               
HDD_SHARED {                                                                 
[ c2d0,c2d2,c2d3,c2d      A700                      Up-to-date               
4,c2d5,c2d6,c2d7,c2d                                                         
8,c2d9,c2d10,c2d11,c                                                         
2d12,c2d13,c2d14,c2d                                                         
15,c2d16,c2d17,c2d18                                                         
,c2d19 ]                                                                     
[ c2d1 ]                  0B25                      Up-to-date               
             }                                                               
ILOM                      3.0.16.22.b r78329        3.0.16.22.c r80379       
BIOS                      12010310                  12010311                 
IPMI                      1.8.10.5                  Up-to-date               
HMP                       2.2.6.1                   2.2.6.2                  
OAK                       2.6.0.0.0                 2.7.0.0.0                
OEL                       5.8                       5.9                      
TFA                       2.5.1.4                   2.5.1.5                  
GI_HOME                   11.2.0.3.6(16056266,      11.2.0.3.7(16619892,     
                          16083653)                 16742216)                
DB_HOME                   11.2.0.3.6(16056266,      11.2.0.3.7(16619892,     
                          16083653)                 16742216)

4. Patch Infrastructure

[root@oak1 ~]# oakcli update -patch 2.7.0.0.0 --infra
INFO: DB, ASM, Clusterware may be stopped during the patch if required
INFO: Both nodes may get rebooted automatically during the patch if required
Do you want to continue: [Y/N]?: y
INFO: User has confirmed the reboot
INFO: Patch bundle must be unpacked on the second node also before applying this patch
Did you unpack the patch bundle on the second node?: [Y/N]?: y

Please enter the 'root' user password: 
Please re-enter the 'root' user password: 
INFO: Setting up the SSH..........done
INFO: Running pre-install scripts..........done
INFO: 2013-08-16 16:44:21: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-16 16:44:37: Completed pre patch script for 2.7.0.0.0

INFO: 2013-08-16 16:44:51: ------------------Patching HMP-------------------------
SUCCESS: 2013-08-16 16:45:33: Successfully upgraded the HMP

INFO: 2013-08-16 16:45:34: ----------------------Patching OAK---------------------
SUCCESS: 2013-08-16 16:46:09: Succesfully upgraded OAK 

INFO: 2013-08-16 16:46:13: -----------------Installing / Patching  TFA-----------------
SUCCESS: 2013-08-16 16:48:12: Successfully updated / installed the TFA
...

INFO: 2013-08-16 16:48:13: ------------------Patching OS-------------------------
INFO: 2013-08-16 16:48:28: Clusterware is running on one or more nodes of the cluster
INFO: 2013-08-16 16:48:28: Attempting to stop clusterware and its resources across the cluster
SUCCESS: 2013-08-16 16:50:58: Successfully stopped the clusterware

ERROR: 2013-08-16 16:51:04: Failed to run /usr/bin/yum update --disablerepo=* --enablerepo=ODA_REPOS_LOC -y 
ERROR: 2013-08-16 16:51:05: Failed to update the OS

## Note: Leaving /var/opt/SUNWsasm/configuration directory in place
## to maintain settings on package upgrade.
## For a complete uninstall, manually remove this directory.

INFO: 2013-08-16 16:51:26: ----------------------Patching ASR---------------------
SUCCESS: 2013-08-16 16:51:56: Succesfully upgraded ASR 

INFO: 2013-08-16 16:51:57: ----------------------Patching IPMI---------------------
INFO: 2013-08-16 16:51:57: IPMI is already upgraded or running with latest version 

INFO: 2013-08-16 16:52:05: ----------------Patching the Storage-------------------
INFO: 2013-08-16 16:52:05: ....................Patching SSDs...............
INFO: 2013-08-16 16:52:05: Disk : d20  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-16 16:52:06: Disk : d21  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-16 16:52:06: Disk : d22  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-16 16:52:06: Disk : d23  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-16 16:52:06: ....................Patching shared HDDs...............
INFO: 2013-08-16 16:52:06: Disk : d0  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:06: Disk : d1  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:06: Disk : d2  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:06: Disk : d3  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d4  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d5  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d6  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d7  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d8  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d9  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:07: Disk : d10  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d11  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d12  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d13  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d14  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d15  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d16  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:08: Disk : d17  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:09: Disk : d18  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:09: Disk : d19  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-16 16:52:09: ....................Patching local HDDs...............
INFO: 2013-08-16 16:52:09: Disk : c0d0  is already running with : ST95001N SA03
INFO: 2013-08-16 16:52:09: Disk : c0d1  is already running with : ST95001N SA03
INFO: 2013-08-16 16:52:09: ....................Patching Expanders...............
INFO: 2013-08-16 16:52:09: Expander : x0  is already running with : T4 Storage 0342
INFO: 2013-08-16 16:52:09: Expander : x1  is already running with : T4 Storage 0342
INFO: 2013-08-16 16:52:10: ....................Patching Controllers...............
INFO: 2013-08-16 16:52:10: No-update for the Controller: c0 
INFO: 2013-08-16 16:52:10: Controller : c1  is already running with : 0x0072 11.05.02.00
INFO: 2013-08-16 16:52:10: Controller : c2  is already running with : 0x0072 11.05.02.00
INFO: 2013-08-16 16:52:10: ------------Finished the storage Patching------------

INFO: 2013-08-16 16:52:11: -----------------Patching Ilom & Bios-----------------
INFO: 2013-08-16 16:52:11: Getting the ILOM Ip address
INFO: 2013-08-16 16:52:11: Updating the Ilom using LAN+ protocol
INFO: 2013-08-16 16:52:13: Updating the ILOM. It takes a while
INFO: 2013-08-16 16:56:42: Verifying the updated Ilom Version, it may take a while if ServiceProcessor is booting
INFO: 2013-08-16 16:56:43: Waiting for the service processor to be up

SUCCESS: 2013-08-16 17:00:22: Successfully updated the ILOM with the firmware 3.0.16.22.c r80379

INFO: Patching the infrastructure on node: oak2 , it may take upto 30 minutes. Please wait...............done
INFO: Infrastructure patching summary on node: 192.168.16.24
SUCCESS: 2013-08-16 17:17:45:  Successfully upgraded the HMP
SUCCESS: 2013-08-16 17:17:45:  Succesfully updated the OAK
SUCCESS: 2013-08-16 17:17:45:  Successfully updated the TFA
SUCCESS: 2013-08-16 17:17:45:  Successfully upgraded the OS
SUCCESS: 2013-08-16 17:17:45:  Succesfully updated the ASR
INFO: 2013-08-16 17:17:45:  IPMI is already upgraded
INFO: 2013-08-16 17:17:45:  Storage patching summary
SUCCESS: 2013-08-16 17:17:45:  No failures during storage upgrade
SUCCESS: 2013-08-16 17:17:45:  Successfully updated the ILOM & Bios
INFO: Infrastructure patching summary on node: 192.168.16.25
SUCCESS: 2013-08-16 17:17:45:  Successfully upgraded the HMP
SUCCESS: 2013-08-16 17:17:45:  Succesfully updated the OAK
SUCCESS: 2013-08-16 17:17:45:  Successfully upgraded the OS
INFO: 2013-08-16 17:17:45:  IPMI is already upgraded
INFO: 2013-08-16 17:17:45:  Storage patching summary
SUCCESS: 2013-08-16 17:17:45:  No failures during storage upgrade
SUCCESS: 2013-08-16 17:17:45:  Successfully updated the ILOM & Bios
INFO: Running post-install scripts............done
INFO: Some of the patched components require node reboot. Rebooting the nodes
INFO: Setting up the SSH............done

NOTICE: You can use the –noreboot switch to avoid rebooting at the end. Sometimes both Nodes will be rebooted at the same time. So you have the chance to do node by node reboot

5. Patching of Grid Infrastructure

[root@oak1 ~]# oakcli update -patch 2.7.0.0.0 --gi

Please enter the 'root' user password: 
Please re-enter the 'root' user password: 

Please enter the 'grid' user password: 
Please re-enter the 'grid' user password: 
Given passwords are not matching
Please re-enter the passwords

Please enter the 'grid' user password: 
Please re-enter the 'grid' user password: 
INFO: Setting up the SSH
..........done
INFO: Running pre-install scripts
..........done
INFO: 2013-08-16 18:06:41: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-16 18:06:44: Completed pre patch script for 2.7.0.0.0
...
...
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-08-16 18:07:12: Setting up the ssh for grid user
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-08-16 18:07:32: Patching the GI home on node oak1
INFO: 2013-08-16 18:07:32: Updating the opatch
INFO: 2013-08-16 18:08:31: Performing the conflict checks
SUCCESS: 2013-08-16 18:08:46: Conflict checks passed for all the homes
INFO: 2013-08-16 18:08:46: Checking if the patch is already applied on any of the homes
INFO: 2013-08-16 18:08:49: No home is already up-to-date
SUCCESS: 2013-08-16 18:09:25: Successfully stopped the dbconsoles
SUCCESS: 2013-08-16 18:09:40: Successfully stopped the EM agents
INFO: 2013-08-16 18:09:45: Applying patch on the homes: /u01/app/11.2.0.3/grid
INFO: 2013-08-16 18:09:45: It may take upto 15 mins
SUCCESS: 2013-08-16 18:21:54: Successfully applied the patch on home: /u01/app/11.2.0.3/grid
SUCCESS: 2013-08-16 18:22:08: Successfully started the dbconsoles
SUCCESS: 2013-08-16 18:22:24: Successfully started the EM Agents
INFO: 2013-08-16 18:22:24: Patching the GI home on node oak2
...
..........done
INFO: GI patching summary on node: oak1
SUCCESS: 2013-08-16 18:35:03:  Successfully applied the patch on home /u01/app/11.2.0.3/grid
INFO: GI patching summary on node: oak2
SUCCESS: 2013-08-16 18:45:28:  Successfully applied the patch on home /u01/app/11.2.0.3/grid
INFO: Running post-install scripts
..........done
INFO: Setting up the SSH
..........done

Notice: Patching GI will be done node by node

6. Patching database homes and databases

[root@oak1 ~]# oakcli update -patch 2.7.0.0.0 --database

Please enter the 'root' user password: 
Please re-enter the 'root' user password: 

Please enter the 'oracle' user password: 
Please re-enter the 'oracle' user password: 
INFO: Setting up the SSH
..........done
INFO: Running pre-install scripts
..........done
INFO: 2013-08-16 18:59:18: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-16 18:59:21: Completed pre patch script for 2.7.0.0.0
...
...
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-08-16 18:59:47: Getting the possible database homes for patching
...
INFO: 2013-08-16 18:59:53: Patching 11.2.0.3 Database homes on node oak1

Found the following 11.2.0.3 homes possible for patching:

HOME_NAME                      HOME_LOCATION                                          
---------                      -------------                                          
OraDb11203_home1               /u01/app/oracle/product/11.2.0.3/dbhome_1              

[Please note that few of the above database homes may be already up-to-date. They will be automatically ignored]

Would you like to patch all the above homes: Y | N ? :y
INFO: 2013-08-16 18:59:55: Setting up ssh for the user oracle
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-08-16 19:00:15: Updating the opatch
INFO: 2013-08-16 19:01:56: Performing the conflict checks
SUCCESS: 2013-08-16 19:02:12: Conflict checks passed for all the homes
INFO: 2013-08-16 19:02:12: Checking if the patch is already applied on any of the homes
INFO: 2013-08-16 19:02:16: No home is already up-to-date
SUCCESS: 2013-08-16 19:02:48: Successfully stopped the dbconsoles
SUCCESS: 2013-08-16 19:03:03: Successfully stopped the EM agents
INFO: 2013-08-16 19:03:08: Applying patch on the homes: /u01/app/oracle/product/11.2.0.3/dbhome_1
INFO: 2013-08-16 19:03:08: It may take upto 15 mins
SUCCESS: 2013-08-16 19:09:07: Successfully applied the patch on home: /u01/app/oracle/product/11.2.0.3/dbhome_1
SUCCESS: 2013-08-16 19:09:23: Successfully started the dbconsoles
SUCCESS: 2013-08-16 19:09:40: Successfully started the EM Agents
INFO: 2013-08-16 19:09:43: Patching 11.2.0.3 Database homes on node oak2
INFO: 2013-08-16 19:14:10: Running the catbundle.sql
INFO: 2013-08-16 19:14:12: Running catbundle.sql on the database testdb1
INFO: 2013-08-16 19:14:24: Running catbundle.sql on the database testdb2
..........done

INFO: DB patching summary on node: oak1
SUCCESS: 2013-08-16 19:15:14:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

INFO: DB patching summary on node: oak2
SUCCESS: 2013-08-16 19:15:14:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

INFO: Setting up the SSH
..........done
Notice: Patching GI will be done node by node

7. Verfiy update

[root@oak1 ~]# oakcli update -patch 2.7.0.0.0 --verify
                Component Name            Installed Version         Proposed Patch Version   
                ---------------           ------------------        -----------------        
                Controller                11.05.02.00               Up-to-date               
                Expander                  0342                      Up-to-date               
                SSD_SHARED                E12B                      Up-to-date               
                HDD_LOCAL                 SA03                      Up-to-date               
                HDD_SHARED                A700                      Up-to-date               
                ILOM                      3.0.16.22.c r80379        Up-to-date               
                BIOS                      12010311                  Up-to-date               
                IPMI                      1.8.10.5                  Up-to-date               
                HMP                       2.2.6.2                   Up-to-date               
                OAK                       2.7.0.0.0                 Up-to-date               
                OEL                       5.9                       Up-to-date               
                TFA                       2.5.1.5                   Up-to-date               
                GI_HOME                   11.2.0.3.7(16619892,      Up-to-date               
                                          16742216)                                          
                DB_HOME                   11.2.0.3.7(16619892,      Up-to-date               
                                          16742216)

One thought on “The Oracle Database Appliance: Update & Patching

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s