====== Patch ODA from 19.20 to 19.21 ======
This procedure includes ODA reimaging
\\
For the patch 19.20 to 19.21, there is OS upgrade from OL7 to OL8, the OS FS is wiped
This procedure will use the Data Preserving method.
The main steps will be
*** Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning**
- Download the Oracle Database Appliance Server Patch (patch 35938481)
- Unzip the software
- Update the repository with the server software
- Update DCS admin
- Update the DCS components
- Update the DCS agent
- Create the pre-upgrade report to run upgrade pre-checks
- Detach the system for an operating system upgrade
- Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance system
* **Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning**
- Download the Oracle Database Appliance release 19.21 bare metal ISO image and reimage the appliance (Patch 30403643)
- Plumb the network as described in the topic Plumbing the Network
- configure-firstnet.rsp ( in the zip file saved)
* **Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method**
- Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch (patch 35938481)
- Create the pre-patch report
- Apply the server update
- Run Prepatch report for the storage
- Update the storage components
- Update the storage components patch 30403673
- Restore Oracle Grid Infrastructure
- Restore the database
\\
=== Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning ===
* 1.1 Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 35938481)
* 1-2 Unzip the patch
[root@moros patch_1921]# unzip p35938481_1921000_Linux-x86-64.zip
Archive: p35938481_1921000_Linux-x86-64.zip
extracting: oda-sm-19.21.0.0.0-231220-server.zip
inflating: README.txt
[root@moros patch_1921]#
* 1.3 Update the repository with the server software file
[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip
{
"jobId" : "187e6c62-c356-4327-b7df-0a9e3d5f084e",
"status" : "Created",
"message" : "/u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip",
"reports" : [ ],
"createTimestamp" : "January 15, 2024 10:58:25 AM CET",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "January 15, 2024 10:58:25 AM CET",
"jobType" : null
}
[root@moros patch_1921]#
* Validate the job status
[root@moros patch_1921]# odacli describe-job -i "187e6c62-c356-4327-b7df-0a9e3d5f084e"
Job details
----------------------------------------------------------------
ID: 187e6c62-c356-4327-b7df-0a9e3d5f084e
Description: Repository Update
Status: Success
Created: January 15, 2024 10:58:25 AM CET
Message: /u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle January 15, 2024 10:58:25 AM CET January 15, 2024 10:58:58 AM CET Success
[root@moros patch_1921]#
* 1.4 Update DCS admin
[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.21.0.0.0
{
"jobId" : "f53559f1-8828-482a-8bb7-111e2b75377d",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 15, 2024 11:01:16 AM CET",
"resourceList" : [ ],
"description" : "DcsAdmin patching",
"updatedTime" : "January 15, 2024 11:01:16 AM CET",
"jobType" : null
}
[root@moros patch_1921]#
* Validate the job
[root@moros patch_1921]# odacli describe-job -i "f53559f1-8828-482a-8bb7-111e2b75377d"
Job details
----------------------------------------------------------------
ID: f53559f1-8828-482a-8bb7-111e2b75377d
Description: DcsAdmin patching
Status: Success
Created: January 15, 2024 11:01:16 AM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation January 15, 2024 11:01:16 AM CET January 15, 2024 11:01:16 AM CET Success
Dcs-admin upgrade January 15, 2024 11:01:16 AM CET January 15, 2024 11:01:22 AM CET Success
[root@moros patch_1921]#
* 1.5 Update the DCS components
[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.21.0.0.0
{
"jobId" : "9bffdad6-9af3-4c04-a697-2470c9e63d8e",
"status" : "Success",
"message" : " DCS-Agent shutdown is successful. Skipping MySQL upgrade on OL7 Metadata schema update is done. dcsagent RPM upgrade is successful. dcscli RPM upgrade is successful. dcscontroller RPM upgrade is successful. Successfully reset the Keystore password. HAMI is not enabled Skipped removing old Libs. Successfully ran setupAgentAuth.sh ",
"reports" : null,
"createTimestamp" : "January 15, 2024 11:04:22 AM CET",
"description" : "Update-dcscomponents job completed and is not part of Agent job list",
"updatedTime" : "January 15, 2024 11:05:30 AM CET"
}
[root@moros patch_1921]#
* 1.6 Update the DCS agent
[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.21.0.0.0
{
"jobId" : "4c5cbf22-0e70-4f80-acef-33f57eb542ff",
"status" : "Created",
"message" : "DCS agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands",
"reports" : [ ],
"createTimestamp" : "January 15, 2024 11:07:11 AM CET",
"resourceList" : [ ],
"description" : "DcsAgent patching",
"updatedTime" : "January 15, 2024 11:07:11 AM CET",
"jobType" : null
}
[root@moros patch_1921]#
* Validate the job
[root@moros patch_1921]# odacli describe-job -i "4c5cbf22-0e70-4f80-acef-33f57eb542ff"
Job details
----------------------------------------------------------------
ID: 4c5cbf22-0e70-4f80-acef-33f57eb542ff
Description: DcsAgent patching
Status: Success
Created: January 15, 2024 11:07:11 AM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Dcs-agent upgrade to version January 15, 2024 11:07:11 AM CET January 15, 2024 11:09:29 AM CET Success
19.21.0.0.0
Update System version January 15, 2024 11:09:29 AM CET January 15, 2024 11:09:29 AM CET Success
[root@moros patch_1921]#
* 1.7 Run upgrade pre-checks
[root@moros patch_1921]# odacli create-preupgradereport -bm
Job details
----------------------------------------------------------------
ID: 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
Description: Run pre-upgrade checks for Bare Metal
Status: Created
Created: January 15, 2024 11:12:22 AM CET
Message: Use 'odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
[root@moros patch_1921]#
* Check the report, any error should be corrected
[root@moros patch_1921]# odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
Upgrade pre-check report
------------------------------------------------------------------------
Job ID: 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
Description: Run pre-upgrade checks for Bare Metal
Status: SUCCESS
Created: January 15, 2024 11:12:22 AM CET
Result: All pre-checks succeeded
Node Name
---------------
moros
Check Status Message Action
------------------------------ -------- -------------------------------------- --------------------------------------
__GI__
Check presence of databases Success No additional database found None
not managed by ODA registered in CRS
Check custom filesystems Success All file systems are owned and used None
by OS users provisioned by ODA
Check presence of HAVIP Success No HAVIP resources found registered None
resources not managed by ODA in CRS
Check presence of export Success No EXPORT resources found registered None
resources not managed by ODA in CRS
__OS__
Check Required OS files Success All the required files are present None
Check Additional OS RPMs Alert Additional OS RPMs, compared to the None; the list of these RPMs can be
base ODA image, are installed on the found at
system '/opt/oracle/dcs/log/
reprovision-custom-rpms.list'. The
upgraded versions of these rpms will
have to be reinstalled manually after
reimage
__STORAGE__
Check Required Storage files Success All the required files are present None
Validate OAK Disks Success All OAK disks are in valid state None
Validate ASM Disk Groups Success All ASM disk groups are in valid state None
Validate ASM Disks Success All ASM disks are in valid state None
Check Database Home Storage Success The volume(s) orahome_sh,odabase_n0 None
volumes state is CONFIGURED.
Check space under /opt Success Free space on /opt: 68753.72 MB is None
more than required space: 1024 MB
Check space in ASM disk Success Space required for creating local None
group(s) homes is present in ACFS database
home storage. Required: 0 GB
Available: 74 GB
__SYS__
Validate Hardware Type Success Current hardware is supported None
Validate ILOM interconnect Success ILOM interconnect is not enabled None
Validate System Version Success System version 19.21.0.0.0 is None
supported
Verify System Timezone Success Succesfully verified the time zone None
file
Verify Grid User Success Grid user is verified None
Verify Grid Version Success Oracle Grid Infrastructure is running None
on the '19.20.0.0.230718' version on
all nodes
Check Audit Files Success Local Audit files not found None
__DB__
Validate Database Status Success Database 'REPOCDB' is running and is None
in 'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'REPOCDB' is supported
Validate Database Datapatch Success Database 'REPOCDB' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success Database 'REPOCDB' is not TDE None
enabled. Skipping TDE wallet presence
check.
Validate Database Home Success Database home location check passed None
location for database REPOCDB
Validate Database Status Success Database 'OKVCOE' is running and is None
in 'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'OKVCOE' is supported
Validate Database Datapatch Success Database 'OKVCOE' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success Database 'OKVCOE' is not TDE enabled. None
Skipping TDE wallet presence check.
Validate Database Home Success Database home location check passed None
location for database OKVCOE
Validate Database Status Success Database 'NOTDEOKV' is running and is None
in 'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'NOTDEOKV' is supported
Validate Database Datapatch Success Database 'NOTDEOKV' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success Database 'NOTDEOKV' is not TDE None
enabled. Skipping TDE wallet presence
check.
Validate Database Home Success Database home location check passed None
location for database NOTDEOKV
Validate Database Status Success Database 'TDEOKV' is running and is None
in 'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'TDEOKV' is supported
Validate Database Datapatch Success Database 'TDEOKV' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success TDE Wallet Management of database None
'TDEOKV' is ODA. Skipping TDE wallet
presence check.
Validate Database Home Success Database home location check passed None
location for database TDEOKV
Validate Database Status Success Database 'ONTDEOKV' is running and is None
in 'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'ONTDEOKV' is supported
Validate Database Datapatch Success Database 'ONTDEOKV' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success Database 'ONTDEOKV' is not TDE None
enabled. Skipping TDE wallet presence
check.
Validate Database Home Success Database home location check passed None
location for database ONTDEOKV
Validate Database Status Success Database 'MYTDE' is running and is in None
'CONFIGURED' state
Validate Database Version Success Version '19.20.0.0.230718' for None
database 'MYTDE' is supported
Validate Database Datapatch Success Database 'MYTDE' is completely None
Application Status applied with datapatch
Validate TDE wallet presence Success Database 'MYTDE' is not TDE enabled. None
Skipping TDE wallet presence check.
Validate Database Home Success Database home location check passed None
location for database MYTDE
__CERTIFICATES__
Check using custom Success Using Default key pair None
certificates
Check the agent of the DB Success All the agents of the DB systems are None
System accessible accessible
[root@moros patch_1921]#
* 1.8 detach the system for an operating system upgrade
[root@moros patch_1921]# odacli detach-node -all
********************************************************************************
IMPORTANT
********************************************************************************
'odacli detach-node' will bring down the databases and grid services on the
system. The files that belong to the databases, which are stored on ASM or ACFS,
are left intact on the storage. The databases will be started up back after
re-imaging the ODA system using 'odacli restore-node' commands. As a good
precautionary measure, please backup all the databases on the system before you
start this process. Do not store the backup on this ODA machine since the local
file system will be wiped out as part of the re-image.
********************************************************************************
Do you want to continue (yes/no)[no] : yes
{
"jobId" : "36428cf3-16a3-4ad2-aa2a-48d772c73eee",
"status" : "Created",
"message" : "On successful job completion, the server archive file will be generated at /opt/oracle/oak/restore/out. Please copy the server archive file outside of the ODA system before re-image",
"reports" : [ ],
"createTimestamp" : "January 15, 2024 11:23:11 AM CET",
"resourceList" : [ ],
"description" : "Detach node service creation for upgrade",
"updatedTime" : "January 15, 2024 11:23:11 AM CET",
"jobType" : null
}
[root@moros patch_1921]#
* Validate the job
[root@moros patch_1921]# odacli describe-job -i "36428cf3-16a3-4ad2-aa2a-48d772c73eee"
Job details
----------------------------------------------------------------
ID: 36428cf3-16a3-4ad2-aa2a-48d772c73eee
Description: Detach node service creation for upgrade
Status: Success
Created: January 15, 2024 11:23:11 AM CET
Message: On successful job completion, the server archive file will be generated at /opt/oracle/oak/restore/out. Please copy the server archive file outside of the ODA system before re-image
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Creating initialization file January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Creating firstnet response file January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Saving system information January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Saving Appliance data January 15, 2024 11:23:11 AM CET January 15, 2024 11:24:42 AM CET Success
Saving OS files January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Saving CPU cores information January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Saving storage files January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success
Saving Volumes January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:20 AM CET Success
Saving File Systems January 15, 2024 11:23:20 AM CET January 15, 2024 11:23:27 AM CET Success
Saving Quorum Disks January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:27 AM CET Success
Saving System January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:27 AM CET Success
Saving Networks January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:28 AM CET Success
Saving Database Storages January 15, 2024 11:23:28 AM CET January 15, 2024 11:24:12 AM CET Success
Saving Database Homes January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success
+-- Saving OraDB19000_home4 January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success
+-- Saving OraDB19000_home5 January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success
Saving Databases January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:42 AM CET Success
+-- Saving REPOCDB January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:17 AM CET Success
+-- Saving OKVCOE January 15, 2024 11:24:17 AM CET January 15, 2024 11:24:22 AM CET Success
+-- Saving NOTDEOKV January 15, 2024 11:24:22 AM CET January 15, 2024 11:24:27 AM CET Success
+-- Saving TDEOKV January 15, 2024 11:24:27 AM CET January 15, 2024 11:24:32 AM CET Success
+-- Saving ONTDEOKV January 15, 2024 11:24:32 AM CET January 15, 2024 11:24:37 AM CET Success
+-- Saving MYTDE January 15, 2024 11:24:37 AM CET January 15, 2024 11:24:42 AM CET Success
Saving Object swift stores January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Saving Database Backups January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Saving NFS Backups January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Saving Certificates and wallets Backup January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Saving KVM black-box resources January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Saving DB System Resources January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Creating databases version list January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success
Deconfiguring Appliance January 15, 2024 11:24:42 AM CET January 15, 2024 11:37:41 AM CET Success
Deconfiguring Databases January 15, 2024 11:24:42 AM CET January 15, 2024 11:31:40 AM CET Success
+-- Deconfiguring REPOCDB January 15, 2024 11:24:42 AM CET January 15, 2024 11:26:04 AM CET Success
+-- Deconfiguring OKVCOE January 15, 2024 11:26:04 AM CET January 15, 2024 11:27:12 AM CET Success
+-- Deconfiguring NOTDEOKV January 15, 2024 11:27:12 AM CET January 15, 2024 11:28:19 AM CET Success
+-- Deconfiguring TDEOKV January 15, 2024 11:28:19 AM CET January 15, 2024 11:29:27 AM CET Success
+-- Deconfiguring ONTDEOKV January 15, 2024 11:29:27 AM CET January 15, 2024 11:30:34 AM CET Success
+-- Deconfiguring MYTDE January 15, 2024 11:30:34 AM CET January 15, 2024 11:31:40 AM CET Success
Saving database backup reports January 15, 2024 11:31:40 AM CET January 15, 2024 11:31:40 AM CET Success
Resizing Quorum Disks January 15, 2024 11:31:40 AM CET January 15, 2024 11:31:40 AM CET Success
Deconfiguring Grid Infrastructure January 15, 2024 11:31:40 AM CET January 15, 2024 11:37:41 AM CET Success
Backup Quorum Disks January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:41 AM CET Success
Creating the server archive files January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:41 AM CET Success
Zipping the server archive files January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:42 AM CET Success
[root@moros patch_1921]#
* 1.9 Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance
[root@phanes out_oda_moros_patch]# ls
files serverarchive_moros.zip serverarchive_moros.zip.sha256
[root@phanes out_oda_moros_patch]#
=== Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning ===
* 2.1 Reimage
Do the reimage according the documentation
[[https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.21/daten/reimaging-oda.html#GUID-5D72EF11-BA2F-4EC7-B0C9-E5FCE6BFC901]]
* 2.2 Configure network
If you have noted your configuration network you will have to provided them. Otherwise in the archive file generated in Step 1.8, the configure-firstnet.rsp file will have all required information. Note that you should not change the network settings.
localhost login: root
Password:
Last login: Mon Jan 15 23:51:40 on tty1
[root@oak ~]# configure-firstnet
Select the Interface to configure the network on (btbond1 btbond3) [btbond1]:
Use LACP bonding on btbond1 (yes/no) [no]:
Configure DHCP on btbond1 (yes/no) [no]:
INFO: You have chosen Static configuration
Use VLAN on btbond1 (yes/no) [no]:
Enter the IP address to configure : 180.213.32.20
Enter the Netmask address to configure : 255.255.255.0
Enter the Gateway address to configure [180.213.32.1] : 180.213.32.200
INFO: Restarting the network
WARNING: Cannot ping the default gateway, please check the network information manually
[root@oak ~]#
* We can check the status of the components
[root@oak ~]# odacli describe-component
System Version
---------------
19.21.0.0.0
System node Name
---------------
oak
Local System Version
---------------
19.21.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK
19.21.0.0.0 up-to-date
DCSCONTROLLER
19.21.0.0.0 up-to-date
DCSCLI
19.21.0.0.0 up-to-date
DCSAGENT
19.21.0.0.0 up-to-date
DCSADMIN
19.21.0.0.0 up-to-date
OS
8.8 up-to-date
ILOM
5.1.1.23.r151750 5.1.3.20.r153596
BIOS
52100600 52110200
LOCAL CONTROLLER FIRMWARE
214.2.271.9 up-to-date
SHARED CONTROLLER FIRMWARE
VDV1RL06 up-to-date
LOCAL DISK FIRMWARE
D3MU001 up-to-date
HMP
2.4.9.1.601 up-to-date
[root@oak ~]#
=== Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method ===
* 3.1 Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch
[root@oak Download]# unzip p35938481_1921000_Linux-x86-64.zip
Archive: p35938481_1921000_Linux-x86-64.zip
extracting: oda-sm-19.21.0.0.0-231220-server.zip
inflating: README.txt
[root@oak Download]#
* Validate the job
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip
{
"jobId" : "d74fc503-3007-4774-bc63-3f938179d2a8",
"status" : "Created",
"message" : "/u01/Download/oda-sm-19.21.0.0.0-231220-server.zip",
"reports" : [ ],
"createTimestamp" : "January 16, 2024 16:53:35 PM UTC",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "January 16, 2024 16:53:35 PM UTC",
"jobType" : null
}
[root@oak Download]#
* Validate the job
[root@oak Download]# odacli describe-job -i "d74fc503-3007-4774-bc63-3f938179d2a8"
Job details
----------------------------------------------------------------
ID: d74fc503-3007-4774-bc63-3f938179d2a8
Description: Repository Update
Status: Success
Created: January 16, 2024 4:53:35 PM UTC
Message: /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Unzip bundle January 16, 2024 4:53:35 PM UTC January 16, 2024 4:54:00 PM UTC Success
[root@oak Download]#
* 3.2 Apply the Server Patch
* Run Prepatch Report
[root@oak Download]# odacli create-prepatchreport -s -v 19.21.0.0.0
Job details
----------------------------------------------------------------
ID: b3745161-b18f-48bd-8b79-1f2d8d46770e
Description: Patch pre-checks for [OS, ILOM, SERVER]
Status: Created
Created: January 16, 2024 5:03:22 PM UTC
Message: Use 'odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
[root@oak Download]#
* Validate the job
[root@oak Download]# odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e
Patch pre-check report
------------------------------------------------------------------------
Job ID: b3745161-b18f-48bd-8b79-1f2d8d46770e
Description: Patch pre-checks for [OS, ILOM, SERVER]
Status: SUCCESS
Created: January 16, 2024 5:03:22 PM UTC
Result: All pre-checks succeeded
Node Name
---------------
oak
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__OS__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.21.0.0.0.
Is patch location available Success Patch location is available.
Verify OS patch Success There are no packages available for
an update
Validate command execution Success Skipped command execution verfication
- Instance is not provisioned
__ILOM__
Validate ILOM server reachable Success Successfully connected with ILOM
server using public IP and USB
interconnect
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.21.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 Skipped command execution verfication
- Instance is not provisioned
__SERVER__
Validate local patching Success Successfully validated server local
patching
Validate command execution Success Skipped command execution verfication
- Instance is not provisioned
[root@oak Download]#
* 3.1.2 Apply the server patch
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-server -v 19.21.0.0.0
{
"jobId" : "808035e1-39b0-472a-b668-74beeada3cfa",
"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" : "January 16, 2024 17:05:38 PM UTC",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "January 16, 2024 17:05:38 PM UTC",
"jobType" : null
}
[root@oak Download]#
* Validate the job
[root@oak ~]# odacli describe-job -i "808035e1-39b0-472a-b668-74beeada3cfa"
Job details
----------------------------------------------------------------
ID: 808035e1-39b0-472a-b668-74beeada3cfa
Description: Server Patching
Status: Success
Created: January 16, 2024 5:05:38 PM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Validate ILOM server reachable January 16, 2024 5:05:39 PM UTC January 16, 2024 5:05:39 PM UTC Success
Stop DCS Admin January 16, 2024 5:05:41 PM UTC January 16, 2024 5:05:41 PM UTC Success
Generate mTLS certificates January 16, 2024 5:05:41 PM UTC January 16, 2024 5:05:43 PM UTC Success
Exporting Public Keys January 16, 2024 5:05:43 PM UTC January 16, 2024 5:05:44 PM UTC Success
Creating Trust Store January 16, 2024 5:05:44 PM UTC January 16, 2024 5:05:47 PM UTC Success
Update config files January 16, 2024 5:05:47 PM UTC January 16, 2024 5:05:47 PM UTC Success
Restart DCS Admin January 16, 2024 5:05:47 PM UTC January 16, 2024 5:06:08 PM UTC Success
Modify BM udev rules January 16, 2024 5:06:08 PM UTC January 16, 2024 5:06:28 PM UTC Success
Creating repositories using yum January 16, 2024 5:06:28 PM UTC January 16, 2024 5:06:32 PM UTC Success
Updating YumPluginVersionLock rpm January 16, 2024 5:06:32 PM UTC January 16, 2024 5:06:32 PM UTC Success
Applying OS Patches January 16, 2024 5:06:32 PM UTC January 16, 2024 5:06:36 PM UTC Success
Creating repositories using yum January 16, 2024 5:06:36 PM UTC January 16, 2024 5:06:37 PM UTC Success
Applying HMP Patches January 16, 2024 5:06:37 PM UTC January 16, 2024 5:06:39 PM UTC Success
Patch location validation January 16, 2024 5:06:39 PM UTC January 16, 2024 5:06:39 PM UTC Success
Oda-hw-mgmt upgrade January 16, 2024 5:06:39 PM UTC January 16, 2024 5:06:40 PM UTC Success
Applying Firmware Disk Patches January 16, 2024 5:06:40 PM UTC January 16, 2024 5:06:42 PM UTC Success
Applying Firmware Controller Patches January 16, 2024 5:06:42 PM UTC January 16, 2024 5:06:48 PM UTC Success
Checking Ilom patch Version January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:48 PM UTC Success
Patch location validation January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:48 PM UTC Success
Save password in Wallet January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:49 PM UTC Success
Disabling IPMI v2 January 16, 2024 5:06:49 PM UTC January 16, 2024 5:06:49 PM UTC Success
Apply Ilom patch January 16, 2024 5:06:49 PM UTC January 16, 2024 5:16:40 PM UTC Success
Copying Flash Bios to Temp location January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success
Update System version January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success
Cleanup JRE Home January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success
Generating and saving BOM January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:44 PM UTC Success
PreRebootNode Actions January 16, 2024 5:16:44 PM UTC January 16, 2024 5:16:44 PM UTC Success
Reboot Ilom January 16, 2024 5:16:44 PM UTC January 16, 2024 5:16:44 PM UTC Success
[root@oak ~]#
* Now the component status
[root@oak ~]# odacli describe-component
System Version
---------------
19.21.0.0.0
System node Name
---------------
oak
Local System Version
---------------
19.21.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK
19.21.0.0.0 up-to-date
DCSCONTROLLER
19.21.0.0.0 up-to-date
DCSCLI
19.21.0.0.0 up-to-date
DCSAGENT
19.21.0.0.0 up-to-date
DCSADMIN
19.21.0.0.0 up-to-date
OS
8.8 up-to-date
ILOM
5.1.3.20.r153596 up-to-date
BIOS
52110200 up-to-date
LOCAL CONTROLLER FIRMWARE
214.2.271.9 up-to-date
SHARED CONTROLLER FIRMWARE
VDV1RL06 up-to-date
LOCAL DISK FIRMWARE
D3MU001 up-to-date
HMP
2.4.9.1.601 up-to-date
[root@oak ~]#
* 3.3 Update the storage components
* Run prepatch storage report
[root@oak ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.21.0.0.0
Job details
----------------------------------------------------------------
ID: 2559a143-3c82-4dba-aee7-7be054767c87
Description: Patch pre-checks for [STORAGE]
Status: Created
Created: January 16, 2024 5:27:34 PM UTC
Message: Use 'odacli describe-prepatchreport -i 2559a143-3c82-4dba-aee7-7be054767c87' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
[root@oak ~]#
[root@oak ~]# odacli describe-prepatchreport -i 2559a143-3c82-4dba-aee7-7be054767c87
Patch pre-check report
------------------------------------------------------------------------
Job ID: 2559a143-3c82-4dba-aee7-7be054767c87
Description: Patch pre-checks for [STORAGE]
Status: SUCCESS
Created: January 16, 2024 5:27:34 PM UTC
Result: All pre-checks succeeded
Node Name
---------------
oak
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__STORAGE__
Validate patching tag Success Validated patching tag: 19.21.0.0.0.
Patch location validation Success Verified patch location
Patch tag validation Success Verified patch tag
Storage patch tag validation Success Verified storage patch location
Verify ASM disks status Success Skipped ASM disks status verification
- Instance is not provisioned
Validate command execution Success Skipped command execution verfication
- Instance is not provisioned
[root@oak ~]#
* Patch the storage
[root@oak ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.21.0.0.0
{
"jobId" : "3b3ec526-da19-4a86-bf59-80e029fe7bd6",
"status" : "Created",
"message" : "Success of Storage Update may trigger reboot of node after 4-5 minutes. Please wait till node restart",
"reports" : [ ],
"createTimestamp" : "January 16, 2024 17:28:58 PM UTC",
"resourceList" : [ ],
"description" : "Storage Firmware Patching",
"updatedTime" : "January 16, 2024 17:28:58 PM UTC",
"jobType" : null
}
[root@oak ~]#
[root@oak ~]# odacli describe-job -i "3b3ec526-da19-4a86-bf59-80e029fe7bd6"
Job details
----------------------------------------------------------------
ID: 3b3ec526-da19-4a86-bf59-80e029fe7bd6
Description: Storage Firmware Patching
Status: Success
Created: January 16, 2024 5:28:58 PM UTC
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Applying Firmware Disk Patches January 16, 2024 5:29:01 PM UTC January 16, 2024 5:29:04 PM UTC Success
Generating and saving BOM January 16, 2024 5:29:04 PM UTC January 16, 2024 5:29:08 PM UTC Success
PreRebootNode Actions January 16, 2024 5:29:08 PM UTC January 16, 2024 5:29:08 PM UTC Success
Reboot Ilom January 16, 2024 5:29:08 PM UTC January 16, 2024 5:29:08 PM UTC Success
[root@oak ~]#
* 3.4 Update the repository with the 19.21 Oracle Grid Infrastructure : p30403673_1921000_Linux-x86-64.zip
[root@oak Download]# unzip p30403673_1921000_Linux-x86-64.zip
Archive: p30403673_1921000_Linux-x86-64.zip
extracting: odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip
inflating: README.txt
[root@oak Download]#
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip
{
"jobId" : "a706c404-a833-4ef4-858f-fc7e82af7f2b",
"status" : "Created",
"message" : "/u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip",
"reports" : [ ],
"createTimestamp" : "January 16, 2024 17:42:28 PM UTC",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "January 16, 2024 17:42:28 PM UTC",
"jobType" : null
}
[root@oak Download]#
[root@oak Download]# odacli describe-job -i "a706c404-a833-4ef4-858f-fc7e82af7f2b"
Job details
----------------------------------------------------------------
ID: a706c404-a833-4ef4-858f-fc7e82af7f2b
Description: Repository Update
Status: Success
Created: January 16, 2024 5:42:28 PM UTC
Message: /u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Unzip bundle January 16, 2024 5:42:28 PM UTC January 16, 2024 5:42:59 PM UTC Success
[root@oak Download]#
* 3.5 Update the repository with the server data archive files generated in Step 1
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/serverarchive_moros.zip
{
"jobId" : "5ed8951a-d178-45ef-8627-61bf72235564",
"status" : "Created",
"message" : "/u01/Download/serverarchive_moros.zip",
"reports" : [ ],
"createTimestamp" : "January 16, 2024 17:47:30 PM UTC",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "January 16, 2024 17:47:30 PM UTC",
"jobType" : null
}
[root@oak Download]#
[root@oak Download]# odacli describe-job -i "5ed8951a-d178-45ef-8627-61bf72235564"
Job details
----------------------------------------------------------------
ID: 5ed8951a-d178-45ef-8627-61bf72235564
Description: Repository Update
Status: Success
Created: January 16, 2024 5:47:30 PM UTC
Message: /u01/Download/serverarchive_moros.zip
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Unzip bundle January 16, 2024 5:47:30 PM UTC January 16, 2024 5:47:30 PM UTC Success
[root@oak Download]#
* 3.6 Restore Oracle Grid Infrastructure
[root@oak Download]# odacli restore-node -g
Enter New system password:
Retype New system password:
Enter an initial password for Web Console account (oda-admin):
Retype the password for Web Console account (oda-admin):
User 'oda-admin' created successfully...
{
"jobId" : "1a8d5eb8-433c-4bec-aa9b-c6fab96373c5",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 16, 2024 17:53:47 PM UTC",
"resourceList" : [ ],
"description" : "Restore node service - GI",
"updatedTime" : "January 16, 2024 17:53:47 PM UTC",
"jobType" : null
}
[root@oak Download]#
[root@moros ~]# odacli describe-job -i "1a8d5eb8-433c-4bec-aa9b-c6fab96373c5"
Job details
----------------------------------------------------------------
ID: 1a8d5eb8-433c-4bec-aa9b-c6fab96373c5
Description: Restore node service - GI
Status: Success
Created: January 16, 2024 4:53:47 PM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Restore node service creation January 16, 2024 4:53:55 PM CET January 16, 2024 5:19:28 PM CET Success
Setting up Network January 16, 2024 4:53:58 PM CET January 16, 2024 4:53:58 PM CET Success
Setting up Vlan January 16, 2024 4:54:31 PM CET January 16, 2024 4:54:33 PM CET Success
Setting up Network January 16, 2024 4:55:07 PM CET January 16, 2024 4:55:07 PM CET Success
Network update January 16, 2024 4:55:43 PM CET January 16, 2024 4:56:14 PM CET Success
Updating network January 16, 2024 4:55:43 PM CET January 16, 2024 4:56:14 PM CET Success
Setting up Network January 16, 2024 4:55:43 PM CET January 16, 2024 4:55:43 PM CET Success
OS usergroup 'asmdba' creation January 16, 2024 4:56:14 PM CET January 16, 2024 4:56:15 PM CET Success
OS usergroup 'asmoper' creation January 16, 2024 4:56:15 PM CET January 16, 2024 4:56:15 PM CET Success
OS usergroup 'asmadmin' creation January 16, 2024 4:56:15 PM CET January 16, 2024 4:56:16 PM CET Success
OS usergroup 'dba' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success
OS usergroup 'dbaoper' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success
OS usergroup 'oinstall' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success
OS user 'oracle' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:17 PM CET Success
Default backup policy creation January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success
Backup Config name validation January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success
Backup config metadata persist January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success
Grant permission to RHP files January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:18 PM CET Success
Add SYSNAME in Env January 16, 2024 4:56:18 PM CET January 16, 2024 4:56:18 PM CET Success
Install oracle-ahf January 16, 2024 4:56:18 PM CET January 16, 2024 4:59:13 PM CET Success
Stop DCS Admin January 16, 2024 4:59:55 PM CET January 16, 2024 4:59:55 PM CET Success
Generate mTLS certificates January 16, 2024 4:59:55 PM CET January 16, 2024 4:59:57 PM CET Success
Exporting Public Keys January 16, 2024 4:59:57 PM CET January 16, 2024 4:59:58 PM CET Success
Creating Trust Store January 16, 2024 4:59:58 PM CET January 16, 2024 5:00:02 PM CET Success
Update config files January 16, 2024 5:00:02 PM CET January 16, 2024 5:00:02 PM CET Success
Restart DCS Admin January 16, 2024 5:00:02 PM CET January 16, 2024 5:00:23 PM CET Success
Unzipping storage configuration files January 16, 2024 5:00:23 PM CET January 16, 2024 5:00:23 PM CET Success
Reloading multipath devices January 16, 2024 5:00:23 PM CET January 16, 2024 5:00:24 PM CET Success
Restart oakd January 16, 2024 5:00:24 PM CET January 16, 2024 5:00:35 PM CET Success
Restart oakd January 16, 2024 5:01:46 PM CET January 16, 2024 5:01:56 PM CET Success
Restore Quorum Disks January 16, 2024 5:01:56 PM CET January 16, 2024 5:01:56 PM CET Success
Creating GI home directories January 16, 2024 5:01:56 PM CET January 16, 2024 5:01:56 PM CET Success
Extract GI clone January 16, 2024 5:01:56 PM CET January 16, 2024 5:03:00 PM CET Success
Creating wallet for Root User January 16, 2024 5:03:02 PM CET January 16, 2024 5:03:06 PM CET Success
Creating wallet for ASM Client January 16, 2024 5:03:06 PM CET January 16, 2024 5:03:11 PM CET Success
Grid stack creation January 16, 2024 5:03:12 PM CET January 16, 2024 5:15:29 PM CET Success
GI Restore with RHP January 16, 2024 5:03:12 PM CET January 16, 2024 5:12:03 PM CET Success
Updating GIHome version January 16, 2024 5:12:04 PM CET January 16, 2024 5:12:08 PM CET Success
Post cluster OAKD configuration January 16, 2024 5:15:29 PM CET January 16, 2024 5:16:26 PM CET Success
Mounting disk group DATA January 16, 2024 5:16:26 PM CET January 16, 2024 5:16:27 PM CET Success
Mounting disk group RECO January 16, 2024 5:16:35 PM CET January 16, 2024 5:16:43 PM CET Success
Setting ACL for disk groups January 16, 2024 5:16:50 PM CET January 16, 2024 5:16:53 PM CET Success
Register Scan and Vips to Public Network January 16, 2024 5:16:53 PM CET January 16, 2024 5:16:55 PM CET Success
Adding Volume ORAHOME_SH to Clusterware January 16, 2024 5:17:24 PM CET January 16, 2024 5:17:27 PM CET Success
Adding Volume COMMONSTORE to Clusterware January 16, 2024 5:17:27 PM CET January 16, 2024 5:17:30 PM CET Success
Adding Volume ACFSCLONE to Clusterware January 16, 2024 5:17:30 PM CET January 16, 2024 5:17:33 PM CET Success
Adding Volume ODABASE_N0 to Clusterware January 16, 2024 5:17:33 PM CET January 16, 2024 5:17:36 PM CET Success
Enabling Volume(s) January 16, 2024 5:17:36 PM CET January 16, 2024 5:18:28 PM CET Success
Discover ACFS clones config January 16, 2024 5:19:11 PM CET January 16, 2024 5:19:21 PM CET Success
Configure export clones resource January 16, 2024 5:19:20 PM CET January 16, 2024 5:19:21 PM CET Success
Discover DbHomes ACFS config January 16, 2024 5:19:21 PM CET January 16, 2024 5:19:25 PM CET Success
Discover OraHomeStorage volumes January 16, 2024 5:19:21 PM CET January 16, 2024 5:19:25 PM CET Success
Provisioning service creation January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success
Persist new agent state entry January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success
Persist new agent state entry January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success
Restart DCS Agent January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:28 PM CET Success
[root@moros ~]#
* 3.7 Restore the database
[root@moros ~]# odacli restore-node -d
{
"jobId" : "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 16, 2024 19:24:08 PM CET",
"resourceList" : [ ],
"description" : "Restore node service - DB",
"updatedTime" : "January 16, 2024 19:24:08 PM CET",
"jobType" : null
}
[root@moros ~]#
* The first time we got some errors due to wallet not saved before the reimage
[root@moros ~]# odacli describe-job -i "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98"
Job details
----------------------------------------------------------------
ID: 3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98
Description: Restore node service - DB
Status: Failure (To view Error Correlation report, run "odacli describe-job -i 3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98 --ecr" command)
Created: January 16, 2024 7:24:08 PM CET
Message: DCS-10001:Internal error encountered: Failed to get pfile from spfile - ERROR:
ORA-12578: TNS:wallet open failed
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus.
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Restore node service creation January 16, 2024 7:24:11 PM CET January 16, 2024 7:25:09 PM CET Failure
Restore node service creation January 16, 2024 7:24:11 PM CET January 16, 2024 7:25:09 PM CET Failure
Setting up SSH equivalence for 'oracle' January 16, 2024 7:24:11 PM CET January 16, 2024 7:24:12 PM CET Success
Restore BM CPU Pools January 16, 2024 7:24:12 PM CET January 16, 2024 7:24:12 PM CET Success
Register DB home: OraDB19000_home5 January 16, 2024 7:24:12 PM CET January 16, 2024 7:24:38 PM CET Success
Register DB home: OraDB19000_home4 January 16, 2024 7:24:38 PM CET January 16, 2024 7:25:06 PM CET Success
Persist database storage locations January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for OKVCOE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for ONTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for NOTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for MYTDE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for REPOCDB January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Persist database storages January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for OKVCOE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for ONTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for NOTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for MYTDE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Save metadata for REPOCDB January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success
Restore node service creation January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Failure
Restore database: TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Failure
+-- Adding database to GI January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Success
+-- Adding database instance(s) to GI January 16, 2024 7:25:09 PM CET January 16, 2024 7:25:09 PM CET Success
+-- Modifying SPFILE for database January 16, 2024 7:25:09 PM CET January 16, 2024 7:25:09 PM CET Failure
* I then decide to restore only database without wallet
[root@moros restore]# odacli restore-node -d
{
"jobId" : "92406b7e-9803-4cb6-a0b6-b1ba749acd00",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 16, 2024 23:21:14 PM CET",
"resourceList" : [ ],
"description" : "Restore node service - DB",
"updatedTime" : "January 16, 2024 23:21:14 PM CET",
"jobType" : null
}
* And the job went fine
[root@moros restore]# odacli describe-job -i "92406b7e-9803-4cb6-a0b6-b1ba749acd00"
Job details
----------------------------------------------------------------
ID: 92406b7e-9803-4cb6-a0b6-b1ba749acd00
Description: Restore node service - DB
Status: Success
Created: January 16, 2024 11:21:14 PM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Setting up SSH equivalence for 'oracle' January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
Restore BM CPU Pools January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
DB home creation: OraDB19000_home5 January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Skipped
DB home creation: OraDB19000_home4 January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Skipped
Persist database storage locations January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
Save metadata for REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
Persist database storages January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
Save metadata for REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success
Restore database: REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:23:18 PM CET Success
+-- Adding database to GI January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:17 PM CET Success
+-- Adding database instance(s) to GI January 16, 2024 11:21:17 PM CET January 16, 2024 11:21:17 PM CET Success
+-- Modifying SPFILE for database January 16, 2024 11:21:17 PM CET January 16, 2024 11:22:12 PM CET Success
+-- Restore password file for database January 16, 2024 11:22:12 PM CET January 16, 2024 11:22:12 PM CET Skipped
+-- Start instance(s) for database January 16, 2024 11:22:12 PM CET January 16, 2024 11:22:51 PM CET Success
+-- Persist metadata for database January 16, 2024 11:22:51 PM CET January 16, 2024 11:22:51 PM CET Success
+-- Create adrci directory January 16, 2024 11:22:51 PM CET January 16, 2024 11:22:51 PM CET Success
+-- Run SqlPatch January 16, 2024 11:22:51 PM CET January 16, 2024 11:23:18 PM CET Success
Restore Object Stores January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success
Remount NFS backups January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success
Restore BackupConfigs January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success
Reattach backupconfigs to DBs January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success
Restore backup reports January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success
[root@moros restore]#
[root@moros app]# odacli describe-component
System Version
---------------
19.21.0.0.0
System node Name
---------------
moros
Local System Version
---------------
19.21.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK
19.21.0.0.0 up-to-date
GI
19.21.0.0.231017 up-to-date
DB {
[OraDB19000_home5]
19.20.0.0.230718 19.21.0.0.231017
[OraDB19000_home4 [REPOCDB]]
19.20.0.0.230718 19.21.0.0.231017
}
DCSCONTROLLER
19.21.0.0.0 up-to-date
DCSCLI
19.21.0.0.0 up-to-date
DCSAGENT
19.21.0.0.0 up-to-date
DCSADMIN
19.21.0.0.0 up-to-date
OS
8.8 up-to-date
ILOM
5.1.3.20.r153596 up-to-date
BIOS
52110200 up-to-date
LOCAL CONTROLLER FIRMWARE
214.2.271.9 up-to-date
SHARED CONTROLLER FIRMWARE
VDV1RL06 up-to-date
LOCAL DISK FIRMWARE
D3MU001 up-to-date
HMP
2.4.9.1.601 up-to-date
[root@moros app]#
=== Step 4 : Update Existing dbhomes ===
* 4.1 Update Repository
[root@moros ~]# odacli update-repository -f /u01/Download/odacli-dcs-19.21.0.0.0-231211-DB-19.21.0.0.zip
[root@moros ~]# odacli describe-job -i 5362ce43-6ccb-4ea9-b05d-df5a3e791a71
Job details
----------------------------------------------------------------
ID: 5362ce43-6ccb-4ea9-b05d-df5a3e791a71
Description: Repository Update
Status: Success
Created: January 17, 2024 1:09:10 AM CET
Message: /u01/Download/odacli-dcs-19.21.0.0.0-231211-DB-19.21.0.0.zip
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Unzip bundle January 17, 2024 1:09:11 AM CET January 17, 2024 1:09:43 AM CET Success
[root@moros ~]#
* 4.2 List databases
[root@moros ~]# odacli list-dbhomes
ID Name DB Version DB Edition Home Location Status
---------------------------------------- -------------------- ------------------------------ ---------- ------------------------------------------------------- ----------
b81b51d5-f407-4ca1-80d6-46f426d12d1f OraDB19000_home5 19.20.0.0.230718 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5 CONFIGURED
1cbf6d6f-47f9-4a83-8055-36c6212a1ebe OraDB19000_home4 19.20.0.0.230718 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_4 CONFIGURED
[root@moros ~]#
4.3 Run Prepatch report
[root@moros ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0
Job details
----------------------------------------------------------------
ID: a397dc6a-9bac-432a-a676-2206133c8122
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home4
Status: Created
Created: January 30, 2024 11:06:44 AM CET
Message: Use 'odacli describe-prepatchreport -i a397dc6a-9bac-432a-a676-2206133c8122' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
[root@moros ~]#
[root@moros ~]# odacli describe-prepatchreport -i a397dc6a-9bac-432a-a676-2206133c8122
Patch pre-check report
------------------------------------------------------------------------
Job ID: a397dc6a-9bac-432a-a676-2206133c8122
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home4
Status: SUCCESS
Created: January 30, 2024 11:06:44 AM CET
Result: All pre-checks succeeded
Node Name
---------------
moros
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
1cbf6d6f-47f9-4a83-8055-36c6212a1ebe
Validate patching tag Success Validated patching tag: 19.21.0.0.0.
Is system provisioned Success Verified system is provisioned
Validate minimum agent version Success Validated minimum agent version
Is GI upgraded Success Validated GI is upgraded
Validate available space for Success Validated free space required under
db /u01
Validate dbHomesOnACFS Success User has configured disk group for
configured Database homes on ACFS
Validate Oracle base Success Successfully validated Oracle Base
Is DB clone available Success Successfully validated clone file
exists
Evaluate DBHome patching with Success Successfully validated updating
RHP dbhome with RHP. and local patching
is possible
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Success Successfully ran Orachk
Validate command execution Success Validated command execution
* 4.4 Patch the dbhomes
[root@moros ~]# /opt/oracle/dcs/bin/odacli update-dbhome --id 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0
{
"jobId" : "b38e8ed2-f1d6-4c82-be52-554e9cb6e116",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 30, 2024 11:21:24 AM CET",
"resourceList" : [ ],
"description" : "DB Home Patching: Home ID is 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe",
"updatedTime" : "January 30, 2024 11:21:24 AM CET",
"jobType" : null
}
[root@moros ~]#
[root@moros ~]# odacli describe-job -i "b38e8ed2-f1d6-4c82-be52-554e9cb6e116"
Job details
----------------------------------------------------------------
ID: b38e8ed2-f1d6-4c82-be52-554e9cb6e116
Description: DB Home Patching: Home ID is 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe
Status: Success
Created: January 30, 2024 11:21:24 AM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------
Creating wallet for DB Client January 30, 2024 11:22:20 AM CET January 30, 2024 11:22:20 AM CET Success
Patch databases by RHP - [SITNECDB] January 30, 2024 11:22:20 AM CET January 30, 2024 11:25:03 AM CET Success
Updating database metadata January 30, 2024 11:25:03 AM CET January 30, 2024 11:25:03 AM CET Success
Set log_archive_dest for Database January 30, 2024 11:25:03 AM CET January 30, 2024 11:25:07 AM CET Success
Patch databases by RHP - [REPOCDB] January 30, 2024 11:25:07 AM CET January 30, 2024 11:30:54 AM CET Success
Updating database metadata January 30, 2024 11:30:54 AM CET January 30, 2024 11:30:54 AM CET Success
Set log_archive_dest for Database January 30, 2024 11:30:54 AM CET January 30, 2024 11:30:57 AM CET Success
Set target_pdbs parameter January 30, 2024 11:30:57 AM CET January 30, 2024 11:32:22 AM CET Success
Patch databases by RHP - [C1COE02] January 30, 2024 11:32:22 AM CET January 30, 2024 11:34:15 AM CET Success
Updating database metadata January 30, 2024 11:34:15 AM CET January 30, 2024 11:34:15 AM CET Success
Set log_archive_dest for Database January 30, 2024 11:34:15 AM CET January 30, 2024 11:34:19 AM CET Success
Patch databases by RHP - [C1COE01] January 30, 2024 11:34:19 AM CET January 30, 2024 11:36:15 AM CET Success
Updating database metadata January 30, 2024 11:36:15 AM CET January 30, 2024 11:36:15 AM CET Success
Set log_archive_dest for Database January 30, 2024 11:36:15 AM CET January 30, 2024 11:36:19 AM CET Success
Update System version January 30, 2024 11:36:19 AM CET January 30, 2024 11:36:19 AM CET Success
Generating and saving BOM January 30, 2024 11:36:19 AM CET January 30, 2024 11:37:22 AM CET Success
TDE parameter update January 30, 2024 11:38:37 AM CET January 30, 2024 11:38:37 AM CET Success