Oracle Database Appliance Patch 2.7


oda_x3

Oracle has released on 9 August the ODA Patch 2.7. The Patch can be used for Bare Metal or virtualized platforms on ODA V1 or ODA X3-2.

What has happened in the 2.7 patch.

  • The database / grid infrastructure is now version 11.2.0.3.7 / 11.2.0.2.11 (July 2013 PSU)
  • OEL Upgrade from 5.8 to 5.9
  • Firmeware and Bios updates are included

Facts:

With Version 2.7 the Kernel Version was upgraded from 2.6.32-300.32.5.el5uek to version is 2.6.39-400.111.1.el5uek.

In this case also the OS is patched so BUG: 16725211 should also be fixed.
For more Information see MOS Note 1558550.1 EM Triggers Disk Device 100% Busy Alert For ODA Disk Partition

After patching the ODA components from 2.6 you would get this versions (changes are bold):

[root@oda1 ~]# oakcli update -patch 2.7.0.0.0 --verify

INFO: 2013-08-12 21:26:12: Reading metadata . It takes a while...
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)

Problems

When installing version 2.7 you would maybe get this error when upgrading the os.
Check the Logfiles to find details abount the error.

>    --> Missing Dependency: cups-libs = 1:1.3.7-30.el5 is needed by package 1:cups-1.3.7-30.el5.x86_64 (installed)
>  Error: Missing Dependency: cups-libs = 1:1.3.7-30.el5 is needed by package 1:cups-1.3.7-30.el5.x86_64 (installed)
>   You could try using --skip-broken to work around the problem
>   You could try running: package-cleanup --problems
>                          package-cleanup --dupes
>                          rpm -Va --nofiles --nodigest
>  The program package-cleanup is found in the yum-utils package. ,
>End Command output
2013-08-13 22:57:50: ERROR:  Failed to run /usr/bin/yum update --disablerepo=* --enablerepo=ODA_REPOS_LOC -y
2013-08-13 22:57:50: Executing cmd: /opt/oracle/oak/bin/oakcli inventory -pq -compname OS
2013-08-13 22:57:50: Command output:
>  OS=5.9
>  cur_version:5.9 ,
>End Command output
2013-08-13 22:57:50: ERROR:  Failed to update the OS
2013-08-13 22:57:50: Executing /usr/bin/yum --disablerepo=* --enablerepo=ODA_REPOS_LOC clean all
2013-08-13 22:57:50: Executing cmd: /usr/bin/yum --disablerepo=* --enablerepo=ODA_REPOS_LOC clean all
2013-08-13 22:57:50: Command output:
>  Loaded plugins: security
>  Cleaning up Everything ,
        >End Command output

I have manually fixed the cups-libs dependency problem and restarted the Patch to solve the problem.

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 ~]# oakcli unpack -package /tmp/p16760967_27000_Linux-x86-64.zip 
Unpacking takes a while,  pls wait....
Successfully unpacked the files to repository.
[root@oda2 ~]# oakcli unpack -package /tmp/p16760967_27000_Linux-x86-64.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.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-13 22:49:58: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-13 22:50:10: Completed pre patch script for 2.7.0.0.0
INFO: 2013-08-13 22:50:22: ------------------Patching HMP-------------------------
SUCCESS: 2013-08-13 22:50:56: Successfully upgraded the HMP

INFO: 2013-08-13 22:50:57: ----------------------Patching OAK---------------------
SUCCESS: 2013-08-13 22:51:31: Succesfully upgraded OAK

INFO: 2013-08-13 22:51:34: -----------------Installing / Patching  TFA-----------------
SUCCESS: 2013-08-13 22:53:36: Successfully updated / installed the TFA
...

INFO: 2013-08-13 22:53:37: ------------------Patching OS-------------------------
INFO: 2013-08-13 22:53:51: Clusterware is running on one or more nodes of the cluster
INFO: 2013-08-13 22:53:51: Attempting to stop clusterware and its resources across the cluster
SUCCESS: 2013-08-13 22:57:43: Successfully stopped the clusterware

ERROR: 2013-08-13 22:57:50: Failed to run /usr/bin/yum update --disablerepo=* --enablerepo=ODA_REPOS_LOC -y
ERROR: 2013-08-13 22:57:50: Failed to update the OS

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

