Introduction
While patching ODAs from 19.10 to 19.13, the update-dbhome could fail if some databases inside this dbhome are stopped or only mounted. Job would then stop with a DCS-10001:Internal error encountered: PRGH-1153 : RHPHelper call to get runing nodes failed for DB: “ARITSTDB”.
How to solve this problem?
Environment description
My environment is composed of 3 X8-2M ODAs, 2 are dedicated for production with Data Guard, and 1 for test and development databases. Initialy deployed with 19.6, the goal was to patch to the latest 19.13. An intermediate patch was needed, so these ODAs will first be patched to 19.10 before applying 19.13 straight after.
Patching from 19.6 to 19.10 was fine, but patching the only 19c dbhome to 19.13 was not. Job raised an error:
odacli describe-job -i 087d618c-714c-463f-a1e8-7efcba0541fc
Job details
----------------------------------------------------------------
ID: 087d618c-714c-463f-a1e8-7efcba0541fc
Description: DB Home Patching: Home Id is 38c08a67-2730-4b76-92aa-4a47840082c5
Status: Failure
Created: February 23, 2022 6:02:42 PM CET
Message: DCS-10001:Internal error encountered: PRGH-1153 : RHPHelper call to get runing nodes failed for DB: "ARITSTDB"..
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
DB Home Patching February 23, 2022 6:03:02 PM CET February 23, 2022 7:02:53 PM CET Failure
DB Home Patching February 23, 2022 6:03:03 PM CET February 23, 2022 7:02:53 PM CET Failure
Adding USER SSH_EQUIVALENCE February 23, 2022 6:03:03 PM CET February 23, 2022 6:03:03 PM CET Success
Adding USER SSH_EQUIVALENCE February 23, 2022 6:03:03 PM CET February 23, 2022 6:03:04 PM CET Success
task:TaskSequential_2030 February 23, 2022 6:03:04 PM CET February 23, 2022 7:01:55 PM CET Failure
Creating wallet for DB Client February 23, 2022 6:03:43 PM CET February 23, 2022 6:03:43 PM CET Success
Patch databases by RHP February 23, 2022 6:03:43 PM CET February 23, 2022 6:11:03 PM CET Success
updating database metadata February 23, 2022 6:11:56 PM CET February 23, 2022 6:11:56 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:11:56 PM CET February 23, 2022 6:12:01 PM CET Success
Patch databases by RHP February 23, 2022 6:12:01 PM CET February 23, 2022 6:19:10 PM CET Success
updating database metadata February 23, 2022 6:20:03 PM CET February 23, 2022 6:20:03 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:20:03 PM CET February 23, 2022 6:20:08 PM CET Success
Patch databases by RHP February 23, 2022 6:20:08 PM CET February 23, 2022 6:25:26 PM CET Success
updating database metadata February 23, 2022 6:26:21 PM CET February 23, 2022 6:26:21 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:26:21 PM CET February 23, 2022 6:26:26 PM CET Success
Patch databases by RHP February 23, 2022 6:26:26 PM CET February 23, 2022 6:31:54 PM CET Success
updating database metadata February 23, 2022 6:32:49 PM CET February 23, 2022 6:32:49 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:32:49 PM CET February 23, 2022 6:32:53 PM CET Success
Patch databases by RHP February 23, 2022 6:32:53 PM CET February 23, 2022 6:38:09 PM CET Success
updating database metadata February 23, 2022 6:39:02 PM CET February 23, 2022 6:39:03 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:39:03 PM CET February 23, 2022 6:39:07 PM CET Success
Patch databases by RHP February 23, 2022 6:39:07 PM CET February 23, 2022 6:44:02 PM CET Success
updating database metadata February 23, 2022 6:44:58 PM CET February 23, 2022 6:44:58 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:44:58 PM CET February 23, 2022 6:45:03 PM CET Success
Patch databases by RHP February 23, 2022 6:45:03 PM CET February 23, 2022 6:51:55 PM CET Success
updating database metadata February 23, 2022 6:52:48 PM CET February 23, 2022 6:52:48 PM CET Success
Set log_archive_dest for Database February 23, 2022 6:52:48 PM CET February 23, 2022 6:52:52 PM CET Success
Patch databases by RHP February 23, 2022 6:52:52 PM CET February 23, 2022 7:00:09 PM CET Success
updating database metadata February 23, 2022 7:01:05 PM CET February 23, 2022 7:01:05 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:01:05 PM CET February 23, 2022 7:01:10 PM CET Success
Patch databases by RHP February 23, 2022 7:01:10 PM CET February 23, 2022 7:01:55 PM CET Failure
Status of databases after patching
Failure didn’t happen immediately, part of the job should have been done. Let’s check databases and version associated:
odacli list-databases
ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
6e26f06c-ee16-46f2-986e-0d82602fe93a GOTTSTDB SI 19.13.0.0.211019 false OLTP odb1 ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
17c84065-9bb9-4548-bf72-d0a02ad2213f PATSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
f34eddac-7794-47cd-9d6a-08aa3b2f90b7 PATSITDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
185bc4bf-492e-4b98-9440-b24c2864f572 PATCIDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
d0657336-b416-40d7-929f-8a9fe604e908 M4CTSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9681f86e-88b9-468f-93c6-9b2db76bede1 MINDEVDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
a5e4f009-942a-488c-9097-6e34e6b858dd MINTSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
62416912-551b-44cb-a23d-8f60ca7d8a37 REGNTTST SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
af37407a-f340-43b2-bb41-7f7e1143c703 LOGMTST SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
6ce0e7a6-7560-4b2a-b992-cf6cca7500f0 WNTVSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9bebb050-8090-444f-bbc7-7dcfb4bc68a1 BQ3 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
d7da5dba-03d5-4cbd-ba7f-00aaea97c55c POQ SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
7e396dee-e4b3-4d84-8a4e-e42b4de69884 OQ1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
64c248c3-aaf9-4a89-a672-f6e60e20e2aa SQ1 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
69b805d8-db8c-4240-aadc-e267b5c6f020 SQ2 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
76562430-5554-4876-967f-58bcb81e2818 OD1 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
4c50b2d6-0e4f-47d6-a278-5ee6bd4635d4 BD3 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9c5bac01-e9a6-4345-8076-4b647fb0457e SD1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
b051e5be-92c1-4d85-9060-7a36bf4befd6 POD SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
efd34b41-cbda-4785-9cda-e08450203619 SD2 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
4c679720-c577-4934-ab56-67d421538366 ARITSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
A few databases have been migrated to the new 19.13 dhbome, then job stopped after ARITSTDB database. Actually, ARITSTDB is a decommissioned database, still existing on my ODA. On one of the other ODA, behaviour was the same, but for another reason: databases were mostly standbys. So this part of the patch is not continuing after trying on a database not in read/write mode.
Retry to apply the patch on the dbhome
Let’s retry the patch to see if it can continue:
odacli update-dbhome -i 38c08a67-2730-4b76-92aa-4a47840082c5 -v 19.13.0.0.0 -f
odacli describe-job -i 9ec82ccd-d726-4172-be80-943bafbfbd18
Job details
----------------------------------------------------------------
ID: 9ec82ccd-d726-4172-be80-943bafbfbd18
Description: DB Home Patching: Home Id is 38c08a67-2730-4b76-92aa-4a47840082c5
Status: Failure
Created: February 23, 2022 7:11:36 PM CET
Message: DCS-10001:Internal error encountered: PRCT-1014 : Internal error: CmdToolUtil-execute1-error1.
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
DB Home Patching February 23, 2022 7:11:50 PM CET February 23, 2022 7:13:29 PM CET Failure
DB Home Patching February 23, 2022 7:11:50 PM CET February 23, 2022 7:13:29 PM CET Failure
Adding USER SSH_EQUIVALENCE February 23, 2022 7:11:50 PM CET February 23, 2022 7:11:51 PM CET Success
Adding USER SSH_EQUIVALENCE February 23, 2022 7:11:51 PM CET February 23, 2022 7:11:51 PM CET Success
task:TaskSequential_3109 February 23, 2022 7:11:51 PM CET February 23, 2022 7:12:54 PM CET Failure
Creating wallet for DB Client February 23, 2022 7:12:30 PM CET February 23, 2022 7:12:30 PM CET Success
Patch databases by RHP February 23, 2022 7:12:30 PM CET February 23, 2022 7:12:54 PM CET Failure
Despite the failure status, my stopped database is now switched to its new home, but the task stopped again after this change.
odacli list-databases
ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
6e26f06c-ee16-46f2-986e-0d82602fe93a GOTTSTDB SI 19.13.0.0.211019 false OLTP odb1 ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
17c84065-9bb9-4548-bf72-d0a02ad2213f PATSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
f34eddac-7794-47cd-9d6a-08aa3b2f90b7 PATSITDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
185bc4bf-492e-4b98-9440-b24c2864f572 PATCIDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
d0657336-b416-40d7-929f-8a9fe604e908 M4CTSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9681f86e-88b9-468f-93c6-9b2db76bede1 MINDEVDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
a5e4f009-942a-488c-9097-6e34e6b858dd MINTSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
62416912-551b-44cb-a23d-8f60ca7d8a37 REGNTTST SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
af37407a-f340-43b2-bb41-7f7e1143c703 LOGMTST SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
6ce0e7a6-7560-4b2a-b992-cf6cca7500f0 WNTVSTDB SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9bebb050-8090-444f-bbc7-7dcfb4bc68a1 BQ3 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
d7da5dba-03d5-4cbd-ba7f-00aaea97c55c POQ SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
7e396dee-e4b3-4d84-8a4e-e42b4de69884 OQ1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
64c248c3-aaf9-4a89-a672-f6e60e20e2aa SQ1 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
69b805d8-db8c-4240-aadc-e267b5c6f020 SQ2 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
76562430-5554-4876-967f-58bcb81e2818 OD1 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
4c50b2d6-0e4f-47d6-a278-5ee6bd4635d4 BD3 SI 19.10.0.0.210119 false OLTP odb1s ASM CONFIGURED 38c08a67-2730-4b76-92aa-4a47840082c5
9c5bac01-e9a6-4345-8076-4b647fb0457e SD1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
b051e5be-92c1-4d85-9060-7a36bf4befd6 POD SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
efd34b41-cbda-4785-9cda-e08450203619 SD2 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
4c679720-c577-4934-ab56-67d421538366 ARITSTDB SI 19.13.0.0.210119 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
Let’s start again the patching of this dbhome:
odacli update-dbhome -i 38c08a67-2730-4b76-92aa-4a47840082c5 -v 19.13.0.0.0 -f
odacli describe-job -i "36843376-2ea3-4d17-b641-dac34270d1f2"
Job details
----------------------------------------------------------------
ID: 36843376-2ea3-4d17-b641-dac34270d1f2
Description: DB Home Patching: Home Id is 38c08a67-2730-4b76-92aa-4a47840082c5
Status: Success
Created: February 23, 2022 7:16:42 PM CET
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Adding USER SSH_EQUIVALENCE February 23, 2022 7:16:56 PM CET February 23, 2022 7:16:57 PM CET Success
Adding USER SSH_EQUIVALENCE February 23, 2022 7:16:57 PM CET February 23, 2022 7:16:57 PM CET Success
Creating wallet for DB Client February 23, 2022 7:17:36 PM CET February 23, 2022 7:17:36 PM CET Success
Patch databases by RHP February 23, 2022 7:17:36 PM CET February 23, 2022 7:23:05 PM CET Success
updating database metadata February 23, 2022 7:23:59 PM CET February 23, 2022 7:23:59 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:23:59 PM CET February 23, 2022 7:24:03 PM CET Success
Patch databases by RHP February 23, 2022 7:24:03 PM CET February 23, 2022 7:31:11 PM CET Success
updating database metadata February 23, 2022 7:32:09 PM CET February 23, 2022 7:32:09 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:32:09 PM CET February 23, 2022 7:32:13 PM CET Success
Patch databases by RHP February 23, 2022 7:32:13 PM CET February 23, 2022 7:39:15 PM CET Success
updating database metadata February 23, 2022 7:40:09 PM CET February 23, 2022 7:40:09 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:40:09 PM CET February 23, 2022 7:40:14 PM CET Success
Patch databases by RHP February 23, 2022 7:40:14 PM CET February 23, 2022 7:47:25 PM CET Success
updating database metadata February 23, 2022 7:48:26 PM CET February 23, 2022 7:48:26 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:48:26 PM CET February 23, 2022 7:48:29 PM CET Success
Patch databases by RHP February 23, 2022 7:48:29 PM CET February 23, 2022 7:55:39 PM CET Success
updating database metadata February 23, 2022 7:56:34 PM CET February 23, 2022 7:56:34 PM CET Success
Set log_archive_dest for Database February 23, 2022 7:56:34 PM CET February 23, 2022 7:56:39 PM CET Success
Patch databases by RHP February 23, 2022 7:56:39 PM CET February 23, 2022 8:03:39 PM CET Success
updating database metadata February 23, 2022 8:04:33 PM CET February 23, 2022 8:04:33 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:04:34 PM CET February 23, 2022 8:04:37 PM CET Success
Patch databases by RHP February 23, 2022 8:04:37 PM CET February 23, 2022 8:11:27 PM CET Success
updating database metadata February 23, 2022 8:12:19 PM CET February 23, 2022 8:12:19 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:12:19 PM CET February 23, 2022 8:12:23 PM CET Success
Patch databases by RHP February 23, 2022 8:12:23 PM CET February 23, 2022 8:18:00 PM CET Success
updating database metadata February 23, 2022 8:18:54 PM CET February 23, 2022 8:18:54 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:18:54 PM CET February 23, 2022 8:18:58 PM CET Success
Patch databases by RHP February 23, 2022 8:18:58 PM CET February 23, 2022 8:24:02 PM CET Success
updating database metadata February 23, 2022 8:24:56 PM CET February 23, 2022 8:24:56 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:24:56 PM CET February 23, 2022 8:25:00 PM CET Success
Patch databases by RHP February 23, 2022 8:25:00 PM CET February 23, 2022 8:30:13 PM CET Success
updating database metadata February 23, 2022 8:31:06 PM CET February 23, 2022 8:31:06 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:31:06 PM CET February 23, 2022 8:31:13 PM CET Success
Patch databases by RHP February 23, 2022 8:31:13 PM CET February 23, 2022 8:36:19 PM CET Success
updating database metadata February 23, 2022 8:37:15 PM CET February 23, 2022 8:37:15 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:37:15 PM CET February 23, 2022 8:37:19 PM CET Success
Patch databases by RHP February 23, 2022 8:37:19 PM CET February 23, 2022 8:42:41 PM CET Success
updating database metadata February 23, 2022 8:43:36 PM CET February 23, 2022 8:43:36 PM CET Success
Set log_archive_dest for Database February 23, 2022 8:43:36 PM CET February 23, 2022 8:43:39 PM CET Success
Update System version February 23, 2022 8:43:39 PM CET February 23, 2022 8:43:39 PM CET Success
TDE parameter update February 23, 2022 8:44:27 PM CET February 23, 2022 8:44:27 PM CET Success
odacli list-databases
ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
6e26f06c-ee16-46f2-986e-0d82602fe93a GOTTSTDB SI 19.13.0.0.211019 false OLTP odb1 ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
17c84065-9bb9-4548-bf72-d0a02ad2213f PATSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
f34eddac-7794-47cd-9d6a-08aa3b2f90b7 PATSITDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
185bc4bf-492e-4b98-9440-b24c2864f572 PATCIDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
d0657336-b416-40d7-929f-8a9fe604e908 M4CTSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
9681f86e-88b9-468f-93c6-9b2db76bede1 MINDEVDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
a5e4f009-942a-488c-9097-6e34e6b858dd MINTSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
62416912-551b-44cb-a23d-8f60ca7d8a37 REGNTTST SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
af37407a-f340-43b2-bb41-7f7e1143c703 LOGMTST SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
6ce0e7a6-7560-4b2a-b992-cf6cca7500f0 WNTVSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
9bebb050-8090-444f-bbc7-7dcfb4bc68a1 BQ3 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
d7da5dba-03d5-4cbd-ba7f-00aaea97c55c POQ SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
7e396dee-e4b3-4d84-8a4e-e42b4de69884 OQ1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
64c248c3-aaf9-4a89-a672-f6e60e20e2aa SQ1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
69b805d8-db8c-4240-aadc-e267b5c6f020 SQ2 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
76562430-5554-4876-967f-58bcb81e2818 OD1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
4c50b2d6-0e4f-47d6-a278-5ee6bd4635d4 BD3 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
9c5bac01-e9a6-4345-8076-4b647fb0457e SD1 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
b051e5be-92c1-4d85-9060-7a36bf4befd6 POD SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
efd34b41-cbda-4785-9cda-e08450203619 SD2 SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
4c679720-c577-4934-ab56-67d421538366 ARITSTDB SI 19.13.0.0.211019 false OLTP odb1s ASM CONFIGURED e087a1ea-bf81-44a0-8f04-4d154c1fecc9
odacli finally managed to patch everything, but applying multiple time the patch on this home was needed. Number of runs depends on the number of databases not being read/write opened. As long as you have databases still pointing to the old dbhome you need to apply the patch again.
Conclusion
The solution to solve this problem is to start the patching again on the same dbhome and it will continue. Keep in mind that this has to be done in a sequential mode.
Patching an ODA takes time, time to prepare, time to backup prior patching, time to apply the patch, time to do the troubleshooting. But it works and everything is up to date with a single patch.
![Thumbnail [60x60]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/JDU_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/DWE_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2024/01/HME_web.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/FRJ_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2024/04/SIT_web.png)