oracle

Olá amiguinhos! Vocês não achavam que o melhor site sobre certificação ia ficar de fora da onda do ODA, né?

O que? Não sabe o que é ODA? 😮

Clique AQUI e saiba mais sobre essa maravilha do titio Larry, afinal ele precisa comprar mais jatinhos, não é?

Enfim, tive a oportunidade de lidar com dois desses maravilhosos brinquedos… É um doce, tudo facilitado, inclusive o update como verão mais pra frente.

No segundo cliente que instalei, surgiu a necessidade de aplicar o update pois a versão base do rdbms que está no ODA é a 11.2.0.3.7.

Nessa versão existem vários bugs relacionados a mview, que não existiam no PSU anterior e que são corrigidos a partir do PSU 11.2.0.3.8. Esse bug, em particular, é um ORA-00600 que ocorre durante um update em uma mview.

Dessa forma, partimos para a atualização do ODA.

Atualizar um ODA é uma atividade um pouco maior que aplicar um PSU em um rdbms. Os patchs no ODA são chamados ‘bundle patch’, ou seja, eles atualizam desde firmwares de disco, controladoras, ilo, bios, parece que até a água na torneira de casa sai mais forte depois disso…

Nesse post irei demonstrar os passos realizados para o upgrade, de que versão saímos e para qual versão fomos. Bora:

  • criar o diretório onde ficará o patch (nos dois nodes);
[oracle@ora-oda01 ~]$ mkdir -p /tmp/ODA_patch/
[oracle@ora-oda02 ~]$ mkdir -p /tmp/ODA_patch/
  • copiar o arquivo do patch para o diretório (nos dois nodes);
[oracle@ora-oda02 ~]$ cp -rp /cloudfs/patch_ODA/p17630388_29000_Linux-x86-64.zip /tmp/ODA_patch/
  • checar a versão corrente;
[root@ora-oda01 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version
--------------  ---------------           ------------------        -----------------
2.7.0.0.0
                Controller_INT            11.05.02.00               Up-to-date
                Controller_EXT            11.05.02.00               Up-to-date
                Expander                  0010                      000F
                SSD_SHARED                9432                      Up-to-date
                HDD_LOCAL                 A31A                      Up-to-date
                HDD_SHARED                A31A                      Up-to-date
                ILOM                      3.1.2.10.b r77700         3.1.2.10 r74387
                BIOS                      17030300                  17021300
                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)
  • descompactar o bundle (nos dois nodes);
[root@ora-oda01 ~]# oakcli unpack -package /tmp/ODA_patch/p17630388_29000_Linux-x86-64.zip
Unpacking takes a while,  pls wait....
WARNING: 2014-02-25 19:01:50: You are trying to unpack 2.9.0.0.0 Patchbundle
INFO: 2014-02-25 19:01:50: Current system is at 2.7.0.0.0
WARNING: 2014-02-25 19:01:50: Unpacking this bundle may overwrite some files which may cause patching/deployment failures
Press Yes to continue or No to quit.... :
Yes
Successfully unpacked the files to repository.

[root@ora-oda02 ~]# oakcli unpack -package /tmp/ODA_patch/p17630388_29000_Linux-x86-64.zip
Unpacking takes a while,  pls wait....
WARNING: 2014-02-25 19:03:49: You are trying to unpack 2.9.0.0.0 Patchbundle
INFO: 2014-02-25 19:03:49: Current system is at 2.7.0.0.0
WARNING: 2014-02-25 19:03:49: Unpacking this bundle may overwrite some files which may cause patching/deployment failures
Press Yes to continue or No to quit.... :
Yes
Successfully unpacked the files to repository.
  • verificar os componentes que serão atualizados;
[root@ora-oda01 ~]# oakcli update -patch  2.9.0.0.0 --verify