INFO: 2013-08-13 22:57:59: ----------------Patching the Storage-------------------
INFO: 2013-08-13 22:57:59: ....................Patching SSDs...............
INFO: 2013-08-13 22:57:59: Disk : d20  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-13 22:57:59: Disk : d21  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-13 22:57:59: Disk : d22  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-13 22:57:59: Disk : d23  is already running with : ZeusIOPs G3 E12B
INFO: 2013-08-13 22:57:59: ....................Patching shared HDDs...............
INFO: 2013-08-13 22:58:00: Disk : d0  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:00: Disk : d1  is already running with : ST360057SSUN600G 0B25
INFO: 2013-08-13 22:58:00: Disk : d2  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:00: Disk : d3  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:00: Disk : d4  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:00: Disk : d5  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:00: Disk : d6  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d7  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d8  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d9  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d10  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d11  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d12  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:01: Disk : d13  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d14  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d15  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d16  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d17  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d18  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:02: Disk : d19  is already running with : HUS1560SCSUN600G A700
INFO: 2013-08-13 22:58:03: ....................Patching local HDDs...............
INFO: 2013-08-13 22:58:03: Disk : c0d0  is already running with : ST95001N SA03
INFO: 2013-08-13 22:58:03: Disk : c0d1  is already running with : ST95001N SA03
INFO: 2013-08-13 22:58:03: ....................Patching Expanders...............
INFO: 2013-08-13 22:58:03: Expander : x0  is already running with : T4 Storage 0342
INFO: 2013-08-13 22:58:03: Expander : x1  is already running with : T4 Storage 0342
INFO: 2013-08-13 22:58:03: ....................Patching Controllers...............
INFO: 2013-08-13 22:58:03: No-update for the Controller: c0
INFO: 2013-08-13 22:58:03: Controller : c1  is already running with : 0x0072 11.05.02.00
INFO: 2013-08-13 22:58:03: Controller : c2  is already running with : 0x0072 11.05.02.00
INFO: 2013-08-13 22:58:03: ------------Finished the storage Patching------------
INFO: 2013-08-13 22:58:05: -----------------Patching Ilom & Bios-----------------
INFO: 2013-08-13 22:58:05: Getting the ILOM Ip address
INFO: 2013-08-13 22:58:06: Updating the Ilom using LAN+ protocol
INFO: 2013-08-13 22:58:06: Updating the ILOM. It takes a while
INFO: 2013-08-13 23:02:45: Verifying the updated Ilom Version, it may take a while if ServiceProcessor is booting
INFO: 2013-08-13 23:02:46: Waiting for the service processor to be up
SUCCESS: 2013-08-13 23:06:37: Successfully updated the ILOM with the firmware 3.0.16.22.c r80379
INFO: Patching the infrastructure on node: oda2 , it may take upto 30 minutes. Please wait
...
INFO: Infrastructure patching summary on node: 192.168.16.24
SUCCESS: 2013-08-13 23:18:17:  Successfully upgraded the HMP
SUCCESS: 2013-08-13 23:18:17:  Succesfully updated the OAK
SUCCESS: 2013-08-13 23:18:17:  Successfully updated the TFA
ERROR: 2013-08-13 23:18:17:  Failed to update the OS
INFO: 2013-08-13 23:18:17:  IPMI is already upgraded
INFO: 2013-08-13 23:18:17:  Storage patching summary
SUCCESS: 2013-08-13 23:18:17:  No failures during storage upgrade
SUCCESS: 2013-08-13 23:18:17:  Successfully updated the ILOM & Bios

INFO: Infrastructure patching summary on node: 192.168.16.25
SUCCESS: 2013-08-13 23:18:17:  Successfully upgraded the HMP
SUCCESS: 2013-08-13 23:18:17:  Succesfully updated the OAK
ERROR: 2013-08-13 23:18:17:  Failed to update the OS
SUCCESS: 2013-08-13 23:18:17:  Succesfully updated the ASR
INFO: 2013-08-13 23:18:17:  IPMI is already upgraded
INFO: 2013-08-13 23:18:17:  Storage patching summary
SUCCESS: 2013-08-13 23:18:17:  No failures during storage upgrade
SUCCESS: 2013-08-13 23:18:17:  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

Upgrade of Grid Infrastructure

