
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);
[[email protected] ~]$ mkdir -p /tmp/ODA_patch/
[[email protected] ~]$ mkdir -p /tmp/ODA_patch/
- copiar o arquivo do patch para o diretório (nos dois nodes);
[[email protected] ~]$ cp -rp /cloudfs/patch_ODA/p17630388_29000_Linux-x86-64.zip /tmp/ODA_patch/
- checar a versão corrente;
[[email protected] ~]# 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);
[[email protected] ~]# 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.
[[email protected] ~]# 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;
[[email protected] ~]# 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:
[[email protected] ~]# 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:
[[email protected] ~]# 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:
[[email protected] ~]# 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/ [email protected]:/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:
[[email protected] ~]# 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:
[[email protected] ~]# 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
[[email protected] ~]#
- Verificar atualização do rdbms realizada:
[[email protected] ~]# 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)
[[email protected] ~]#
* Nesse momento temos todos os itens atualizados.
- Saída do opatch lsinventory:
- Como grid
[[email protected] ~]# su - grid
[[email protected] ~]$ . asm1.env
[[email protected] ~]$ cd $ORACLE_HOME/OPatch
[[email protected] 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.
[[email protected] OPatch]$
- Como oracle:
[[email protected] ~]# su - oracle
[[email protected] ~]$ . oracle1.env
[[email protected] ~]$ cd $ORACLE_HOME/OPatch
[[email protected] 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! 😀