Oracle Database Appliance Patch 2.6


oda_x3

Oracle has early may ODA version 2.6 released for the Oracle Database Appliance. The Patch is for the V1 and V2 ODA Systems.

What has happened in the 2.6 patch.

  • The database / grid infrastructure is now version 11.2.0.3.6 / 11.2.0.2.10
  • A new offline configurator 2.6 avaible on OTN here
  • A disk firmware update is included

Facts:
After patching the ODA component versions are as follows (note changed version to 2.5 are marked bold):

[root@oda1 bin]# 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

installation sample ODA V1:

This is only a sample, please follow the readme from Oracle for the exact steps. Stop all management agents (like 12C Agents) and unpack the Image file of the ODA on both nodes.

[root@oda1 u01]# oakcli unpack -package /u01/tmp/p16744915_26000_Linux-x86-64_patch.zip 
Unpacking takes a while,  pls wait....
Successfully unpacked the files to repository.
[root@oda2 ~]# oakcli unpack -package /u01/tmp/p16744915_26000_Linux-x86-64_patch.zip
Unpacking takes a while,  pls wait....
Successfully unpacked the files to repository.

Upgrade INFRA

[root@oda1 bin]# cd /opt/oracle/oak/bin
[root@oda1 bin]# ./oakcli update -patch 2.6.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-05-07 01:06:58: Running pre patch script for 2.6.0.0.0
INFO: 2013-05-07 01:07:03: Completed pre patch script for 2.6.0.0.0

INFO: 2013-05-07 01:07:08: ------------------Patching HMP-------------------------
SUCCESS: 2013-05-07 01:07:45: Successfully upgraded the HMP

INFO: 2013-05-07 01:07:46: ----------------------Patching OAK---------------------
SUCCESS: 2013-05-07 01:08:18: Succesfully upgraded OAK 

INFO: 2013-05-07 01:08:22: -----------------Installing / Patching  TFA-----------------
SUCCESS: 2013-05-07 01:10:22: Successfully updated / installed the TFA
...

INFO: 2013-05-07 01:10:23: ------------------Patching OS-------------------------
INFO: 2013-05-07 01:10:34: OS is already updated
## 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-05-07 01:10:51: ----------------------Patching ASR---------------------
SUCCESS: 2013-05-07 01:11:16: Succesfully upgraded ASR 

INFO: 2013-05-07 01:11:17: ----------------------Patching IPMI---------------------
INFO: 2013-05-07 01:11:17: IPMI is already upgraded or running with latest version 