INFO: 2014-02-25 19:04:51: Reading metadata . It takes a while...
     Component Name            Installed Version         Proposed Patch Version
     ---------------           ------------------        -----------------
     Controller_INT            11.05.02.00               11.05.03.00
     Controller_EXT            11.05.02.00               11.05.03.00
     Expander                  0010                      0018
     SSD_SHARED                9432                      9440
     HDD_LOCAL                 A31A                      A606
     HDD_SHARED                A31A                      A600
     ILOM                      3.1.2.10.b r77700         3.1.2.10.d r83372
     BIOS                      17030300                  17050100
     IPMI                      1.8.10.5                  Up-to-date
     HMP                       2.2.6.2                   2.2.6.5
     OAK                       2.7.0.0.0                 2.9.0.0.0
     OEL                       5.9                       Up-to-date
     GI_HOME                   11.2.0.3.7(16619892,      11.2.0.4.0(17721778)
                               16742216)
     DB_HOME                   11.2.0.3.7(16619892,      11.2.0.3.9(17540582,
                               16742216)                 17592127)

* Podemos notar acima os vários updates que serão realizados, com atenção para o GI que sairá da versão 11.2.0.3.7 para 11.2.0.4.0 e o rdbms que irá para a versão 11.2.0.3.9.

  • Aplicando o Bundle Patch 2.9.0.0 – infra:
[root@ora-oda01 ~]# oakcli update -patch  2.9.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: 2014-02-25 19:07:36: Running pre patch script for 2.9.0.0.0
INFO: 2014-02-25 19:07:50: Completed pre patch script for 2.9.0.0.0

INFO: 2014-02-25 19:08:06: ------------------Patching HMP-------------------------
SUCCESS: 2014-02-25 19:08:39: Successfully upgraded the HMP

INFO: 2014-02-25 19:08:39: ----------------------Patching OAK---------------------
SUCCESS: 2014-02-25 19:09:08: Successfully upgraded OAK

INFO: 2014-02-25 19:09:08: ----------------------Patching JDK---------------------
SUCCESS: 2014-02-25 19:09:19: Successfully upgraded JDK

INFO: 2014-02-25 19:09:19: ------------------Patching OS-------------------------
INFO: 2014-02-25 19:09:36: Clusterware is running on one or more nodes of the cluster
INFO: 2014-02-25 19:09:36: Attempting to stop clusterware and its resources across the cluster
SUCCESS: 2014-02-25 19:11:43: Successfully stopped the clusterware

SUCCESS: 2014-02-25 19:13:12: Successfully upgraded the OS

INFO: 2014-02-25 19:13:18: ----------------------Patching IPMI---------------------
INFO: 2014-02-25 19:13:19: IPMI is already upgraded or running with latest version

