Hoje estou trazendo um artigo com as etapas para atualizar a versão ODA para 19.10.
Antes de começar, devemos verificar a release mínima para que possamos realizar o upgrade com sucesso.
Antes de iniciar os patches, certifique-se de ter espaço suficiente nos sistemas de arquivos /, / u01 e / opt.
1. Backup snapshot from ODA
root@oda-duts-01 / # /opt/odabr/odabr backup -snap -osize 35 -rsize 20 -usize 60 INFO: 2021-07-01 10:58:35: Please check the logfile '/opt/odabr/out/log/odabr_53053.log' for more details │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-58 Copyright Oracle, Inc. 2013, 2020 -------------------------------------------------------- Author: Ruggero Citton <[email protected]> RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ INFO: 2021-07-01 10:58:35: Checking superuser INFO: 2021-07-01 10:58:35: Checking Bare Metal INFO: 2021-07-01 10:58:35: Removing existing LVM snapshots WARNING: 2021-07-01 10:58:36: LVM snapshot for 'opt' does not exist WARNING: 2021-07-01 10:58:36: LVM snapshot for 'u01' does not exist WARNING: 2021-07-01 10:58:36: LVM snapshot for 'root' does not exist INFO: 2021-07-01 10:58:36: Checking LVM size INFO: 2021-07-01 10:58:36: Boot device backup INFO: 2021-07-01 10:58:36: Getting EFI device INFO: 2021-07-01 10:58:36: ...step1 - unmounting EFI INFO: 2021-07-01 10:58:36: ...step2 - making efi device backup SUCCESS: 2021-07-01 10:58:40: ...EFI device backup saved as '/opt/odabr/out/hbi/efi.img' INFO: 2021-07-01 10:58:40: ...step3 - checking EFI device backup INFO: 2021-07-01 10:58:40: Getting boot device INFO: 2021-07-01 10:58:40: ...step1 - making boot device backup using tar SUCCESS: 2021-07-01 10:58:45: ...boot content saved as '/opt/odabr/out/hbi/boot.tar.gz' INFO: 2021-07-01 10:58:45: ...step2 - unmounting boot INFO: 2021-07-01 10:58:45: ...step3 - making boot device backup using dd SUCCESS: 2021-07-01 10:58:50: ...boot device backup saved as '/opt/odabr/out/hbi/boot.img' INFO: 2021-07-01 10:58:50: ...step4 - mounting boot INFO: 2021-07-01 10:58:50: ...step5 - mounting EFI INFO: 2021-07-01 10:58:50: ...step6 - checking boot device backup INFO: 2021-07-01 10:58:51: OCR backup INFO: 2021-07-01 10:58:53: ...ocr backup saved as '/opt/odabr/out/hbi/ocrbackup_53053.bck' INFO: 2021-07-01 10:58:53: Making LVM snapshot backup SUCCESS: 2021-07-01 10:58:53: ...snapshot backup for 'opt' created successfully SUCCESS: 2021-07-01 10:58:55: ...snapshot backup for 'u01' created successfully SUCCESS: 2021-07-01 10:58:55: ...snapshot backup for 'root' created successfully SUCCESS: 2021-07-01 10:58:55: LVM snapshots backup done successfully root@oda-duts-01 / # /opt/odabr/odabr infosnap │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-58 Copyright Oracle, Inc. 2013, 2020 -------------------------------------------------------- Author: Ruggero Citton <[email protected]> RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ LVM snap name Status COW Size Data% ------------- ---------- ---------- ------ root_snap active 20.00 GiB 0.01% opt_snap active 35.00 GiB 0.01% u01_snap active 60.00 GiB 0.01%
2. Unzip and update the repository
Para o patch do servidor, você precisará dos seguintes patchs (para download em support.oracle.com)
-p32351355_1910000_Linux-x86-64_1of2.zip
-p32351355_1910000_Linux-x86-64_2of2.zip
As etapas são as seguintes. Todas as ações podem ser encontradas na documentação
2.1 Unpack the two files and then copy them to the oda-duts-01
root@oda-duts-01 /backups # cd patches/
root@oda-duts-01 /backups/patches # ll
total 23037662
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
root@oda-duts-01 /backups/patches # unzip p32351355_1910000_Linux-x86-64_1of2.zip
Archive: p32351355_1910000_Linux-x86-64_1of2.zip
extracting: oda-sm-19.10.0.0.0-210222.4-server1of2.zip
inflating: README.txt
root@oda-duts-01 /backups/patches # unzip p32351355_1910000_Linux-x86-64_2of2.zip
Archive: p32351355_1910000_Linux-x86-64_2of2.zip
extracting: oda-sm-19.10.0.0.0-210222.4-server2of2.zip
root@oda-duts-01 /backups/patches # ll
total 43110758
-rw-r--r-- 1 root root 11467982139 Mar 20 22:40 oda-sm-19.10.0.0.0-210222.4-server1of2.zip
-rw-r--r-- 1 root root 9086866837 Mar 20 23:02 oda-sm-19.10.0.0.0-210222.4-server2of2.zip
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
-rwxr-xr-x 1 root root 191 Feb 24 02:17 README.txt
You have new mail in /var/spool/mail/root
root@oda-duts-01 /backups/patches # ll -ltr
total 43110758
-rwxr-xr-x 1 root root 191 Feb 24 02:17 README.txt
-rw-r--r-- 1 root root 11467982139 Mar 20 22:40 oda-sm-19.10.0.0.0-210222.4-server1of2.zip
-rw-r--r-- 1 root root 9086866837 Mar 20 23:02 oda-sm-19.10.0.0.0-210222.4-server2of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
You have new mail in /var/spool/mail/root
2.2 Update the repository with the 2 files
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-repository -f /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
{
"jobId" : "ff6d6ad4-de02-432b-b62e-5986146a8eee",
"status" : "Created",
"message" : "/backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 11:55:02 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 11:55:02 AM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i ff6d6ad4-de02-432b-b62e-5986146a8eee
Job details
----------------------------------------------------------------
ID: ff6d6ad4-de02-432b-b62e-5986146a8eee
Description: Repository Update
Status: Running
Created: Jul 01, 2021 11:55:02 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Job details
----------------------------------------------------------------
ID: ff6d6ad4-de02-432b-b62e-5986146a8eee
Description: Repository Update
Status: Success
Created: Jul 01, 2021 11:55:02 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches #
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-repository -f /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
{
"jobId" : "e07fb8f3-e937-44b9-8934-7c1343b1b3ef",
"status" : "Created",
"message" : "/backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 11:59:48 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 11:59:48 AM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Job details
----------------------------------------------------------------
ID: e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Description: Repository Update
Status: Running
Created: Jul 01, 2021 11:59:48 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches # odacli describe-job -i e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Job details
----------------------------------------------------------------
ID: e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Description: Repository Update
Status: Success
Created: Jul 01, 2021 11:59:48 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Após a atualização do repositório, você pode remover os dois arquivos para economizar espaço.
3. Update the DCS admin
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.10.0.0.0
{
"jobId" : "03c4fb7f-5de6-425b-bb63-0663180ae488",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 12:04:50 PM CEST",
"resourceList" : [ ],
"description" : "DcsAdmin patching",
"updatedTime" : "Jul 01, 2021 12:04:50 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i 03c4fb7f-5de6-425b-bb63-0663180ae488
Job details
----------------------------------------------------------------
ID: 03c4fb7f-5de6-425b-bb63-0663180ae488
Description: DcsAdmin patching
Status: Success
Created: Jul 01, 2021 12:04:50 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation Jul 01, 2021 12:04:51 PM CEST Jul 01, 2021 12:04:51 PM CEST Success
dcsadmin upgrade Jul 01, 2021 12:04:51 PM CEST Jul 01, 2021 12:04:52 PM CEST Success
Update System version Jul 01, 2021 12:04:57 PM CEST Jul 01, 2021 12:04:57 PM CEST Success
4. Update the DCS components
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.10.0.0.0
{
"jobId" : "672e3572-db10-48ea-b737-ae075793c3bb",
"status" : "Success",
"message" : "Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL upgrade is successful. Timezone is set successfully. Metadata migration is successful. Agent rpm upgrade is successful. DCS-CLI rpm upgrade is successful. DCS-C",
"reports" : null,
"createTimestamp" : "Jul 01, 2021 12:07:17 PM CEST",
"description" : "Update-dcscomponents job completed and is not part of Agent job list",
"updatedTime" : "Jul 01, 2021 12:09:59 PM CEST"
}
root@oda-duts-01 /backups/patches #
O comando abaixo pode levar algum tempo, conforme especificado na documentação. Portanto, seja paciente e aguarde.
Este comando atualiza o Zookeeper, instala o MySQL, migra metadados do Derby para o MySQL e atualiza outros componentes DCS, como o DCS Agent, DCS CLI e DCS Controller no Oracle Database Appliance.
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.10.0.0.0
{
"jobId" : "71637667-3dea-4ac4-a2dd-5d9e7726874a",
"status" : "Created",
"message": "Dcs agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 12:12:01 PM CEST",
"resourceList" : [ ],
"description" : "DcsAgent patching",
"updatedTime" : "Jul 01, 2021 12:12:01 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
Job details
----------------------------------------------------------------
ID: 71637667-3dea-4ac4-a2dd-5d9e7726874a
Description: DcsAgent patching
Status: Running
Created: Jul 01, 2021 12:12:01 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcs-agent upgrade to version 19.10.0.0.0 Jul 01, 2021 12:12:01 PM CEST Jul 01, 2021 12:12:01 PM CEST Running
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
Job details
----------------------------------------------------------------
ID: 71637667-3dea-4ac4-a2dd-5d9e7726874a
Description: DcsAgent patching
Status: Success
Created: Jul 01, 2021 12:12:01 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcs-agent upgrade to version 19.10.0.0.0 Jul 01, 2021 12:12:01 PM CEST Jul 01, 2021 12:13:36 PM CEST Success
Update System version Jul 01, 2021 12:13:36 PM CEST Jul 01, 2021 12:13:36 PM CEST Success
6. Create a precheck report
Antes de atualizar o servidor, executamos as pré-verificações
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.10.0.0.0
Job details
----------------------------------------------------------------
ID: a3569c92-beef-46a6-b36d-d7d8c7fb6066
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: Created
Created: Jul 01, 2021 12:15:39 PM CEST
Message: Use 'odacli describe-prepatchreport -i a3569c92-beef-46a6-b36d-d7d8c7fb6066' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches # odacli describe-prepatchreport -i 9d93bb8b-9ede-4deb-9f2d-7c16a2d5abfa
Patch pre-check report
------------------------------------------------------------------------
Job ID: 9d93bb8b-9ede-4deb-9f2d-7c16a2d5abfa
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: FAILED
Created: Jul 01, 2021 1:11:54 PM CEST
Result: One or more pre-checks failed for [ORACHK]
Node Name
---------------
oda-duts-01
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__OS__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.10.0.0.0.
Is patch location available Success Patch location is available.
Verify OS patch Success Verified OS patch
Validate command execution Success Validated command execution
__ILOM__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.10.0.0.0.
Is patch location available Success Patch location is available.
Checking Ilom patch Version Success Successfully verified the versions
Patch location validation Success Successfully validated location
Validate command execution Success Validated command execution
__GI__
Validate supported GI versions Success Validated minimum supported versions.
Validate available space Success Validated free space under /u01
Is clusterware running Success Clusterware is running
Validate patching tag Success Validated patching tag: 19.10.0.0.0.
Is system provisioned Success Verified system is provisioned
Validate ASM in online Success ASM is online
Validate minimum agent version Success GI patching enabled in current
DCSAGENT version
Validate GI patch metadata Success Validated patching tag: 19.10.0.0.0.
Is patch location available Success Patch location is available.
Patch location validation Success Successfully validated location
Patch verification Success Patches 32218454 not applied on GI
home /u01/app/19.0.0.0/grid on node
oda-duts-01
Validate Opatch update Success Successfully updated the opatch in
GiHome /u01/app/19.0.0.0/grid on node
oda-duts-01
Patch conflict check Success No patch conflicts found on GiHome
/u01/app/19.0.0.0/grid on node
oda-duts-01
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Failed Orachk validation failed: .
Validate command execution Success Validated command execution
Verify the vm.min_free_kbytes Failed AHF-4819: The vm.min_free_kbytes
configuration configuration is not set as
recommended
Software home Failed Software home check failed
Nos resultado, podemos ver que existem um erro no oracheck. Com base no seguinte documento:
O Oracle informou que podemos ignorar os erros e, em seguida, continuar atualizando o servidor.
7. Apply the server update
Como ignoramos o erro, usamos a flag sko para o patch.
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-server -v 19.10.0.0.0 -sko
{
"jobId" : "59bbb6d2-bf6e-451a-8a4e-1de86c490d26",
"status" : "Created",
"message" : "Success of server update will trigger reboot of the node after 4-5 minutes. Please wait until the node reboots.",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 20:23:54 PM CEST",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "Jul 01, 2021 20:23:54 PM CEST"
}
root@oda-duts-01 ~ # odacli describe-job -i "59bbb6d2-bf6e-451a-8a4e-1de86c490d26"
Job details
----------------------------------------------------------------
ID: 59bbb6d2-bf6e-451a-8a4e-1de86c490d26
Description: Server Patching
Status: Success
Created: Jul 01, 2021 8:24:34 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation Jul 01, 2021 8:24:41 PM CEST Jul 01, 2021 8:24:41 PM CEST Success
dcs-controller upgrade Jul 01, 2021 8:24:42 PM CEST Jul 01, 2021 8:24:42 PM CEST Success
Creating repositories using yum Jul 01, 2021 8:24:43 PM CEST Jul 01, 2021 8:24:46 PM CEST Success
Updating YumPluginVersionLock rpm Jul 01, 2021 8:24:46 PM CEST Jul 01, 2021 8:24:46 PM CEST Success
Applying OS Patches Jul 01, 2021 8:24:46 PM CEST Jul 01, 2021 8:24:47 PM CEST Success
Creating repositories using yum Jul 01, 2021 8:24:47 PM CEST Jul 01, 2021 8:24:47 PM CEST Success
Applying HMP Patches Jul 01, 2021 8:24:47 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Client root Set up Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Client grid Set up Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Patch location validation Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
oda-hw-mgmt upgrade Jul 01, 2021 8:24:49 PM CEST Jul 01, 2021 8:24:49 PM CEST Success
OSS Patching Jul 01, 2021 8:24:50 PM CEST Jul 01, 2021 8:24:50 PM CEST Success
Applying Firmware Disk Patches Jul 01, 2021 8:24:50 PM CEST Jul 01, 2021 8:24:53 PM CEST Success
Applying Firmware Controller Patches Jul 01, 2021 8:24:53 PM CEST Jul 01, 2021 8:24:55 PM CEST Success
Checking Ilom patch Version Jul 01, 2021 8:24:55 PM CEST Jul 01, 2021 8:24:55 PM CEST Success
Patch location validation Jul 01, 2021 8:24:55 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Save password in Wallet Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Apply Ilom patch Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Copying Flash Bios to Temp location Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Starting the clusterware Jul 01, 2021 8:24:59 PM CEST Jul 01, 2021 8:24:59 PM CEST Success
clusterware patch verification Jul 01, 2021 8:24:59 PM CEST Jul 01, 2021 8:25:01 PM CEST Success
Patch location validation Jul 01, 2021 8:25:01 PM CEST Jul 01, 2021 8:25:01 PM CEST Success
Opatch update Jul 01, 2021 8:26:32 PM CEST Jul 01, 2021 8:26:36 PM CEST Success
Patch conflict check Jul 01, 2021 8:26:36 PM CEST Jul 01, 2021 8:27:29 PM CEST Success
clusterware upgrade Jul 01, 2021 8:27:34 PM CEST Jul 01, 2021 9:04:18 PM CEST Success
Updating GiHome version Jul 01, 2021 9:04:18 PM CEST Jul 01, 2021 9:04:21 PM CEST Success
Starting the clusterware Jul 01, 2021 9:05:25 PM CEST Jul 01, 2021 9:05:25 PM CEST Success
remove network public interface Jul 01, 2021 9:05:25 PM CEST Jul 01, 2021 9:05:28 PM CEST Success
create bridge network Jul 01, 2021 9:05:28 PM CEST Jul 01, 2021 9:05:33 PM CEST Success
modify network public interface Jul 01, 2021 9:05:33 PM CEST Jul 01, 2021 9:05:34 PM CEST Success
Update System version Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Cleanup JRE Home Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Add SYSNAME in Env Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Setting ACL for disk groups Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:38 PM CEST Success
preRebootNode Actions Jul 01, 2021 9:05:44 PM CEST Jul 01, 2021 9:06:30 PM CEST Success
Reboot Ilom Jul 01, 2021 9:06:30 PM CEST Jul 01, 2021 9:06:30 PM CEST Success
Podemos confirmar a atualização executando o seguinte comando
root@oda-duts-01 ~ # odacli describe-component
System Version
---------------
19.10.0.0.0
System node Name
---------------
oda-duts-01
Local System Version
---------------
19.10.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 19.10.0.0.0 up-to-date
GI 19.10.0.0.210119 up-to-date
DB 11.2.0.4.200414 11.2.0.4.210119
DCSAGENT 19.10.0.0.0 up-to-date
OS 7.9 up-to-date
ILOM 5.0.1.21.a.r138015 up-to-date
BIOS 41080800 up-to-date
FIRMWARECONTROLLER QDV1RF30 up-to-date
FIRMWAREDISK 0121 up-to-date
HMP 2.4.7.0.1 up-to-date
8. Update the existing dbhomes
root@oda-duts-01 ~ # odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
7c724f57-a495-4db9-a88a-48323f3632c6 OraDB11204_home1 11.2.0.4.200414 /u01/app/oracle/product/11.2.0.4/dbhome_1 CONFIGURED
root@oda-duts-01 ~ # odacli create-prepatchreport --dbhome --dbhomeid 7c724f57-a495-4db9-a88a-48323f3632c6 -v 19.10.0.0.0
root@oda-duts-01 ~ # odacli update-dbhome --dbhomeid 7c724f57-a495-4db9-a88a-48323f3632c6 -v 19.10.0.0.0 -sko
{
"jobId" : "cf0d4064-1eb2-4b9a-8653-41fe1f06f98a",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 21:26:05 PM CEST",
"resourceList" : [ ],
"description" : "DB Home Patching: Home Id is 7c724f57-a495-4db9-a88a-48323f3632c6",
"updatedTime" : "Jul 01, 2021 21:26:05 PM CEST"
}
root@oda-duts-01 ~ #
root@oda-duts-01 ~ #
root@oda-duts-01 ~ # odacli describe-job -i "cf0d4064-1eb2-4b9a-8653-41fe1f06f98a"
Job details
----------------------------------------------------------------
ID: cf0d4064-1eb2-4b9a-8653-41fe1f06f98a
Description: DB Home Patching: Home Id is 7c724f57-a495-4db9-a88a-48323f3632c6
Status: Success
Created: Jul 01, 2021 9:26:05 PM CEST
Message: Success
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
clusterware patch verification Jul 01, 2021 9:26:19 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Patch conflict check Jul 01, 2021 9:26:21 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Patch location validation Jul 01, 2021 9:26:21 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Opatch update Jul 01, 2021 9:27:13 PM CEST Jul 01, 2021 9:27:17 PM CEST Success
Patch conflict check Jul 01, 2021 9:27:17 PM CEST Jul 01, 2021 9:27:30 PM CEST Success
Creating wallet for DB Client Jul 01, 2021 9:27:58 PM CEST Jul 01, 2021 9:28:03 PM CEST Success
db upgrade Jul 01, 2021 9:28:03 PM CEST Jul 01, 2021 9:30:06 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:06 PM CEST Jul 01, 2021 9:30:07 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:07 PM CEST Jul 01, 2021 9:30:08 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:08 PM CEST Jul 01, 2021 9:30:09 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:09 PM CEST Jul 01, 2021 9:30:10 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:10 PM CEST Jul 01, 2021 9:30:11 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:11 PM CEST Jul 01, 2021 9:30:12 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:12 PM CEST Jul 01, 2021 9:30:13 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:13 PM CEST Jul 01, 2021 9:30:14 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:14 PM CEST Jul 01, 2021 9:30:15 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:15 PM CEST Jul 01, 2021 9:30:16 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:17 PM CEST Jul 01, 2021 9:30:18 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:18 PM CEST Jul 01, 2021 9:30:19 PM CEST Success
Update System version Jul 01, 2021 9:30:19 PM CEST Jul 01, 2021 9:30:19 PM CEST Success
updating the Database version Jul 01, 2021 9:30:21 PM CEST Jul 01, 2021 9:30:22 PM CEST Success
updating the Database version Jul 01, 2021 9:30:22 PM CEST Jul 01, 2021 9:30:24 PM CEST Success
updating the Database version Jul 01, 2021 9:30:24 PM CEST Jul 01, 2021 9:30:26 PM CEST Success
updating the Database version Jul 01, 2021 9:30:26 PM CEST Jul 01, 2021 9:30:28 PM CEST Success
updating the Database version Jul 01, 2021 9:30:28 PM CEST Jul 01, 2021 9:30:30 PM CEST Success
updating the Database version Jul 01, 2021 9:30:30 PM CEST Jul 01, 2021 9:30:32 PM CEST Success
updating the Database version Jul 01, 2021 9:30:32 PM CEST Jul 01, 2021 9:30:34 PM CEST Success
updating the Database version Jul 01, 2021 9:30:34 PM CEST Jul 01, 2021 9:30:36 PM CEST Success
updating the Database version Jul 01, 2021 9:30:36 PM CEST Jul 01, 2021 9:30:38 PM CEST Success
updating the Database version Jul 01, 2021 9:30:38 PM CEST Jul 01, 2021 9:30:40 PM CEST Success
updating the Database version Jul 01, 2021 9:30:40 PM CEST Jul 01, 2021 9:30:41 PM CEST Success
updating the Database version Jul 01, 2021 9:30:41 PM CEST Jul 01, 2021 9:30:43 PM CEST Success
You have new mail in /var/spool/mail/root
Agora que o patch foi bem-sucedido, podemos excluir o snapshot do oda.
root@oda-duts-01 ~ # /opt/odabr/odabr delsnap
INFO: 2021-07-01 21:33:02: Please check the logfile '/opt/odabr/out/log/odabr_48818.log' for more details
INFO: 2021-07-01 21:33:02: Removing LVM snapshots
INFO: 2021-07-01 21:33:02: ...removing LVM snapshot for 'opt'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'opt' removed successfully
INFO: 2021-07-01 21:33:03: ...removing LVM snapshot for 'u01'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'u01' removed successfully
INFO: 2021-07-01 21:33:03: ...removing LVM snapshot for 'root'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'root' removed successfully
SUCCESS: 2021-07-01 21:33:03: Remove LVM snapshots done successfully
root@oda-duts-01 ~ #
9. Update the repository com o RDBMS clone 19.10
A última etapa é atualizar o repositório com o clone RDBMS 19.10. Para isso, baixe o patch p23494997_1910000_Linux-x86-64.zip. E então descompacte o arquivo e execute o comando:
root@oda-duts-01 /backups/patches # odacli update-repository -f /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
{
"jobId" : "9e5124ef-670a-41a5-9135-4f1688cad2b7",
"status" : "Created",
"message" : "/backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 21:38:53 PM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 21:38:53 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i "9e5124ef-670a-41a5-9135-4f1688cad2b7"
Job details
----------------------------------------------------------------
ID: 9e5124ef-670a-41a5-9135-4f1688cad2b7
Description: Repository Update
Status: Running
Created: Jul 01, 2021 9:38:53 PM CEST
Message: /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle Jul 01, 2021 9:38:53 PM CEST Jul 01, 2021 9:38:53 PM CEST Running
root@oda-duts-01 /backups/patches # odacli describe-job -i "9e5124ef-670a-41a5-9135-4f1688cad2b7"
Job details
----------------------------------------------------------------
ID: 9e5124ef-670a-41a5-9135-4f1688cad2b7
Description: Repository Update
Status: Success
Created: Jul 01, 2021 9:38:53 PM CEST
Message: /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle Jul 01, 2021 9:38:53 PM CEST Jul 01, 2021 9:39:36 PM CEST Success
Espero que isso ajude você!!!
Fique ligado, acompanhando no twitter @aontalba e no Linkedin