[root@oda1 scripts]# cd /opt/oracle/oak/bin/
[root@oda1 bin]# 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: 
INFO: Setting up the SSH
..........done
INFO: Running pre-install scripts
..........done
INFO: 2013-08-14 00:35:23: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-14 00:35:26: 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-14 00:35:54: 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-14 00:36:13: Patching the GI home on node oda1
INFO: 2013-08-14 00:36:13: Updating the opatch
INFO: 2013-08-14 00:37:07: Performing the conflict checks
SUCCESS: 2013-08-14 00:37:23: Conflict checks passed for all the homes
INFO: 2013-08-14 00:37:23: Checking if the patch is already applied on any of the homes
INFO: 2013-08-14 00:37:26: No home is already up-to-date
SUCCESS: 2013-08-14 00:37:31: Successfully stopped the dbconsoles
SUCCESS: 2013-08-14 00:37:46: Successfully stopped the EM agents
INFO: 2013-08-14 00:37:51: Applying patch on the homes: /u01/app/11.2.0.3/grid
INFO: 2013-08-14 00:37:51: It may take upto 15 mins
SUCCESS: 2013-08-14 00:49:57: Successfully applied the patch on home: /u01/app/11.2.0.3/grid
SUCCESS: 2013-08-14 00:49:57: Successfully started the dbconsoles
SUCCESS: 2013-08-14 00:50:12: Successfully started the EM Agents
INFO: 2013-08-14 00:50:12: Patching the GI home on node oda2
..........done

INFO: GI patching summary on node: oda1
SUCCESS: 2013-08-14 01:04:58:  Successfully applied the patch on home /u01/app/11.2.0.3/grid

INFO: GI patching summary on node: oda2
SUCCESS: 2013-08-14 01:04:58:  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.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-14 01:09:09: Running pre patch script for 2.7.0.0.0
INFO: 2013-08-14 01:09:12: 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-14 01:09:38: Getting the possible database homes for patching
...
INFO: 2013-08-14 01:09:43: 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-08-14 01:10:00: 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-14 01:10:20: Updating the opatch
INFO: 2013-08-14 01:11:14: Performing the conflict checks
SUCCESS: 2013-08-14 01:11:30: Conflict checks passed for all the homes
INFO: 2013-08-14 01:11:30: Checking if the patch is already applied on any of the homes
INFO: 2013-08-14 01:11:34: No home is already up-to-date
SUCCESS: 2013-08-14 01:11:36: Successfully stopped the dbconsoles
SUCCESS: 2013-08-14 01:11:51: Successfully stopped the EM agents
INFO: 2013-08-14 01:11:57: Applying patch on the homes: /u01/app/oracle/product/11.2.0.3/dbhome_1
INFO: 2013-08-14 01:11:57: It may take upto 15 mins
SUCCESS: 2013-08-14 01:18:39: Successfully applied the patch on home: /u01/app/oracle/product/11.2.0.3/dbhome_1
SUCCESS: 2013-08-14 01:18:39: Successfully started the dbconsoles
SUCCESS: 2013-08-14 01:18:54: Successfully started the EM Agents
INFO: 2013-08-14 01:18:55: Patching 11.2.0.3 Database homes on node oda2
INFO: 2013-08-14 01:28:29: Running the catbundle.sql
INFO: 2013-08-14 01:28:37: Running catbundle.sql on the database ORCL
..........done

INFO: DB patching summary on node: oda1
SUCCESS: 2013-08-14 01:29:13:  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-08-14 01:29:13:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

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

How to check that the PSU is applied to the Database?

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
---------------------------    ---------------      ---------------
07-MAY-13 08.51.06.689503 PM    APPLY               PSU 11.2.0.3.6
14-AUG-13 01.28.52.631285 AM    APPLY               PSU 11.2.0.3.7

As always, I am happy about Feedback

Advertisements

2 Gedanken zu “Oracle Database Appliance Patch 2.7

  1. How did you solve the package dependency issue?

    Missing Dependency: cups-libs = 1:1.3.7-30.el5 is needed by package 1:cups-1.3.7-30.el5.x86_64 (installed)
    Did you manually download the package and install?

    • Hello,
      you have two options. You can deinstall cups (and reinstall it with the patch) or what i did, go to the repos directory (/opt/oracle/oak/pkgrepos/orapkgs/OEL/5.9/Patches/5.9.1) and fix it with manual installation. After then restart the oakcli patch command.

      regards
      Peter

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