INFO: 2014-02-25 19:13:27: ----------------Patching the Storage-------------------
INFO: 2014-02-25 19:13:27: ....................Patching SSDs...............
INFO: 2014-02-25 19:13:27: Updating the  Disk : d20 with the firmware : Z16IZF4EUSUN200G 9440
SUCCESS: 2014-02-25 19:13:54: Successfully updated the firmware on  Disk : d20 to Z16IZF4EUSUN200G 9440
INFO: 2014-02-25 19:13:54: Updating the  Disk : d21 with the firmware : Z16IZF4EUSUN200G 9440
SUCCESS: 2014-02-25 19:14:34: Successfully updated the firmware on  Disk : d21 to Z16IZF4EUSUN200G 9440
INFO: 2014-02-25 19:14:35: Updating the  Disk : d22 with the firmware : Z16IZF4EUSUN200G 9440
SUCCESS: 2014-02-25 19:15:07: Successfully updated the firmware on  Disk : d22 to Z16IZF4EUSUN200G 9440
INFO: 2014-02-25 19:15:07: Updating the  Disk : d23 with the firmware : Z16IZF4EUSUN200G 9440
SUCCESS: 2014-02-25 19:15:37: Successfully updated the firmware on  Disk : d23 to Z16IZF4EUSUN200G 9440
INFO: 2014-02-25 19:15:37: ....................Patching shared HDDs...............
INFO: 2014-02-25 19:15:37: Updating the  Disk : d0 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:16:12: Successfully updated the firmware on  Disk : d0 to H109090SESUN900G A600
INFO: 2014-02-25 19:16:13: Updating the  Disk : d1 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:16:42: Successfully updated the firmware on  Disk : d1 to H109090SESUN900G A600
INFO: 2014-02-25 19:16:42: Updating the  Disk : d2 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:17:14: Successfully updated the firmware on  Disk : d2 to H109090SESUN900G A600
INFO: 2014-02-25 19:17:14: Updating the  Disk : d3 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:17:44: Successfully updated the firmware on  Disk : d3 to H109090SESUN900G A600
INFO: 2014-02-25 19:17:45: Updating the  Disk : d4 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:18:17: Successfully updated the firmware on  Disk : d4 to H109090SESUN900G A600
INFO: 2014-02-25 19:18:17: Updating the  Disk : d5 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:18:48: Successfully updated the firmware on  Disk : d5 to H109090SESUN900G A600
INFO: 2014-02-25 19:18:48: Updating the  Disk : d6 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:19:19: Successfully updated the firmware on  Disk : d6 to H109090SESUN900G A600
INFO: 2014-02-25 19:19:19: Updating the  Disk : d7 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:20:05: Successfully updated the firmware on  Disk : d7 to H109090SESUN900G A600
INFO: 2014-02-25 19:20:05: Updating the  Disk : d8 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:20:41: Successfully updated the firmware on  Disk : d8 to H109090SESUN900G A600
INFO: 2014-02-25 19:20:42: Updating the  Disk : d9 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:21:22: Successfully updated the firmware on  Disk : d9 to H109090SESUN900G A600
INFO: 2014-02-25 19:21:22: Updating the  Disk : d10 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:21:59: Successfully updated the firmware on  Disk : d10 to H109090SESUN900G A600
INFO: 2014-02-25 19:21:59: Updating the  Disk : d11 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:22:35: Successfully updated the firmware on  Disk : d11 to H109090SESUN900G A600
INFO: 2014-02-25 19:22:35: Updating the  Disk : d12 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:23:12: Successfully updated the firmware on  Disk : d12 to H109090SESUN900G A600
INFO: 2014-02-25 19:23:12: Updating the  Disk : d13 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:23:50: Successfully updated the firmware on  Disk : d13 to H109090SESUN900G A600
INFO: 2014-02-25 19:23:50: Updating the  Disk : d14 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:24:27: Successfully updated the firmware on  Disk : d14 to H109090SESUN900G A600
INFO: 2014-02-25 19:24:27: Updating the  Disk : d15 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:25:08: Successfully updated the firmware on  Disk : d15 to H109090SESUN900G A600
INFO: 2014-02-25 19:25:08: Updating the  Disk : d16 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:25:46: Successfully updated the firmware on  Disk : d16 to H109090SESUN900G A600
INFO: 2014-02-25 19:25:46: Updating the  Disk : d17 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:26:21: Successfully updated the firmware on  Disk : d17 to H109090SESUN900G A600
INFO: 2014-02-25 19:26:21: Updating the  Disk : d18 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:27:02: Successfully updated the firmware on  Disk : d18 to H109090SESUN900G A600
INFO: 2014-02-25 19:27:02: Updating the  Disk : d19 with the firmware : H109090SESUN900G A600
SUCCESS: 2014-02-25 19:27:34: Successfully updated the firmware on  Disk : d19 to H109090SESUN900G A600
INFO: 2014-02-25 19:27:34: ....................Patching local HDDs...............
INFO: 2014-02-25 19:27:34: Updating the  Disk : c0d0 with the firmware : H109060SESUN600G A606
SUCCESS: 2014-02-25 19:28:09: Successfully updated the firmware on  Disk : c0d0 to H109060SESUN600G A606
INFO: 2014-02-25 19:28:09: Updating the  Disk : c0d1 with the firmware : H109060SESUN600G A606
SUCCESS: 2014-02-25 19:28:45: Successfully updated the firmware on  Disk : c0d1 to H109060SESUN600G A606
INFO: 2014-02-25 19:28:46: ....................Patching Expanders...............
INFO: 2014-02-25 19:28:46: Updating the  Expander : c1x0 with the firmware : DE2-24P 0018
SUCCESS: 2014-02-25 19:30:59: Successfully updated the firmware on  Expander : c1x0 to DE2-24P 0018
INFO: 2014-02-25 19:31:00: Updating the  Expander : c2x0 with the firmware : DE2-24P 0018
SUCCESS: 2014-02-25 19:33:09: Successfully updated the firmware on  Expander : c2x0 to DE2-24P 0018
INFO: 2014-02-25 19:33:09: ....................Patching Controllers...............
INFO: 2014-02-25 19:33:09: Updating the  Controller : c0 with the firmware : 0x0072 11.05.03.00
SUCCESS: 2014-02-25 19:35:10: Successfully updated the firmware on  Controller : c0 to 0x0072 11.05.03.00
INFO: 2014-02-25 19:35:10: Updating the  Controller : c1 with the firmware : 0x0072 11.05.03.00
SUCCESS: 2014-02-25 19:37:22: Successfully updated the firmware on  Controller : c1 to 0x0072 11.05.03.00
INFO: 2014-02-25 19:37:23: Updating the  Controller : c2 with the firmware : 0x0072 11.05.03.00
SUCCESS: 2014-02-25 19:39:29: Successfully updated the firmware on  Controller : c2 to 0x0072 11.05.03.00
INFO: 2014-02-25 19:39:30: ------------Finished the storage Patching------------

