I have been recently patching RAC databases on ODA 2-HA configured with Data Guard from version 19.20 to 19.26. During prepatch I have been facing an issue with missing sqldeveloper files, for which I could find a solution. I would like to share this solution with you as it might help you win some time.
Read more: dbhome prepatch failing on ODA due to missing sqldeveloper filesProblem description
From the node0, I have been running prepatch report.
[root@node0 ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0
Job details
----------------------------------------------------------------
ID: 68d89fc0-d5ed-47b5-a885-a5896b865262
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: Created
Created: July 15, 2025 14:59:07 CEST
Message: Use 'odacli describe-prepatchreport -i 68d89fc0-d5ed-47b5-a885-a5896b865262' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
Checking the prepatch report, it was suggest kind of freezing evaluating the DBHome.
[root@node0 ~]# odacli describe-prepatchreport -i 68d89fc0-d5ed-47b5-a885-a5896b865262
Patch pre-check report
------------------------------------------------------------------------
Job ID: 68d89fc0-d5ed-47b5-a885-a5896b865262
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: RUNNING
Created: July 15, 2025 2:59:07 PM CEST
Result:
Node Name
---------------
node0
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
5fc7e39d-adff-4903-b308-b4046840a38f
Validate patching tag Success Validated patching tag: 19.26.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 glogin.sql file Success Successfully verified glogin.sql
won't break patching
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 Running
RHP
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Success Successfully ran Orachk
Validate command execution Success Validated command execution
Node Name
---------------
node1
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
5fc7e39d-adff-4903-b308-b4046840a38f
Validate patching tag Success Validated patching tag: 19.26.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 glogin.sql file Success Successfully verified glogin.sql
won't break patching
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 Running
RHP
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Success Successfully ran Orachk
Validate command execution Success Validated command execution
Looking to the prepatch job status, it finished in Failure 10 min after starting.
[root@node0 ~]# odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262
Job details
----------------------------------------------------------------
ID: 68d89fc0-d5ed-47b5-a885-a5896b865262
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: Failure (To view Error Correlation report, run "odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262 --ecr" command)
Created: July 15, 2025 14:59:07 CEST
Message: Use 'odacli describe-prepatchreport -i ' to check prepatch resultsDCS-10292:One or more checks failed while checking for patching readiness.
Task Name Node Name Start Time End Time Status
---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------
task:TaskLockWrapper_37358 node0 July 15, 2025 14:59:12 CEST July 15, 2025 15:11:40 CEST Failure
task:TaskSequential_37359 node0 July 15, 2025 14:59:12 CEST July 15, 2025 15:11:40 CEST Failure
Setting up SSH equivalence node0 July 15, 2025 14:59:12 CEST July 15, 2025 14:59:14 CEST Success
Setting up SSH equivalence node0 July 15, 2025 14:59:14 CEST July 15, 2025 14:59:16 CEST Success
Run patching pre-checks node0 July 15, 2025 14:59:16 CEST July 15, 2025 15:11:40 CEST Success
task:TaskSequential_39928 node0 July 15, 2025 14:59:41 CEST July 15, 2025 15:04:28 CEST Failure
Creating ACFS database home node0 July 15, 2025 14:59:47 CEST July 15, 2025 14:59:47 CEST Success
Validating dbHome available space node0 July 15, 2025 14:59:47 CEST July 15, 2025 14:59:47 CEST Success
Validating dbHome available space node1 July 15, 2025 14:59:47 CEST July 15, 2025 14:59:47 CEST Success
Creating DbHome Directory node1 July 15, 2025 14:59:48 CEST July 15, 2025 14:59:48 CEST Success
Create required directories node0 July 15, 2025 14:59:48 CEST July 15, 2025 14:59:48 CEST Success
Extract DB clone node0 July 15, 2025 14:59:48 CEST July 15, 2025 15:00:43 CEST Success
ProvDbHome by using RHP node0 July 15, 2025 15:00:43 CEST July 15, 2025 15:02:27 CEST Success
Enable DB options node0 July 15, 2025 15:02:27 CEST July 15, 2025 15:02:35 CEST Success
Creating wallet for DB Client node0 July 15, 2025 15:02:38 CEST July 15, 2025 15:02:38 CEST Success
task:TaskSequential_40059 node0 July 15, 2025 15:02:39 CEST July 15, 2025 15:04:28 CEST Failure
Precheck Patch databases by RHP node0 July 15, 2025 15:02:39 CEST July 15, 2025 15:04:28 CEST Failure
Check pre-check status node0 July 15, 2025 15:11:40 CEST July 15, 2025 15:11:40 CEST Failure
[root@node0 ~]#
This was a job result for the second attempt. The first attempt would showed following tasks:
Task Name Node Name Start Time End Time Status
---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------
task:TaskLockWrapper_62015 node0 July 15, 2025 17:57:06 CEST July 15, 2025 18:09:43 CEST Failure
task:TaskSequential_62016 node0 July 15, 2025 17:57:06 CEST July 15, 2025 18:09:43 CEST Failure
Setting up SSH equivalence node0 July 15, 2025 17:57:06 CEST July 15, 2025 17:57:08 CEST Success
Setting up SSH equivalence node0 July 15, 2025 17:57:08 CEST July 15, 2025 17:57:10 CEST Success
Run patching pre-checks node0 July 15, 2025 17:57:10 CEST July 15, 2025 18:09:43 CEST Success
task:TaskSequential_66113 node0 July 15, 2025 17:57:40 CEST July 15, 2025 18:02:29 CEST Failure
Creating ACFS database home node0 July 15, 2025 17:57:46 CEST July 15, 2025 17:57:46 CEST Success
Validating dbHome available space node0 July 15, 2025 17:57:46 CEST July 15, 2025 17:57:46 CEST Success
Validating dbHome available space node1 July 15, 2025 17:57:46 CEST July 15, 2025 17:57:46 CEST Success
Creating DbHome Directory node1 July 15, 2025 17:57:47 CEST July 15, 2025 17:57:47 CEST Success
Create required directories node0 July 15, 2025 17:57:47 CEST July 15, 2025 17:57:47 CEST Success
Extract DB clone node0 July 15, 2025 17:57:47 CEST July 15, 2025 17:58:41 CEST Success
ProvDbHome by using RHP node0 July 15, 2025 17:58:41 CEST July 15, 2025 18:00:26 CEST Success
Enable DB options node0 July 15, 2025 18:00:27 CEST July 15, 2025 18:00:35 CEST Success
Creating wallet for DB Client node0 July 15, 2025 18:00:38 CEST July 15, 2025 18:00:38 CEST Success
task:TaskSequential_66226 node0 July 15, 2025 18:00:39 CEST July 15, 2025 18:02:29 CEST Failure
Precheck Patch databases by RHP node0 July 15, 2025 18:00:39 CEST July 15, 2025 18:02:29 CEST Failure
Check pre-check status node0 July 15, 2025 18:09:43 CEST July 15, 2025 18:09:43 CEST FailureChecking the log of the dcs agent, I could find following:
"taskResult" : "DCS-10001:Internal error encountered: PRGT-388 : Pre-patch verification through Configuration Verification Utility reported one or more errors.\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-sqlcl.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/low-level-api.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jaxb-api.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-core.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orajsoda.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-codec.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/javax.json.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-logging.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-net.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-mapping.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-utility.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-annotations.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_cert.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-http.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ojdbc8.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-common.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/oraclepki.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_core.jar\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/sql.exe\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/sql\" does not exist on node \"node0\".\nPRVH-0102 : File \"/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/README.md\" does not exist on node \"node0\"..",The describe job with –ecr option would give me the same:
[root@node0 ~]# odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262 --ecr
ODA Assistant - Error Correlation report
----------------------------------------
Failed job ID: 68d89fc0-d5ed-47b5-a885-a5896b865262
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Start Time: July 15, 2025 14:59:12 CEST
End Time: July 15, 2025 15:11:40 CEST
EC report path: /opt/oracle/dcs/da/da_repo/546ca4ac-97e6-4038-bf6d-90986c7f21bf.json
Failed Task Messages
--------------------
[Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1] - Use 'odacli describe-prepatchreport -i ' to check prepatch resultsDCS-10292:One or more checks failed while checking for patching readiness.
[task:TaskLockWrapper_37358] - DCS-10292:One or more checks failed while checking for patching readiness.
[task:TaskSequential_39928] - DCS-10001:Internal error encountered: PRGT-388 : Pre-patch verification through Configuration Verification Utility reported one or more errors. PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-sqlcl.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/low-level-api.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jaxb-api.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-core.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orajsoda.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-codec.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/javax.json.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-logging.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-net.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-mapping.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-utility.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-annotations.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_cert.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-http.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ojdbc8.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-common.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/oraclepki.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_core.jar" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/sql.exe" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/sql" does not exist on node "node0". PRVH-0102 : File "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/README.md" does not exist on node "node0"..
...
...
...
So the problem is definitively that prepatch is expecting the in source dbhome to patch, a directory sqldeveloper, which is not existing, did not exist since a while and is not existing in any other dbhome from any other ODA customer had (and customer has got several ODAs and dbhome). What a strange “new” bug!
Resolution
I first checked and could confirm that my source dbhome really does not have any sqldeveloper foloder.
[root@node0 ~]# ls -ld /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sql* drwxr-xr-x 4 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl drwxr-xr-x 3 oracle oinstall 20480 Apr 17 2019 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlj drwxr-xr-x 7 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlpatch drwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlplus [root@node0 ~]#
Looking quickly on the oracle support, I could find following Doc ID, which was exactly my problem:
ODA db home prepatch report keeps running/hangs at “Evaluate DBHome patching with RHP” (Doc ID 3067737.1)
OK, but reading on the solution described in the Doc ID, it will not help me that much :
If you have old dbhomes on this ODA (or) any other ODA please copy "/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_x/sqldeveloper/sqldeveloper" folder to the source home for which prepatch report is being run.
Then re-run the dbhome patching which should complete without any issues.Checking on an old backup I did few years ago I could find a sqldeveloper zip file in a patch storage directory.
oracle@node0:/mnt/tmp/backup_dbhome/tsrpri/OraDB19000_home3/ [DB11] tar tvf dbhome_3.tarz | grep -i sqldevelop -rw-r--r-- oracle/oinstall 23557640 2023-07-17 16:37 ./dbhome_3/.patch_storage/35320081_Jul_15_2023_12_54_11/files/sqldeveloper.zip
I uncompressed the archive file, and extracted the content of the zip file.
[oracle@node0 software_patching]$ unzip sqldeveloper.zip Archive: sqldeveloper.zip inflating: sqldeveloper/sqldeveloper/lib/6462746f6f6c732d6e65742e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6462746f6f6c732d636f6d6d6f6e2e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/636f6d6d6f6e732d6c6f6767696e672e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a6178622d6170692e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f6a646263382e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a61636b736f6e2d636f72652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6c6f772d6c6576656c2d6170692e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a61636b736f6e2d6461746162696e642e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f7261636c65706b692e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f7364745f636572742e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f72616931386e2e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/687474706d696d652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/786d6c70617273657276322d73616e732d6a6178702d73657276696365732e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/706c7567696e2d6170692e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a61636b736f6e2d616e6e6f746174696f6e732e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f72616931386e2d6d617070696e672e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/706f6d2e786d6c_o_ inflating: sqldeveloper/sqldeveloper/lib/636f6d6d6f6e732d636f6465632e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f72616a736f64612e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/616e746c722d72756e74696d652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6462746f6f6c732d73716c636c2e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a617661782e6a736f6e2e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f7364745f636f72652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/ext/736c66346a2d6a646b31342e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/ext/6c69717569626173652d636f72652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/ext/6f7261636c652d6c69717569626173652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/ext/736c66346a2d6170692e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6462746f6f6c732d687474702e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/68747470636c69656e742e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6f72616931386e2d7574696c6974792e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/737472696e6774656d706c6174652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a7363682e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/68747470636f72652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a6c696e652e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/786462362e6a6172_o_ inflating: sqldeveloper/sqldeveloper/lib/6a7a6c69622e6a6172_o_ inflating: sqldeveloper/sqldeveloper/bin/524541444d452e6d64_o_ inflating: sqldeveloper/sqldeveloper/bin/73716c2e657865_o_ inflating: sqldeveloper/sqldeveloper/bin/73716c_o_ inflating: sqldeveloper/modules/6a617661782e736572766c65742e6a617661782e736572766c65742d6170692e6a6172_o_ [oracle@node0 software_patching]$
But that zip file did not really content any missing file the prepatch was complaining about… I anyhow decided to copy it to my source dbhome. This dbhome will not be used any more. As you might know, the prepatch will first create a new dbhome for the patching process to run an out-of-place patching, so moving the database to this new dbhome and running datapatch. So any file that I copy to my current source dbhome will not have any impact.
[root@node0 ~]# ls -ld /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sql* drwxr-xr-x 4 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl drwxr-xr-x 3 oracle oinstall 20480 Apr 17 2019 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlj drwxr-xr-x 7 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlpatch drwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlplus [root@node0 ~]# cp -pR /mnt/tmp/software_patching/sqldeveloper /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/ [root@node0 ~]# ls -ld /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sql* drwxr-xr-x 4 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl drwxr-xr-x 4 oracle oinstall 20480 Jul 15 17:00 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper drwxr-xr-x 3 oracle oinstall 20480 Apr 17 2019 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlj drwxr-xr-x 7 oracle oinstall 20480 Jul 17 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlpatch drwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlplus [root@node0 ~]#
As expected there is no jar files in the copied directory.
[root@node0 ~]# ls -ltrh /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ total 25M -rw-r--r-- 1 oracle oinstall 1.9M Jul 17 2023 786d6c70617273657276322d73616e732d6a6178702d73657276696365732e6a6172_o_ -rw-r--r-- 1 oracle oinstall 257K Jul 17 2023 786462362e6a6172_o_ -rw-r--r-- 1 oracle oinstall 222K Jul 17 2023 737472696e6774656d706c6174652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 11K Jul 17 2023 706f6d2e786d6c_o_ -rw-r--r-- 1 oracle oinstall 73K Jul 17 2023 706c7567696e2d6170692e6a6172_o_ -rw-r--r-- 1 oracle oinstall 300K Jul 17 2023 6f7364745f636f72652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 201K Jul 17 2023 6f7364745f636572742e6a6172_o_ -rw-r--r-- 1 oracle oinstall 410K Jul 17 2023 6f72616a736f64612e6a6172_o_ -rw-r--r-- 1 oracle oinstall 1.6M Jul 17 2023 6f72616931386e2e6a6172_o_ -rw-r--r-- 1 oracle oinstall 490K Jul 17 2023 6f72616931386e2d7574696c6974792e6a6172_o_ -rw-r--r-- 1 oracle oinstall 88K Jul 17 2023 6f72616931386e2d6d617070696e672e6a6172_o_ -rw-r--r-- 1 oracle oinstall 301K Jul 17 2023 6f7261636c65706b692e6a6172_o_ -rw-r--r-- 1 oracle oinstall 4.0M Jul 17 2023 6f6a646263382e6a6172_o_ -rw-r--r-- 1 oracle oinstall 500K Jul 17 2023 6c6f772d6c6576656c2d6170692e6a6172_o_ -rw-r--r-- 1 oracle oinstall 65K Jul 17 2023 6a7a6c69622e6a6172_o_ -rw-r--r-- 1 oracle oinstall 276K Jul 17 2023 6a7363682e6a6172_o_ -rw-r--r-- 1 oracle oinstall 263K Jul 17 2023 6a6c696e652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 123K Jul 17 2023 6a6178622d6170692e6a6172_o_ -rw-r--r-- 1 oracle oinstall 84K Jul 17 2023 6a617661782e6a736f6e2e6a6172_o_ -rw-r--r-- 1 oracle oinstall 1.3M Jul 17 2023 6a61636b736f6e2d6461746162696e642e6a6172_o_ -rw-r--r-- 1 oracle oinstall 318K Jul 17 2023 6a61636b736f6e2d636f72652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 66K Jul 17 2023 6a61636b736f6e2d616e6e6f746174696f6e732e6a6172_o_ -rw-r--r-- 1 oracle oinstall 41K Jul 17 2023 687474706d696d652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 320K Jul 17 2023 68747470636f72652e6a6172_o_ -rw-r--r-- 1 oracle oinstall 749K Jul 17 2023 68747470636c69656e742e6a6172_o_ -rw-r--r-- 1 oracle oinstall 429K Jul 17 2023 6462746f6f6c732d73716c636c2e6a6172_o_ -rw-r--r-- 1 oracle oinstall 131K Jul 17 2023 6462746f6f6c732d6e65742e6a6172_o_ -rw-r--r-- 1 oracle oinstall 50K Jul 17 2023 6462746f6f6c732d687474702e6a6172_o_ -rw-r--r-- 1 oracle oinstall 7.1M Jul 17 2023 6462746f6f6c732d636f6d6d6f6e2e6a6172_o_ -rw-r--r-- 1 oracle oinstall 61K Jul 17 2023 636f6d6d6f6e732d6c6f6767696e672e6a6172_o_ -rw-r--r-- 1 oracle oinstall 328K Jul 17 2023 636f6d6d6f6e732d636f6465632e6a6172_o_ -rw-r--r-- 1 oracle oinstall 160K Jul 17 2023 616e746c722d72756e74696d652e6a6172_o_ drwxr-xr-x 2 oracle oinstall 20K Jul 15 17:00 ext [root@node0 ~]#
Strangely, the missing file the prepatch report is expecting, comes from sqlcl.
[root@node0 ~]# ls -ltrh /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl/lib total 37M -rw-r--r-- 1 oracle oinstall 1.8M Jul 16 2023 ucp.jar -rw-r--r-- 1 oracle oinstall 8.3K Jul 16 2023 slf4j-jdk14.jar -rw-r--r-- 1 oracle oinstall 306K Jul 16 2023 osdt_core.jar -rw-r--r-- 1 oracle oinstall 206K Jul 16 2023 osdt_cert.jar -rw-r--r-- 1 oracle oinstall 441K Jul 16 2023 orajsoda.jar -rw-r--r-- 1 oracle oinstall 301K Jul 16 2023 oraclepki.jar -rw-r--r-- 1 oracle oinstall 126K Jul 16 2023 javax.json.jar -rw-r--r-- 1 oracle oinstall 237K Jul 16 2023 jansi.jar -rw-r--r-- 1 oracle oinstall 74K Jul 16 2023 jackson-annotations.jar -rw-r--r-- 1 oracle oinstall 2.8M Jul 16 2023 guava-with-lf.jar -rw-r--r-- 1 oracle oinstall 296K Jul 16 2023 dbtools-net.jar -rw-r--r-- 1 oracle oinstall 354K Jul 16 2023 commons-codec.jar -rw-r--r-- 1 oracle oinstall 1.9M Jul 16 2023 xmlparserv2_sans_jaxp_services.jar -rw-r--r-- 1 oracle oinstall 260K Jul 16 2023 xdb.jar -rw-r--r-- 1 oracle oinstall 248K Jul 16 2023 ST4.jar -rw-r--r-- 1 oracle oinstall 361K Jul 16 2023 sshd-sftp.jar -rw-r--r-- 1 oracle oinstall 120K Jul 16 2023 sshd-scp.jar -rw-r--r-- 1 oracle oinstall 920K Jul 16 2023 sshd-core.jar -rw-r--r-- 1 oracle oinstall 42K Jul 16 2023 sshd-contrib.jar -rw-r--r-- 1 oracle oinstall 921K Jul 16 2023 sshd-common.jar -rw-r--r-- 1 oracle oinstall 41K Jul 16 2023 slf4j-api.jar -rw-r--r-- 1 oracle oinstall 496K Jul 16 2023 orai18n-utility.jar -rw-r--r-- 1 oracle oinstall 89K Jul 16 2023 orai18n-mapping.jar -rw-r--r-- 1 oracle oinstall 1.6M Jul 16 2023 orai18n.jar -rw-r--r-- 1 oracle oinstall 4.9M Jul 16 2023 ojdbc8.jar -rw-r--r-- 1 oracle oinstall 976K Jul 16 2023 jline3.jar -rw-r--r-- 1 oracle oinstall 376K Jul 16 2023 jdbcrest.jar -rw-r--r-- 1 oracle oinstall 126K Jul 16 2023 jaxb-api.jar -rw-r--r-- 1 oracle oinstall 56K Jul 16 2023 javax.activation-api.jar -rw-r--r-- 1 oracle oinstall 28K Jul 16 2023 jackson-jr-stree.jar -rw-r--r-- 1 oracle oinstall 98K Jul 16 2023 jackson-jr-objects.jar -rw-r--r-- 1 oracle oinstall 367K Jul 16 2023 jackson-core.jar -rw-r--r-- 1 oracle oinstall 830K Jul 16 2023 httpcore5.jar -rw-r--r-- 1 oracle oinstall 780K Jul 16 2023 httpclient5.jar -rw-r--r-- 1 oracle oinstall 693K Jul 16 2023 dbtools-sqlcl.jar -rw-r--r-- 1 oracle oinstall 80K Jul 16 2023 dbtools-http.jar -rw-r--r-- 1 oracle oinstall 131K Jul 16 2023 dbtools-datapump.jar -rw-r--r-- 1 oracle oinstall 486K Jul 16 2023 dbtools-data.jar -rw-r--r-- 1 oracle oinstall 7.5M Jul 16 2023 dbtools-common.jar -rw-r--r-- 1 oracle oinstall 63K Jul 16 2023 commons-logging.jar -rw-r--r-- 1 oracle oinstall 164K Jul 16 2023 antlr-runtime.jar drwxr-xr-x 2 oracle oinstall 20K Jul 17 2023 ext [root@node0 ~]#
So I decided to copy the files to my new sqldeveloper lib folder.
[root@node0 ~]# cp -p /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl/lib/*.jar /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ [root@node0 ~]# ls -ltrh /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/*.jar -rw-r--r-- 1 oracle oinstall 1.8M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ucp.jar -rw-r--r-- 1 oracle oinstall 8.3K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/slf4j-jdk14.jar -rw-r--r-- 1 oracle oinstall 306K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_core.jar -rw-r--r-- 1 oracle oinstall 206K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/osdt_cert.jar -rw-r--r-- 1 oracle oinstall 441K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orajsoda.jar -rw-r--r-- 1 oracle oinstall 301K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/oraclepki.jar -rw-r--r-- 1 oracle oinstall 126K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/javax.json.jar -rw-r--r-- 1 oracle oinstall 237K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jansi.jar -rw-r--r-- 1 oracle oinstall 74K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-annotations.jar -rw-r--r-- 1 oracle oinstall 2.8M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/guava-with-lf.jar -rw-r--r-- 1 oracle oinstall 296K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-net.jar -rw-r--r-- 1 oracle oinstall 354K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-codec.jar -rw-r--r-- 1 oracle oinstall 1.9M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/xmlparserv2_sans_jaxp_services.jar -rw-r--r-- 1 oracle oinstall 260K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/xdb.jar -rw-r--r-- 1 oracle oinstall 248K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ST4.jar -rw-r--r-- 1 oracle oinstall 361K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/sshd-sftp.jar -rw-r--r-- 1 oracle oinstall 120K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/sshd-scp.jar -rw-r--r-- 1 oracle oinstall 920K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/sshd-core.jar -rw-r--r-- 1 oracle oinstall 42K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/sshd-contrib.jar -rw-r--r-- 1 oracle oinstall 921K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/sshd-common.jar -rw-r--r-- 1 oracle oinstall 41K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/slf4j-api.jar -rw-r--r-- 1 oracle oinstall 496K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-utility.jar -rw-r--r-- 1 oracle oinstall 89K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n-mapping.jar -rw-r--r-- 1 oracle oinstall 1.6M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/orai18n.jar -rw-r--r-- 1 oracle oinstall 4.9M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ojdbc8.jar -rw-r--r-- 1 oracle oinstall 976K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jline3.jar -rw-r--r-- 1 oracle oinstall 376K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jdbcrest.jar -rw-r--r-- 1 oracle oinstall 126K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jaxb-api.jar -rw-r--r-- 1 oracle oinstall 56K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/javax.activation-api.jar -rw-r--r-- 1 oracle oinstall 28K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-jr-stree.jar -rw-r--r-- 1 oracle oinstall 98K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-jr-objects.jar -rw-r--r-- 1 oracle oinstall 367K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/jackson-core.jar -rw-r--r-- 1 oracle oinstall 830K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/httpcore5.jar -rw-r--r-- 1 oracle oinstall 780K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/httpclient5.jar -rw-r--r-- 1 oracle oinstall 693K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-sqlcl.jar -rw-r--r-- 1 oracle oinstall 80K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-http.jar -rw-r--r-- 1 oracle oinstall 131K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-datapump.jar -rw-r--r-- 1 oracle oinstall 486K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-data.jar -rw-r--r-- 1 oracle oinstall 7.5M Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/dbtools-common.jar -rw-r--r-- 1 oracle oinstall 63K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/commons-logging.jar -rw-r--r-- 1 oracle oinstall 164K Jul 16 2023 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/antlr-runtime.jar [root@node0 ~]#
I did the same for the missing file in the bin directory.
[root@node0 ~]# cp -p /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqlcl/bin/* /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin/ [root@node0 ~]# ls -ltrh /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/bin total 372K -rw-r--r-- 1 oracle oinstall 119 Jul 16 2023 version.txt -rwxr-xr-x 1 oracle oinstall 148K Jul 16 2023 sql.exe -rwxr-xr-x 1 oracle oinstall 21K Jul 16 2023 sql -rw-r--r-- 1 oracle oinstall 2.4K Jul 16 2023 README.md -rw-r--r-- 1 oracle oinstall 4.3K Jul 16 2023 license.txt -rwxr-xr-x 1 oracle oinstall 1.2K Jul 16 2023 dependencies.txt -rw-r--r-- 1 oracle oinstall 15K Jul 17 2023 73716c_o_ -rw-r--r-- 1 oracle oinstall 126K Jul 17 2023 73716c2e657865_o_ -rw-r--r-- 1 oracle oinstall 419 Jul 17 2023 524541444d452e6d64_o_ [root@node0 ~]#
I’m still convinced this is a bug where it is looking for a sqldeveloper folder when the process wanted to check sqlcl, because all the missing files are the one from sqlcl. Anyhow, let’s try to move forward with the resolution.
There is a last jar file that the prepatch is still complaining on, low-level-api.jar, which I could not find in any of the source dbhome. But I could find it in the new dbhome, here dbhome5, that the prepatch process created during the failed job (the initial steps, Extract DB clone, of the prepatch command was run successfully).
[root@node0 ~]# find /u01/app/odaorahome/oracle/ -name low-level-api.jar /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5/sqlcl/lib/low-level-api.jar
I decided to copy it as well to the source sqldeveloper lib folder.
[root@node0 ~]# cp -p /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5/sqlcl/lib/low-level-api.jar /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/sqldeveloper/sqldeveloper/lib/ [root@node0 ~]#
And I run the prepatch again.
[root@node0 ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0
Job details
----------------------------------------------------------------
ID: fe0dfd66-79b8-4f38-afe2-b2cef1d15943
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: Created
Created: July 15, 2025 17:37:31 CEST
Message: Use 'odacli describe-prepatchreport -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------
[root@node0 ~]#
Which that time was successfull!
[root@node0 ~]# odacli describe-job -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943
Job details
----------------------------------------------------------------
ID: fe0dfd66-79b8-4f38-afe2-b2cef1d15943
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: Success
Created: July 15, 2025 17:37:31 CEST
Message: Successfully finished prechecking for patching the databases [DB1_IWB] with rolling option
Task Name Node Name Start Time End Time Status
---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------
Setting up SSH equivalence node0 July 15, 2025 17:37:37 CEST July 15, 2025 17:37:39 CEST Success
Setting up SSH equivalence node0 July 15, 2025 17:37:39 CEST July 15, 2025 17:37:40 CEST Success
Run patching pre-checks node0 July 15, 2025 17:37:40 CEST July 15, 2025 17:47:11 CEST Success
Precheck Patch databases by RHP node0 July 15, 2025 17:38:05 CEST July 15, 2025 17:39:56 CEST Success
TDE parameter update node1 July 15, 2025 17:39:56 CEST July 15, 2025 17:39:56 CEST Success
[root@node0 ~]# odacli describe-prepatchreport -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943
Patch pre-check report
------------------------------------------------------------------------
Job ID: fe0dfd66-79b8-4f38-afe2-b2cef1d15943
Description: Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1
Status: SUCCESS
Created: July 15, 2025 5:37:31 PM CEST
Result: All pre-checks succeeded
Node Name
---------------
node0
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
5fc7e39d-adff-4903-b308-b4046840a38f
Validate patching tag Success Validated patching tag: 19.26.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 glogin.sql file Success Successfully verified glogin.sql
won't break patching
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
Node Name
---------------
node1
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
5fc7e39d-adff-4903-b308-b4046840a38f
Validate patching tag Success Validated patching tag: 19.26.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 glogin.sql file Success Successfully verified glogin.sql
won't break patching
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
[root@node0 ~]#
And, of course, later in my activities during the maintenance windows, the patching of the dbhome was successful.
[root@node0 ~]# /opt/oracle/dcs/bin/odacli update-dbhome -i 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0
{
"jobId" : "b4467935-edd0-46a6-8c84-04e216d05973",
"status" : "Created",
"message" : "",
"reports" : [ ],
"createTimestamp" : "July 16, 2025 00:21:17 CEST",
"resourceList" : [ ],
"description" : "DB Home Patching to 19.26.0.0.0: Home ID is 5fc7e39d-adff-4903-b308-b4046840a38f",
"updatedTime" : "July 16, 2025 00:21:17 CEST",
"jobType" : null,
"cpsMetadata" : null
}
[root@node0 ~]#
[root@node0 ~]# odacli describe-job -i b4467935-edd0-46a6-8c84-04e216d05973
Job details
----------------------------------------------------------------
ID: b4467935-edd0-46a6-8c84-04e216d05973
Description: DB Home Patching to 19.26.0.0.0: Home ID is 5fc7e39d-adff-4903-b308-b4046840a38f
Status: Success
Created: July 16, 2025 00:21:17 CEST
Message:
Task Name Node Name Start Time End Time Status
---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------
Creating wallet for DB Client node0 July 16, 2025 00:21:52 CEST July 16, 2025 00:21:53 CEST Success
Patch databases by RHP - [DB1] node0 July 16, 2025 00:21:53 CEST July 16, 2025 00:27:37 CEST Success
Updating database metadata node1 July 16, 2025 00:27:37 CEST July 16, 2025 00:27:37 CEST Success
Set log_archive_dest for Database node0 July 16, 2025 00:27:37 CEST July 16, 2025 00:27:38 CEST Success
Generating and saving BOM node0 July 16, 2025 00:27:39 CEST July 16, 2025 00:28:30 CEST Success
Generating and saving BOM node1 July 16, 2025 00:27:39 CEST July 16, 2025 00:28:32 CEST Success
TDE parameter update node1 July 16, 2025 00:29:23 CEST July 16, 2025 00:29:23 CEST Success
[root@node0 ~]#
To wrap up…
I faced this prepatch issue during the preparation of my maintenance windows activity, where I had to patching several RAC databases using separate dbhome and configured with Data Guard. The maintenance windows where we can stop the application is only from 12am to 5am. Therefore I could not take the risk to loose time and try if the force option from the update-dbhome will do the work. And I was also convinced, that knowing the prepatch status would neither be success nor failed, the patching command could not be executed. The second point is that the force option can usually be helpful if there is some failure with orachk that you know would not have any impact. In my case, a failed step on the task “Evaluate DBHome patching with RHP” is something that needs to be resolved before patching the dbhome.
I had to run the same resolution for all my dbhome on the primary and standby side.
![Thumbnail [60x60]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/MAW_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2024/02/XFG-web.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2024/04/SIT_web.png)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/JEW_web-min-scaled.jpg)