INFO: 2013-05-07 01:11:25: ----------------Patching the Storage-------------------
INFO: 2013-05-07 01:11:25: ....................Patching SSDs...............
INFO: 2013-05-07 01:11:25: Disk : d20  is already running with : ZeusIOPs G3 E12B
INFO: 2013-05-07 01:11:26: Disk : d21  is already running with : ZeusIOPs G3 E12B
INFO: 2013-05-07 01:11:26: Disk : d22  is already running with : ZeusIOPs G3 E12B
INFO: 2013-05-07 01:11:26: Disk : d23  is already running with : ZeusIOPs G3 E12B
INFO: 2013-05-07 01:11:26: ....................Patching shared HDDs...............
INFO: 2013-05-07 01:11:26: Updating the  Disk : d0 with the firmware : HUS1560SCSUN600G A700
INFO: 2013-05-07 01:11:26: Clusterware is running on one or more nodes of the cluster
INFO: 2013-05-07 01:11:26: Attempting to stop clusterware and its resources across the cluster
SUCCESS: 2013-05-07 01:13:27: Successfully stopped the clusterware
SUCCESS: 2013-05-07 01:14:02: Successfully updated the firmware on  Disk : d0 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:14:02: Updating the  Disk : d1 with the firmware : HUS1560SCSUN600G A700
UCCESS: 2013-05-07 01:14:33: Successfully updated the firmware on  Disk : d1 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:14:33: Updating the  Disk : d2 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:15:04: Successfully updated the firmware on  Disk : d2 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:15:04: Updating the  Disk : d3 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:15:34: Successfully updated the firmware on  Disk : d3 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:15:34: Updating the  Disk : d4 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:16:02: Successfully updated the firmware on  Disk : d4 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:16:02: Updating the  Disk : d5 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:16:35: Successfully updated the firmware on  Disk : d5 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:16:35: Updating the  Disk : d6 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:17:07: Successfully updated the firmware on  Disk : d6 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:17:08: Updating the  Disk : d7 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:17:35: Successfully updated the firmware on  Disk : d7 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:17:35: Updating the  Disk : d8 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:18:05: Successfully updated the firmware on  Disk : d8 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:18:05: Updating the  Disk : d9 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:18:35: Successfully updated the firmware on  Disk : d9 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:18:36: Updating the  Disk : d10 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:19:04: Successfully updated the firmware on  Disk : d10 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:19:04: Updating the  Disk : d11 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:19:33: Successfully updated the firmware on  Disk : d11 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:19:33: Updating the  Disk : d12 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:20:03: Successfully updated the firmware on  Disk : d12 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:20:04: Updating the  Disk : d13 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:20:31: Successfully updated the firmware on  Disk : d13 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:20:31: Updating the  Disk : d14 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:21:00: Successfully updated the firmware on  Disk : d14 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:21:00: Updating the  Disk : d15 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:21:29: Successfully updated the firmware on  Disk : d15 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:21:30: Updating the  Disk : d16 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:22:02: Successfully updated the firmware on  Disk : d16 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:22:02: Updating the  Disk : d17 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:22:32: Successfully updated the firmware on  Disk : d17 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:22:32: Updating the  Disk : d18 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:23:01: Successfully updated the firmware on  Disk : d18 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:23:01: Updating the  Disk : d19 with the firmware : HUS1560SCSUN600G A700
SUCCESS: 2013-05-07 01:23:29: Successfully updated the firmware on  Disk : d19 to HUS1560SCSUN600G A700
INFO: 2013-05-07 01:23:29: ....................Patching local HDDs...............
INFO: 2013-05-07 01:23:29: Disk : c0d0  is already running with : ST95001N SA03
INFO: 2013-05-07 01:23:29: Disk : c0d1  is already running with : ST95001N SA03
INFO: 2013-05-07 01:23:29: ....................Patching Expanders...............
INFO: 2013-05-07 01:23:29: Expander : x0  is already running with : T4 Storage 0342
INFO: 2013-05-07 01:23:30: Expander : x1  is already running with : T4 Storage 0342
INFO: 2013-05-07 01:23:30: ....................Patching Controllers...............
INFO: 2013-05-07 01:23:30: No-update for the Controller: c0 
INFO: 2013-05-07 01:23:30: Controller : c1  is already running with : 0x0072 11.05.02.00
INFO: 2013-05-07 01:23:30: Controller : c2  is already running with : 0x0072 11.05.02.00
INFO: 2013-05-07 01:23:30: ------------Finished the storage Patching------------

INFO: 2013-05-07 01:23:32: -----------------Patching Ilom & Bios-----------------
INFO: 2013-05-07 01:23:32: Getting the ILOM Ip address
INFO: 2013-05-07 01:23:33: Updating the Ilom using LAN+ protocol
INFO: 2013-05-07 01:23:34: Updating the ILOM. It takes a while
INFO: 2013-05-07 01:28:10: Verifying the updated Ilom Version, it may take a while if ServiceProcessor is booting
INFO: 2013-05-07 01:28:11: Waiting for the service processor to be up
SUCCESS: 2013-05-07 01:32:06: Successfully updated the ILOM with the firmware 3.0.16.22.b r78329

INFO: Patching the infrastructure on node: oda2 , it may take upto 30 minutes. Please wait
..................done

INFO: Infrastructure patching summary on node: 192.168.16.24
SUCCESS: 2013-05-07 01:43:18:  Successfully upgraded the HMP
SUCCESS: 2013-05-07 01:43:18:  Succesfully updated the OAK
SUCCESS: 2013-05-07 01:43:18:  Successfully updated the TFA
INFO: 2013-05-07 01:43:18:  OS is already updated
SUCCESS: 2013-05-07 01:43:18:  Succesfully updated the ASR
INFO: 2013-05-07 01:43:18:  IPMI is already upgraded
INFO: 2013-05-07 01:43:18:  Storage patching summary
SUCCESS: 2013-05-07 01:43:18:  No failures during storage upgrade
SUCCESS: 2013-05-07 01:43:18:  Successfully updated the ILOM & Bios

INFO: Infrastructure patching summary on node: XXX.XXX.XXX.XXX
SUCCESS: 2013-05-07 01:43:18:  Successfully upgraded the HMP
SUCCESS: 2013-05-07 01:43:18:  Succesfully updated the OAK
INFO: 2013-05-07 01:43:18:  OS is already updated
INFO: 2013-05-07 01:43:18:  IPMI is already upgraded
INFO: 2013-05-07 01:43:18:  Storage patching summary
SUCCESS: 2013-05-07 01:43:18:  No failures during storage upgrade
SUCCESS: 2013-05-07 01:43:18:  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
Broadcast message from root (Tue May  7 01:51:31 2013):