INFO: 2014-02-25 19:39:33: -----------------Patching Ilom & Bios-----------------
INFO: 2014-02-25 19:39:33: Updating the Ilom using LAN over USB
INFO: 2014-02-25 19:39:33: Enabling Interconnect
INFO: 2014-02-25 19:39:59: Getting the SP IP address
INFO: 2014-02-25 19:40:15: Updating the ILOM. It takes a while
INFO: 2014-02-25 19:58:31: Verifying the updated Ilom Version, it may take a while if ServiceProcessor is booting
INFO: 2014-02-25 19:58:33: Waiting for the service processor to be up
INFO: 2014-02-25 20:03:15: Disabling Interconnect
SUCCESS: 2014-02-25 20:03:28: Successfully updated the ILOM with the firmware 3.1.2.10.d r83372

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

INFO: Infrastructure patching summary on node: 192.168.16.24
SUCCESS: 2014-02-25 20:35:46:  Successfully upgraded the HMP
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the OAK
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the JDK
SUCCESS: 2014-02-25 20:35:46:  Successfully upgraded the OS
INFO: 2014-02-25 20:35:46:  IPMI is already upgraded
INFO: 2014-02-25 20:35:46:  Storage patching summary
SUCCESS: 2014-02-25 20:35:46:  No failures during storage upgrade
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the ILOM & Bios

INFO: Infrastructure patching summary on node: 192.168.16.25
SUCCESS: 2014-02-25 20:35:46:  Successfully upgraded the HMP
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the OAK
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the JDK
SUCCESS: 2014-02-25 20:35:46:  Successfully upgraded the OS
INFO: 2014-02-25 20:35:46:  IPMI is already upgraded
INFO: 2014-02-25 20:35:46:  Storage patching summary
SUCCESS: 2014-02-25 20:35:46:  No failures during storage upgrade
SUCCESS: 2014-02-25 20:35:46:  Successfully updated the ILOM & Bios

INFO: Running post-install scripts
............done

INFO: OS is upgraded to UEK.
INFO: current GI version is 11.2.0.3.7(16619892,16742216)
INFO: You must upgrade the GI also
INFO: Some of the patched components require node reboot. Rebooting the nodes
INFO: Setting up the SSH
............done

Broadcast message from root (Tue Feb 25 20:41:01 2014):

The system is going down for system halt NOW!
  • Verificar atualização da infra realizada:
[root@ora-oda01 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version
--------------  ---------------           ------------------        -----------------
2.9.0.0.0
                Controller_INT            11.05.03.00               Up-to-date
                Controller_EXT            11.05.03.00               Up-to-date
                Expander                  0018                      Up-to-date
                SSD_SHARED                9440                      Up-to-date
                HDD_LOCAL                 A606                      Up-to-date
                HDD_SHARED                A600                      Up-to-date
                ILOM                      3.1.2.10.d r83372         Up-to-date
                BIOS                      17050100                  Up-to-date
                IPMI                      1.8.10.5                  Up-to-date
                HMP                       2.2.6.5                   Up-to-date
                OAK                       2.9.0.0.0                 Up-to-date
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.3.7(16619892,      11.2.0.4.0(17721778)
                                          16742216)
                DB_HOME                   11.2.0.3.7(16619892,      11.2.0.3.9(17540582,
                                          16742216)                 17592127)

* Nesse momento apenas os itens relacionados a infra foram atualizados.

  • Aplicando o Bundle Patch 2.9.0.0 – gi:
[root@ora-oda01 ~]# oakcli update -patch  2.9.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: 2014-02-25 21:01:38: Running pre patch script for 2.9.0.0.0
INFO: 2014-02-25 21:01:41: Completed pre patch script for 2.9.0.0.0
INFO: Stopped Oakd
...
...

INFO: 2014-02-25 21:02:17: Upgrading GI, it may take up to 45 mins
............done
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz 
--exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0

..........done
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2014-02-25 21:04:08: Installing GI clone
INFO: 2014-02-25 21:09:25: Running root scripts

SUCCESS: 2014-02-25 21:28:10: Successfully upgraded the GI
...

..........done

INFO: GI patching summary on node: ora-oda01
SUCCESS: 2014-02-25 21:28:32:  Successfully upgraded GI

INFO: GI patching summary on node: ora-oda02

INFO: Running post-install scripts
..........done
...
...
INFO: Started Oakd
INFO: Setting up the SSH
..........done
  • Verificar atualização do gi realizada:
[root@ora-oda01 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version
--------------  ---------------           ------------------        -----------------
2.9.0.0.0
                Controller_INT            11.05.03.00               Up-to-date
                Controller_EXT            11.05.03.00               Up-to-date
                Expander                  0018                      Up-to-date
                SSD_SHARED                9440                      Up-to-date
                HDD_LOCAL                 A606                      Up-to-date
                HDD_SHARED                A600                      Up-to-date
                ILOM                      3.1.2.10.d r83372         Up-to-date
                BIOS                      17050100                  Up-to-date
                IPMI                      1.8.10.5                  Up-to-date
                HMP                       2.2.6.5                   Up-to-date
                OAK                       2.9.0.0.0                 Up-to-date
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.4.0(17721778)      Up-to-date
                DB_HOME                   11.2.0.3.7(16619892,      11.2.0.3.9(17540582,
                                          16742216)                 17592127)

* Nesse momento temos os itens relacionados a infra e o GI atualizados.

  • Aplicando o Bundle Patch 2.9.0.0 – rdbms:
[root@ora-oda01 ~]# oakcli update -patch  2.9.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: 2014-02-25 21:36:57: Running pre patch script for 2.9.0.0.0
INFO: 2014-02-25 21:37:00: Completed pre patch script for 2.9.0.0.0
...
...

..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2014-02-25 21:37:26: Getting the possible database homes for patching
...
INFO: 2014-02-25 21:37:31: Patching 11.2.0.3 Database homes on node ora-oda01

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: 2014-02-25 21:37:44: Setting up ssh for the user oracle
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/temp_clunodes.txt are pingable and alive.
INFO: 2014-02-25 21:38:04: Updating the opatch
INFO: 2014-02-25 21:38:38: Performing the conflict checks
SUCCESS: 2014-02-25 21:38:53: Conflict checks passed for all the homes
INFO: 2014-02-25 21:38:53: Checking if the patch is already applied on any of the homes
INFO: 2014-02-25 21:38:58: No home is already up-to-date
SUCCESS: 2014-02-25 21:39:27: Successfully stopped the dbconsoles
SUCCESS: 2014-02-25 21:39:32: Successfully stopped the EM agents
WARNING: 2014-02-25 21:39:37: A stale emagnt with 24535 is running. Trying to kill it
WARNING: 2014-02-25 21:39:37: A stale emagnt with 24537 is running. Trying to kill it
INFO: 2014-02-25 21:39:37: Applying patch on the homes: /u01/app/oracle/product/11.2.0.3/dbhome_1
INFO: 2014-02-25 21:39:37: It may take upto 15 mins
SUCCESS: 2014-02-25 21:45:05: Successfully applied the patch on home: /u01/app/oracle/product/11.2.0.3/dbhome_1
SUCCESS: 2014-02-25 21:45:21: Successfully started the dbconsoles
SUCCESS: 2014-02-25 21:45:21: Successfully started the EM Agents
INFO: 2014-02-25 21:45:23: Patching 11.2.0.3 Database homes on node ora-oda02
INFO: 2014-02-25 21:53:24: Running the catbundle.sql
INFO: 2014-02-25 21:53:32: Running catbundle.sql on the database ora9idfo
INFO: 2014-02-25 21:53:42: Running catbundle.sql on the database oracle
INFO: 2014-02-25 21:53:51: Running catbundle.sql on the database oradb

..........done

INFO: DB patching summary on node: ora-oda01
SUCCESS: 2014-02-25 21:54:14:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

INFO: DB patching summary on node: ora-oda02
SUCCESS: 2014-02-25 21:54:14:  Successfully applied the patch on home /u01/app/oracle/product/11.2.0.3/dbhome_1

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

[root@ora-oda01 ~]#
  • Verificar atualização do rdbms realizada:
[root@ora-oda01 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name            Installed Version         Supported Version
--------------  ---------------           ------------------        -----------------
2.9.0.0.0
                Controller_INT            11.05.03.00               Up-to-date
                Controller_EXT            11.05.03.00               Up-to-date
                Expander                  0018                      Up-to-date
                SSD_SHARED                9440                      Up-to-date
                HDD_LOCAL                 A606                      Up-to-date
                HDD_SHARED                A600                      Up-to-date
                ILOM                      3.1.2.10.d r83372         Up-to-date
                BIOS                      17050100                  Up-to-date
                IPMI                      1.8.10.5                  Up-to-date
                HMP                       2.2.6.5                   Up-to-date
                OAK                       2.9.0.0.0                 Up-to-date
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.4.0(17721778)      Up-to-date
                DB_HOME                   11.2.0.3.9(17540582,      Up-to-date
                                          17592127)
[root@ora-oda01 ~]#

* Nesse momento temos todos os itens atualizados.

  • Saída do opatch lsinventory:
  • Como grid
[root@ora-oda01 ~]# su - grid
[grid@ora-oda01 ~]$ . asm1.env
[grid@ora-oda01 ~]$ cd $ORACLE_HOME/OPatch
[grid@ora-oda01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/11.2.0.4/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0.4/grid/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2014-02-25_21-58-31PM_1.log

Lsinventory Output file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/lsinv/lsinventory2014-02-25_21-58-31PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 11g                                       11.2.0.4.0
There are 1 product(s) installed in this Oracle Home.

Interim patches (1) :

Patch  17721778     : applied on Sun Dec 15 05:09:32 BRST 2013
Unique Patch ID:  17002209
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.4.0(17721778)"
   Created on 1 Dec 2013, 17:16:09 hrs PST8PDT
   Bugs fixed:
     17721778

Rac system comprising of multiple nodes
  Local node = ora-oda01
  Remote node = ora-oda02

--------------------------------------------------------------------------------

OPatch succeeded.
[grid@ora-oda01 OPatch]$
  • Como oracle:
[root@ora-oda01 ~]# su - oracle
[oracle@ora-oda01 ~]$ . oracle1.env
[oracle@ora-oda01 ~]$ cd $ORACLE_HOME/OPatch
[oracle@ora-oda01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2014-02-25_21-59-42PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-02-25_21-59-42PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.

Interim patches (2) :

Patch  17540582     : applied on Tue Feb 25 21:42:45 BRT 2014
Unique Patch ID:  16954971
Patch description:  "Database Patch Set Update : 11.2.0.3.9 (17540582)"
   Created on 12 Dec 2013, 22:04:32 hrs PST8PDT
Sub-patch  16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     13593999, 10350832, 14138130, 12919564, 13561951, 14198511, 13588248
     13080778, 13804294, 16710324, 12873183, 14472647, 12880299, 13369579
     14409183, 13492735, 12857027, 13496884, 14263036, 14263073, 13015379
     16038929, 17748833, 16563678, 13732226, 13866822, 13742434, 13944971
     12950644, 17748831, 12899768, 13063120, 13958038, 14613900, 13972394
     11877623, 17088068, 13072654, 12395918, 13814739, 17343514, 13649031
     13981051, 12797765, 17333200, 12923168, 16761566, 16279401, 13384182
     13466801, 15996344, 14207163, 13724193, 13642044, 11063191, 13945708
     12797420, 12865902, 15869211, 13041324, 14003090, 16314468, 16019955
     11708510, 14637368, 13026410, 13737746, 13742438, 15841373, 16347904
     15910002, 16362358, 14398795, 13579992, 16344871, 10400244, 14275605
     13742436, 9858539, 14841812, 16338983, 9703627, 13483354, 14207317
     14393728, 12764337, 16902043, 14459552, 14191508, 12964067, 12780983
     12583611, 14383007, 14546575, 15862016, 13476583, 13489024, 17748830
     14088346, 13448206, 16314466, 13419660, 14110275, 13430938, 13467683
     14548763, 12834027, 13632809, 13377816, 13036331, 14727310, 16175381
     13584130, 12829021, 15862019, 12794305, 14546673, 12791981, 13787482
     13503598, 10133521, 12744759, 13399435, 13553883, 14023636, 14762511
     9095696, 14343501, 13860201, 13257247, 14176879, 16014985, 12312133
     14480675, 16306019, 13559697, 9706792, 12974860, 12940620, 13098318
     13773133, 15883525, 16794244, 13340388, 13366202, 13528551, 12894807
     12747437, 13454210, 12748240, 13385346, 15987992, 13923995, 13582702
     14571027, 12784406, 13907462, 13493847, 13857111, 13035804, 16710363
     13544396, 14128555, 8547978, 14226599, 17478415, 17333197, 9397635
     14007968, 12925089, 12693626, 14189694, 12815057, 17761775, 16721594
     13332439, 14038787, 11071989, 14207902, 14062796, 12913474, 14390252
     16314470, 13370330, 14062794, 13358781, 17333202, 12960925, 9659614
     14546638, 13699124, 13936424, 9797851, 14301592, 16794240, 13338048
     12938841, 12620823, 12656535, 12678920, 14488943, 16850197, 14791477
     14062792, 13807411, 16794238, 15862022, 12594032, 13250244, 9761357
     12612118, 14053457, 13527323, 10625145, 15862020, 13910420, 12780098
     13696216, 10263668, 14841558, 16794242, 16944698, 15862023, 16056266
     13834065, 14351566, 13723052, 13011409, 14063280, 13566938, 13737888
     13624984, 16024441, 17333199, 13914613, 17540582, 14258925, 14222403
     14755945, 13645875, 12571991, 14664355, 12998795, 13719081, 14469008
     14188650, 17019974, 13742433, 16368108, 16314469, 12905058, 6690853
     16212405, 12849688, 13742435, 13464002, 13534412, 12879027, 12585543
     13790109, 12535346, 16382448, 12588744, 13916549, 13786142, 12847466
     13855490, 13551402, 12582664, 14262913, 17332800, 14695377, 12912137
     13612575, 13484963, 14163397, 17437634, 13772618, 16694777, 13070939
     14369664, 12391034, 13605839, 16314467, 16279211, 12976376, 12755231
     13680405, 14589750, 13742437, 14318397, 11868640, 14644185, 13326736
     13596521, 13001379, 12898558, 17752121, 13099577, 9873405, 16372203
     16344758, 11715084, 16231699, 9547706, 14040433, 12662040, 12617123
     17748832, 16530565, 12845115, 16844086, 17748834, 13354082, 13397104
     13913630, 16462834, 12983611, 13550185, 13810393, 14121009, 13065099
     11840910, 13903046, 15862017, 13572659, 16294378, 13718279, 13657605
     14480676, 13632717, 14668670, 14063281, 13420224, 13812031, 16299830
     12646784, 14512189, 12755116, 13616375, 17230530, 14035825, 13427062
     12861463, 13092220, 15862021, 13043012, 16619892, 13685544, 15862018
     13499128, 13561750, 12718090, 13848402, 13725395, 12401111, 12796518
     13362079, 12917230, 13042639, 13923374, 14220725, 12621588, 13524899
     14751895, 14480674, 13916709, 14076523, 15905421, 12731940, 13343438
     14205448, 17748835, 14127231, 17082364, 15853081, 14273397, 16844448
     14467061, 12971775, 16864562, 14497307, 12748538, 10242202, 14230270
     16382353, 13686047, 14095982, 17333203, 13591624, 14523004, 13440516
     16794241, 14062795, 13035360, 13040943, 13843646, 16794243, 14841409
     13059165, 14062797, 12959852, 12345082, 16703112, 13890080, 17333198
     16450169, 12658411, 13780035, 14062793, 13038684, 16742095, 13742464
     14052474, 13060271, 13911821, 13457582, 7509451, 13791364, 12821418
     13502183, 13705338, 16794239, 15862024, 13554409, 13645917, 13103913, 12772404

Patch  17592127     : applied on Tue Feb 25 21:41:44 BRT 2014
Unique Patch ID:  16995168
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
   Created on 16 Dec 2013, 22:20:24 hrs PST8PDT
   Bugs fixed:
     17592127, 17076717, 16619898, 16315641, 15876003, 14275572, 13919095
     13696251, 13348650, 12659561, 16562733, 14305980, 14277586, 13729298
     13987807, 14625969, 16629075, 13825231, 12794268, 13000491, 13498267
     15934834, 11675721, 14082976, 12771830, 13906374, 14515980, 14085018
     13943175, 14102704, 14171552, 12594616, 13879428, 12897902, 12726222
     12829429, 13079948, 13991403, 13090686, 12995950, 13251796, 13582411
     14651272, 12903592, 12990582, 13857364, 16747308, 15856610, 13082238
     16446410, 12947871, 13256955, 13037709, 14535011, 12878750, 16560359
     14048512, 11772838, 13058611, 13001955, 17272731, 13440962, 13727853
     13425727, 12885323, 12870400, 16434983, 14212634, 14407395, 13332363
     14761411, 13430626, 16346413, 14456069, 13811209, 12709476, 14168708
     14096821, 14626717, 13460353, 16206997, 13694885, 12857064, 12899169
     13111013, 12558569, 13323698, 16547309, 10260842, 16613232, 13085732
     16555186, 14332688, 12928658, 10317921, 17172091, 16077216, 13869978
     12914824, 13789135, 12730342, 12950823, 13355963, 13531373, 14268365
     13776758, 12720728, 13620816, 14628188, 13023609, 15874565, 16578706
     17405302, 16735171, 13024624, 13039908, 14525998, 14385860, 15911134
     13036424, 13938166, 15907617, 13011520, 13569812, 12758736, 13001901
     13077654, 13430715, 13550689, 13251609, 13806545, 13634583, 14271305
     12538907, 13947200, 12996428, 13066371, 17043601, 13483672, 13936066
     12897651, 13540563, 12896850, 13241779, 12728585, 12876314, 12925041
     12650672, 12398492, 12848480, 13088512, 13652088, 14226134, 16307750
     12917897, 12975811, 13653178, 17247404, 13371153, 14800989, 16684285
     10114953, 14001941, 11836951, 14179376, 12965049, 14773530, 12765467
     16821005, 12950415, 15998768, 13339443, 13965075, 16210540, 14307855
     12784559, 14242977, 13955385, 12704789, 16206882, 13745317, 16909409
     17305100, 15832129, 13074261, 12971251, 13993634, 17737618, 13523527
     16876500, 13719731, 13396284, 12639013, 12867511, 13989181, 12959140
     16836877, 14748254, 13912274, 12829917, 12349553, 12849377, 12934171
     13843080, 14496536, 13899736, 13924431, 12680491, 13334158, 15869775
     10418841, 12832204, 13838047, 13002015, 14639430, 11822565, 15920201, 12791719

Rac system comprising of multiple nodes
  Local node = ora-oda01
  Remote node = ora-oda02

--------------------------------------------------------------------------------

OPatch succeeded.

E bingo! Temos a atualização do GI para 11.2.0.4 e do rdbms para 11.2.0.3.9. Ainda seria possível baixar o pacote ‘clone’ do db_home 11.2.0.4.1, mas optamos por não mexer tanto na estrutura do db_home já existente, aplicando apenas o update do último PSU da versão 11.2.0.3.x

Era isso pessoal, espero que tenham gostado, fiquem com esse som e continuem nos visitando! 🙂

PS.: Só pra deixar claro, esse patch é NOVÍSSIMO, tendo sido lançado no dia 18/02/2014! 😀