The system is going down for system halt NOW!

Upgrade of Grid Infrastructure

root@oda1 scripts]# cd /opt/oracle/oak/bin/
[root@oda1 bin]# oakcli update -patch 2.6.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: 
INFO: Setting up the SSH
..........done
................done
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-05-07 20:07:03: Setting up the ssh for grid user
..........done
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-05-07 20:07:23: Patching the GI home on node oda1
INFO: 2013-05-07 20:07:23: Updating the opatch
INFO: 2013-05-07 20:07:59: Performing the conflict checks
SUCCESS: 2013-05-07 20:08:11: Conflict checks passed for all the homes
INFO: 2013-05-07 20:08:11: Checking if the patch is already applied on any of the homes
INFO: 2013-05-07 20:08:15: No home is already up-to-date
SUCCESS: 2013-05-07 20:10:26: Successfully stopped the dbconsoles
SUCCESS: 2013-05-07 20:10:32: Successfully stopped the EM agents
INFO: 2013-05-07 20:10:38: Applying patch on the homes: /u01/app/11.2.0.3/grid
INFO: 2013-05-07 20:10:38: It may take upto 15 mins
SUCCESS: 2013-05-07 20:21:37: Successfully applied the patch on home: /u01/app/11.2.0.3/grid
SUCCESS: 2013-05-07 20:21:40: Successfully started the dbconsoles
SUCCESS: 2013-05-07 20:21:40: Successfully started the EM Agents
INFO: 2013-05-07 20:21:41: Patching the GI home on node oda2
.............done

INFO: GI patching summary on node: oda1
SUCCESS: 2013-05-07 20:35:50:  Successfully applied the patch on home /u01/app/11.2.0.3/grid

INFO: GI patching summary on node: oda2
SUCCESS: 2013-05-07 20:35:50:  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

Upgrade the Database Software

[root@oda1 bin]# oakcli update -patch 2.6.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
...
...

..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-05-07 20:41:00: Getting the possible database homes for patching
...
INFO: 2013-05-07 20:41:05: Patching 11.2.0.3 Database homes on node oda1

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-05-07 20:42:01: Setting up ssh for the user oracle
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2013-05-07 20:42:21: Updating the opatch
INFO: 2013-05-07 20:42:57: Performing the conflict checks
SUCCESS: 2013-05-07 20:43:09: Conflict checks passed for all the homes
INFO: 2013-05-07 20:43:09: Checking if the patch is already applied on any of the homes
INFO: 2013-05-07 20:43:13: No home is already up-to-date
SUCCESS: 2013-05-07 20:43:15: Successfully stopped the dbconsoles
SUCCESS: 2013-05-07 20:43:22: Successfully stopped the EM agents
INFO: 2013-05-07 20:43:27: Applying patch on the homes: /u01/app/oracle/product/11.2.0.3/dbhome_1
INFO: 2013-05-07 20:43:27: It may take upto 15 mins
SUCCESS: 2013-05-07 20:46:36: Successfully applied the patch on home: /u01/app/oracle/product/11.2.0.3/dbhome_1
SUCCESS: 2013-05-07 20:46:36: Successfully started the dbconsoles
SUCCESS: 2013-05-07 20:46:36: Successfully started the EM Agents
INFO: 2013-05-07 20:46:37: Patching 11.2.0.3 Database homes on node oda2
INFO: 2013-05-07 20:50:48: Running the catbundle.sql
INFO: 2013-05-07 20:50:55: Running catbundle.sql on the database ORCL

..........done

INFO: DB patching summary on node: oda1
SUCCESS: 2013-05-07 20:51:27:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

INFO: DB patching summary on node: oda2
SUCCESS: 2013-05-07 20:51:27:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

INFO: Setting up the SSH
..........done

You can use this query for example to check if your PSU was applied to the database.

SQL> select action_time,action,comments from registry$history;

ACTION_TIME                                    ACTION               COMMENTS
--------------------------------------------------------------------------- -----------------------------  -------------- 
06-MAY-13 06.19.03.590135 PM                            APPLY               PSU 11.2.0.3.5
07-MAY-13 08.51.06.689503 PM                            APPLY               PSU 11.2.0.3.6

As always, I am happy about Feedback

Advertisements

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s