{"id":39571,"date":"2025-07-21T08:40:35","date_gmt":"2025-07-21T06:40:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=39571"},"modified":"2025-07-21T08:40:37","modified_gmt":"2025-07-21T06:40:37","slug":"dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/","title":{"rendered":"dbhome prepatch failing on ODA due to missing sqldeveloper files"},"content":{"rendered":"\n

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.<\/p>\n\n\nRead more: dbhome prepatch failing on ODA due to missing sqldeveloper files<\/span><\/a>\n\n\n

Problem description<\/h3>\n\n\n\n

From the node0, I have been running prepatch report.<\/p>\n\n\n\n

\n[root@node0 ~]# \/opt\/oracle\/dcs\/bin\/odacli create-prepatchreport --dbhome --dbhomeid 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0\n\nJob details\n----------------------------------------------------------------\n                     ID:  68d89fc0-d5ed-47b5-a885-a5896b865262\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  Created\n                Created:  July 15, 2025 14:59:07 CEST\n                Message:  Use 'odacli describe-prepatchreport -i 68d89fc0-d5ed-47b5-a885-a5896b865262' to check details of results\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n<\/pre>\n<\/br>\n\n\n\n
Checking the prepatch report, it was suggest kind of freezing evaluating the DBHome.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli describe-prepatchreport -i 68d89fc0-d5ed-47b5-a885-a5896b865262\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  68d89fc0-d5ed-47b5-a885-a5896b865262\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  RUNNING\n                Created:  July 15, 2025 2:59:07 PM CEST\n                 Result:\n\nNode Name\n---------------\nnode0\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          5fc7e39d-adff-4903-b308-b4046840a38f\nValidate patching tag           Success   Validated patching tag: 19.26.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\nValidate glogin.sql file        Success   Successfully verified glogin.sql\n                                          won't break patching\nValidate dbHomesOnACFS          Success   User has configured disk group for\nconfigured                                Database homes on ACFS\nValidate Oracle base            Success   Successfully validated Oracle Base\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nEvaluate DBHome patching with   Running\nRHP\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\nNode Name\n---------------\nnode1\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          5fc7e39d-adff-4903-b308-b4046840a38f\nValidate patching tag           Success   Validated patching tag: 19.26.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\nValidate glogin.sql file        Success   Successfully verified glogin.sql\n                                          won't break patching\nValidate dbHomesOnACFS          Success   User has configured disk group for\nconfigured                                Database homes on ACFS\nValidate Oracle base            Success   Successfully validated Oracle Base\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nEvaluate DBHome patching with   Running\nRHP\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\n<\/pre>\n<\/br>\n\n\n\n
Looking to the prepatch job status, it finished in Failure 10 min after starting.<\/p>\n\n\n\n
\n[root@node0 ~]# odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262\n\nJob details\n----------------------------------------------------------------\n                     ID:  68d89fc0-d5ed-47b5-a885-a5896b865262\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  Failure (To view Error Correlation report, run \"odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262 --ecr\" command)\n                Created:  July 15, 2025 14:59:07 CEST\n                Message:  Use 'odacli describe-prepatchreport -i ' to check prepatch resultsDCS-10292:One or more checks failed while checking for patching readiness.\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\ntask:TaskLockWrapper_37358               node0                 July 15, 2025 14:59:12 CEST              July 15, 2025 15:11:40 CEST              Failure\ntask:TaskSequential_37359                node0                 July 15, 2025 14:59:12 CEST              July 15, 2025 15:11:40 CEST              Failure\nSetting up SSH equivalence               node0                 July 15, 2025 14:59:12 CEST              July 15, 2025 14:59:14 CEST              Success\nSetting up SSH equivalence               node0                 July 15, 2025 14:59:14 CEST              July 15, 2025 14:59:16 CEST              Success\nRun patching pre-checks                  node0                 July 15, 2025 14:59:16 CEST              July 15, 2025 15:11:40 CEST              Success\ntask:TaskSequential_39928                node0                 July 15, 2025 14:59:41 CEST              July 15, 2025 15:04:28 CEST              Failure\nCreating ACFS database home              node0                 July 15, 2025 14:59:47 CEST              July 15, 2025 14:59:47 CEST              Success\nValidating dbHome available space        node0                 July 15, 2025 14:59:47 CEST              July 15, 2025 14:59:47 CEST              Success\nValidating dbHome available space        node1                 July 15, 2025 14:59:47 CEST              July 15, 2025 14:59:47 CEST              Success\nCreating DbHome Directory                node1                 July 15, 2025 14:59:48 CEST              July 15, 2025 14:59:48 CEST              Success\nCreate required directories              node0                 July 15, 2025 14:59:48 CEST              July 15, 2025 14:59:48 CEST              Success\nExtract DB clone                         node0                 July 15, 2025 14:59:48 CEST              July 15, 2025 15:00:43 CEST              Success\nProvDbHome by using RHP                  node0                 July 15, 2025 15:00:43 CEST              July 15, 2025 15:02:27 CEST              Success\nEnable DB options                        node0                 July 15, 2025 15:02:27 CEST              July 15, 2025 15:02:35 CEST              Success\nCreating wallet for DB Client            node0                 July 15, 2025 15:02:38 CEST              July 15, 2025 15:02:38 CEST              Success\ntask:TaskSequential_40059                node0                 July 15, 2025 15:02:39 CEST              July 15, 2025 15:04:28 CEST              Failure\nPrecheck Patch databases by RHP          node0                 July 15, 2025 15:02:39 CEST              July 15, 2025 15:04:28 CEST              Failure\nCheck pre-check status                   node0                 July 15, 2025 15:11:40 CEST              July 15, 2025 15:11:40 CEST              Failure\n\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
This was a job result for the second attempt. The first attempt would showed following tasks:<\/p>\n\n\n\n
Task Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\ntask:TaskLockWrapper_62015               node0                 July 15, 2025 17:57:06 CEST              July 15, 2025 18:09:43 CEST              Failure\ntask:TaskSequential_62016                node0                 July 15, 2025 17:57:06 CEST              July 15, 2025 18:09:43 CEST              Failure\nSetting up SSH equivalence               node0                 July 15, 2025 17:57:06 CEST              July 15, 2025 17:57:08 CEST              Success\nSetting up SSH equivalence               node0                 July 15, 2025 17:57:08 CEST              July 15, 2025 17:57:10 CEST              Success\nRun patching pre-checks                  node0                 July 15, 2025 17:57:10 CEST              July 15, 2025 18:09:43 CEST              Success\ntask:TaskSequential_66113                node0                 July 15, 2025 17:57:40 CEST              July 15, 2025 18:02:29 CEST              Failure\nCreating ACFS database home              node0                 July 15, 2025 17:57:46 CEST              July 15, 2025 17:57:46 CEST              Success\nValidating dbHome available space        node0                 July 15, 2025 17:57:46 CEST              July 15, 2025 17:57:46 CEST              Success\nValidating dbHome available space        node1                 July 15, 2025 17:57:46 CEST              July 15, 2025 17:57:46 CEST              Success\nCreating DbHome Directory                node1                 July 15, 2025 17:57:47 CEST              July 15, 2025 17:57:47 CEST              Success\nCreate required directories              node0                 July 15, 2025 17:57:47 CEST              July 15, 2025 17:57:47 CEST              Success\nExtract DB clone                         node0                 July 15, 2025 17:57:47 CEST              July 15, 2025 17:58:41 CEST              Success\nProvDbHome by using RHP                  node0                 July 15, 2025 17:58:41 CEST              July 15, 2025 18:00:26 CEST              Success\nEnable DB options                        node0                 July 15, 2025 18:00:27 CEST              July 15, 2025 18:00:35 CEST              Success\nCreating wallet for DB Client            node0                 July 15, 2025 18:00:38 CEST              July 15, 2025 18:00:38 CEST              Success\ntask:TaskSequential_66226                node0                 July 15, 2025 18:00:39 CEST              July 15, 2025 18:02:29 CEST              Failure\nPrecheck Patch databases by RHP          node0                 July 15, 2025 18:00:39 CEST              July 15, 2025 18:02:29 CEST              Failure\nCheck pre-check status                   node0                 July 15, 2025 18:09:43 CEST              July 15, 2025 18:09:43 CEST              Failure<\/code><\/pre>\n\n\n\n
Checking the log of the dcs agent, I could find following:<\/p>\n\n\n\n
\"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\\\"..\",<\/code><\/pre>\n\n\n\n
The describe job with –ecr option would give me the same:<\/p>\n\n\n\n
\n[root@node0 ~]# odacli describe-job -i 68d89fc0-d5ed-47b5-a885-a5896b865262 --ecr\nODA Assistant - Error Correlation report\n----------------------------------------\n          Failed job ID:  68d89fc0-d5ed-47b5-a885-a5896b865262\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n             Start Time:  July 15, 2025 14:59:12 CEST\n               End Time:  July 15, 2025 15:11:40 CEST\n         EC report path: \/opt\/oracle\/dcs\/da\/da_repo\/546ca4ac-97e6-4038-bf6d-90986c7f21bf.json\n\nFailed Task Messages\n--------------------\n[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.\n[task:TaskLockWrapper_37358] -  DCS-10292:One or more checks failed while checking for patching readiness.\n[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\"..\n...\n...\n...\n<\/pre>\n<\/br>\n\n\n\n
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!<\/p>\n\n\n\n
Resolution<\/h3>\n\n\n\n
I first checked and could confirm that my source dbhome really does not have any sqldeveloper foloder.<\/p>\n\n\n\n
\n[root@node0 ~]# ls -ld \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sql*\ndrwxr-xr-x 4 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlcl\ndrwxr-xr-x 3 oracle oinstall 20480 Apr 17  2019 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlj\ndrwxr-xr-x 7 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlpatch\ndrwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlplus\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
Looking quickly on the oracle support, I could find following Doc ID, which was exactly my problem:<\/p>\n\n\n\n
ODA db home prepatch report keeps running\/hangs at “Evaluate DBHome patching with RHP” (Doc ID 3067737.1)<\/p>\n\n\n\n
OK, but reading on the solution described in the Doc ID, it will not help me that much :<\/p>\n\n\n\n
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.\nThen re-run the dbhome patching which should complete without any issues.<\/code><\/pre>\n\n\n\n
Checking on an old backup I did few years ago I could find a sqldeveloper zip file in a patch storage directory.<\/p>\n\n\n\n
\noracle@node0:\/mnt\/tmp\/backup_dbhome\/tsrpri\/OraDB19000_home3\/ [DB11] tar tvf dbhome_3.tarz | grep -i sqldevelop\n-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\n<\/pre>\n<\/br>\n\n\n\n\n
I uncompressed the archive file, and extracted the content of the zip file.<\/p>\n\n\n\n
\n[oracle@node0 software_patching]$ unzip sqldeveloper.zip\nArchive:  sqldeveloper.zip\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6462746f6f6c732d6e65742e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6462746f6f6c732d636f6d6d6f6e2e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/636f6d6d6f6e732d6c6f6767696e672e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a6178622d6170692e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f6a646263382e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a61636b736f6e2d636f72652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6c6f772d6c6576656c2d6170692e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a61636b736f6e2d6461746162696e642e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f7261636c65706b692e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f7364745f636572742e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f72616931386e2e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/687474706d696d652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/786d6c70617273657276322d73616e732d6a6178702d73657276696365732e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/706c7567696e2d6170692e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a61636b736f6e2d616e6e6f746174696f6e732e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f72616931386e2d6d617070696e672e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/706f6d2e786d6c_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/636f6d6d6f6e732d636f6465632e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f72616a736f64612e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/616e746c722d72756e74696d652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6462746f6f6c732d73716c636c2e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a617661782e6a736f6e2e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f7364745f636f72652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/ext\/736c66346a2d6a646b31342e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/ext\/6c69717569626173652d636f72652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/ext\/6f7261636c652d6c69717569626173652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/ext\/736c66346a2d6170692e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6462746f6f6c732d687474702e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/68747470636c69656e742e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6f72616931386e2d7574696c6974792e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/737472696e6774656d706c6174652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a7363682e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/68747470636f72652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a6c696e652e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/786462362e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/lib\/6a7a6c69622e6a6172_o_\n  inflating: sqldeveloper\/sqldeveloper\/bin\/524541444d452e6d64_o_\n  inflating: sqldeveloper\/sqldeveloper\/bin\/73716c2e657865_o_\n  inflating: sqldeveloper\/sqldeveloper\/bin\/73716c_o_\n  inflating: sqldeveloper\/modules\/6a617661782e736572766c65742e6a617661782e736572766c65742d6170692e6a6172_o_\n[oracle@node0 software_patching]$\n<\/pre>\n<\/br>\n\n\n\n
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.<\/p>\n\n\n\n
\n[root@node0 ~]# ls -ld \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sql*\ndrwxr-xr-x 4 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlcl\ndrwxr-xr-x 3 oracle oinstall 20480 Apr 17  2019 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlj\ndrwxr-xr-x 7 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlpatch\ndrwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlplus\n\n[root@node0 ~]# cp -pR \/mnt\/tmp\/software_patching\/sqldeveloper \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/\n\n[root@node0 ~]# ls -ld \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sql*\ndrwxr-xr-x 4 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlcl\ndrwxr-xr-x 4 oracle oinstall 20480 Jul 15 17:00 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqldeveloper\ndrwxr-xr-x 3 oracle oinstall 20480 Apr 17  2019 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlj\ndrwxr-xr-x 7 oracle oinstall 20480 Jul 17  2023 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlpatch\ndrwxr-xr-x 6 oracle oinstall 20480 Apr 30 13:56 \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlplus\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
As expected there is no jar files in the copied directory.<\/p>\n\n\n\n
\n[root@node0 ~]# ls -ltrh \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqldeveloper\/sqldeveloper\/lib\/\ntotal 25M\n-rw-r--r-- 1 oracle oinstall 1.9M Jul 17  2023 786d6c70617273657276322d73616e732d6a6178702d73657276696365732e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 257K Jul 17  2023 786462362e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 222K Jul 17  2023 737472696e6774656d706c6174652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  11K Jul 17  2023 706f6d2e786d6c_o_\n-rw-r--r-- 1 oracle oinstall  73K Jul 17  2023 706c7567696e2d6170692e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 300K Jul 17  2023 6f7364745f636f72652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 201K Jul 17  2023 6f7364745f636572742e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 410K Jul 17  2023 6f72616a736f64612e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 1.6M Jul 17  2023 6f72616931386e2e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 490K Jul 17  2023 6f72616931386e2d7574696c6974792e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  88K Jul 17  2023 6f72616931386e2d6d617070696e672e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 301K Jul 17  2023 6f7261636c65706b692e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 4.0M Jul 17  2023 6f6a646263382e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 500K Jul 17  2023 6c6f772d6c6576656c2d6170692e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  65K Jul 17  2023 6a7a6c69622e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 276K Jul 17  2023 6a7363682e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 263K Jul 17  2023 6a6c696e652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 123K Jul 17  2023 6a6178622d6170692e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  84K Jul 17  2023 6a617661782e6a736f6e2e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 1.3M Jul 17  2023 6a61636b736f6e2d6461746162696e642e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 318K Jul 17  2023 6a61636b736f6e2d636f72652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  66K Jul 17  2023 6a61636b736f6e2d616e6e6f746174696f6e732e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  41K Jul 17  2023 687474706d696d652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 320K Jul 17  2023 68747470636f72652e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 749K Jul 17  2023 68747470636c69656e742e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 429K Jul 17  2023 6462746f6f6c732d73716c636c2e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 131K Jul 17  2023 6462746f6f6c732d6e65742e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  50K Jul 17  2023 6462746f6f6c732d687474702e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 7.1M Jul 17  2023 6462746f6f6c732d636f6d6d6f6e2e6a6172_o_\n-rw-r--r-- 1 oracle oinstall  61K Jul 17  2023 636f6d6d6f6e732d6c6f6767696e672e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 328K Jul 17  2023 636f6d6d6f6e732d636f6465632e6a6172_o_\n-rw-r--r-- 1 oracle oinstall 160K Jul 17  2023 616e746c722d72756e74696d652e6a6172_o_\ndrwxr-xr-x 2 oracle oinstall  20K Jul 15 17:00 ext\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
Strangely, the missing file the prepatch report is expecting, comes from sqlcl.<\/p>\n\n\n\n
\n[root@node0 ~]# ls -ltrh \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqlcl\/lib\ntotal 37M\n-rw-r--r-- 1 oracle oinstall 1.8M Jul 16  2023 ucp.jar\n-rw-r--r-- 1 oracle oinstall 8.3K Jul 16  2023 slf4j-jdk14.jar\n-rw-r--r-- 1 oracle oinstall 306K Jul 16  2023 osdt_core.jar\n-rw-r--r-- 1 oracle oinstall 206K Jul 16  2023 osdt_cert.jar\n-rw-r--r-- 1 oracle oinstall 441K Jul 16  2023 orajsoda.jar\n-rw-r--r-- 1 oracle oinstall 301K Jul 16  2023 oraclepki.jar\n-rw-r--r-- 1 oracle oinstall 126K Jul 16  2023 javax.json.jar\n-rw-r--r-- 1 oracle oinstall 237K Jul 16  2023 jansi.jar\n-rw-r--r-- 1 oracle oinstall  74K Jul 16  2023 jackson-annotations.jar\n-rw-r--r-- 1 oracle oinstall 2.8M Jul 16  2023 guava-with-lf.jar\n-rw-r--r-- 1 oracle oinstall 296K Jul 16  2023 dbtools-net.jar\n-rw-r--r-- 1 oracle oinstall 354K Jul 16  2023 commons-codec.jar\n-rw-r--r-- 1 oracle oinstall 1.9M Jul 16  2023 xmlparserv2_sans_jaxp_services.jar\n-rw-r--r-- 1 oracle oinstall 260K Jul 16  2023 xdb.jar\n-rw-r--r-- 1 oracle oinstall 248K Jul 16  2023 ST4.jar\n-rw-r--r-- 1 oracle oinstall 361K Jul 16  2023 sshd-sftp.jar\n-rw-r--r-- 1 oracle oinstall 120K Jul 16  2023 sshd-scp.jar\n-rw-r--r-- 1 oracle oinstall 920K Jul 16  2023 sshd-core.jar\n-rw-r--r-- 1 oracle oinstall  42K Jul 16  2023 sshd-contrib.jar\n-rw-r--r-- 1 oracle oinstall 921K Jul 16  2023 sshd-common.jar\n-rw-r--r-- 1 oracle oinstall  41K Jul 16  2023 slf4j-api.jar\n-rw-r--r-- 1 oracle oinstall 496K Jul 16  2023 orai18n-utility.jar\n-rw-r--r-- 1 oracle oinstall  89K Jul 16  2023 orai18n-mapping.jar\n-rw-r--r-- 1 oracle oinstall 1.6M Jul 16  2023 orai18n.jar\n-rw-r--r-- 1 oracle oinstall 4.9M Jul 16  2023 ojdbc8.jar\n-rw-r--r-- 1 oracle oinstall 976K Jul 16  2023 jline3.jar\n-rw-r--r-- 1 oracle oinstall 376K Jul 16  2023 jdbcrest.jar\n-rw-r--r-- 1 oracle oinstall 126K Jul 16  2023 jaxb-api.jar\n-rw-r--r-- 1 oracle oinstall  56K Jul 16  2023 javax.activation-api.jar\n-rw-r--r-- 1 oracle oinstall  28K Jul 16  2023 jackson-jr-stree.jar\n-rw-r--r-- 1 oracle oinstall  98K Jul 16  2023 jackson-jr-objects.jar\n-rw-r--r-- 1 oracle oinstall 367K Jul 16  2023 jackson-core.jar\n-rw-r--r-- 1 oracle oinstall 830K Jul 16  2023 httpcore5.jar\n-rw-r--r-- 1 oracle oinstall 780K Jul 16  2023 httpclient5.jar\n-rw-r--r-- 1 oracle oinstall 693K Jul 16  2023 dbtools-sqlcl.jar\n-rw-r--r-- 1 oracle oinstall  80K Jul 16  2023 dbtools-http.jar\n-rw-r--r-- 1 oracle oinstall 131K Jul 16  2023 dbtools-datapump.jar\n-rw-r--r-- 1 oracle oinstall 486K Jul 16  2023 dbtools-data.jar\n-rw-r--r-- 1 oracle oinstall 7.5M Jul 16  2023 dbtools-common.jar\n-rw-r--r-- 1 oracle oinstall  63K Jul 16  2023 commons-logging.jar\n-rw-r--r-- 1 oracle oinstall 164K Jul 16  2023 antlr-runtime.jar\ndrwxr-xr-x 2 oracle oinstall  20K Jul 17  2023 ext\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
So I decided to copy the files to my new sqldeveloper lib folder.<\/p>\n\n\n\n
\n[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\/\n\n[root@node0 ~]# ls -ltrh \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqldeveloper\/sqldeveloper\/lib\/*.jar\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n-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\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
I did the same for the missing file in the bin directory.<\/p>\n\n\n\n
\n[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\/\n\n[root@node0 ~]# ls -ltrh \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/sqldeveloper\/sqldeveloper\/bin\ntotal 372K\n-rw-r--r-- 1 oracle oinstall  119 Jul 16  2023 version.txt\n-rwxr-xr-x 1 oracle oinstall 148K Jul 16  2023 sql.exe\n-rwxr-xr-x 1 oracle oinstall  21K Jul 16  2023 sql\n-rw-r--r-- 1 oracle oinstall 2.4K Jul 16  2023 README.md\n-rw-r--r-- 1 oracle oinstall 4.3K Jul 16  2023 license.txt\n-rwxr-xr-x 1 oracle oinstall 1.2K Jul 16  2023 dependencies.txt\n-rw-r--r-- 1 oracle oinstall  15K Jul 17  2023 73716c_o_\n-rw-r--r-- 1 oracle oinstall 126K Jul 17  2023 73716c2e657865_o_\n-rw-r--r-- 1 oracle oinstall  419 Jul 17  2023 524541444d452e6d64_o_\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
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.<\/p>\n\n\n\n
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).<\/p>\n\n\n\n
\n[root@node0 ~]# find \/u01\/app\/odaorahome\/oracle\/ -name low-level-api.jar\n\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_5\/sqlcl\/lib\/low-level-api.jar\n<\/pre>\n<\/br>\n\n\n\n
I decided to copy it as well to the source sqldeveloper lib folder.<\/p>\n\n\n\n
\n[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\/\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
And I run the prepatch again.<\/p>\n\n\n\n
\n[root@node0 ~]# \/opt\/oracle\/dcs\/bin\/odacli create-prepatchreport --dbhome --dbhomeid 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0\n\nJob details\n----------------------------------------------------------------\n                     ID:  fe0dfd66-79b8-4f38-afe2-b2cef1d15943\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  Created\n                Created:  July 15, 2025 17:37:31 CEST\n                Message:  Use 'odacli describe-prepatchreport -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943' to check details of results\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n\n
Which that time was successfull!<\/p>\n\n\n\n
\n[root@node0 ~]# odacli describe-job -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943\n\nJob details\n----------------------------------------------------------------\n                     ID:  fe0dfd66-79b8-4f38-afe2-b2cef1d15943\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  Success\n                Created:  July 15, 2025 17:37:31 CEST\n                Message:  Successfully finished prechecking for patching the databases [DB1_IWB] with rolling option\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nSetting up SSH equivalence               node0                 July 15, 2025 17:37:37 CEST              July 15, 2025 17:37:39 CEST              Success\nSetting up SSH equivalence               node0                 July 15, 2025 17:37:39 CEST              July 15, 2025 17:37:40 CEST              Success\nRun patching pre-checks                  node0                 July 15, 2025 17:37:40 CEST              July 15, 2025 17:47:11 CEST              Success\nPrecheck Patch databases by RHP          node0                 July 15, 2025 17:38:05 CEST              July 15, 2025 17:39:56 CEST              Success\nTDE parameter update                     node1                 July 15, 2025 17:39:56 CEST              July 15, 2025 17:39:56 CEST              Success\n\n[root@node0 ~]# odacli describe-prepatchreport -i fe0dfd66-79b8-4f38-afe2-b2cef1d15943\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  fe0dfd66-79b8-4f38-afe2-b2cef1d15943\n            Description:  Patch pre-checks for [DB, ORACHKDB] to 19.26.0.0: DbHome is OraDB19000_home1\n                 Status:  SUCCESS\n                Created:  July 15, 2025 5:37:31 PM CEST\n                 Result:  All pre-checks succeeded\n\nNode Name\n---------------\nnode0\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          5fc7e39d-adff-4903-b308-b4046840a38f\nValidate patching tag           Success   Validated patching tag: 19.26.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\nValidate glogin.sql file        Success   Successfully verified glogin.sql\n                                          won't break patching\nValidate dbHomesOnACFS          Success   User has configured disk group for\nconfigured                                Database homes on ACFS\nValidate Oracle base            Success   Successfully validated Oracle Base\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nEvaluate DBHome patching with   Success   Successfully validated updating\nRHP                                       dbhome with RHP.  and local patching\n                                          is possible\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\nNode Name\n---------------\nnode1\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          5fc7e39d-adff-4903-b308-b4046840a38f\nValidate patching tag           Success   Validated patching tag: 19.26.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\nValidate glogin.sql file        Success   Successfully verified glogin.sql\n                                          won't break patching\nValidate dbHomesOnACFS          Success   User has configured disk group for\nconfigured                                Database homes on ACFS\nValidate Oracle base            Success   Successfully validated Oracle Base\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nEvaluate DBHome patching with   Success   Successfully validated updating\nRHP                                       dbhome with RHP.  and local patching\n                                          is possible\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\n\n\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
And, of course, later in my activities during the maintenance windows, the patching of the dbhome was successful.<\/p>\n\n\n\n
\n[root@node0 ~]# \/opt\/oracle\/dcs\/bin\/odacli update-dbhome -i 5fc7e39d-adff-4903-b308-b4046840a38f -v 19.26.0.0.0\n{\n  \"jobId\" : \"b4467935-edd0-46a6-8c84-04e216d05973\",\n  \"status\" : \"Created\",\n  \"message\" : \"\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"July 16, 2025 00:21:17 CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"DB Home Patching to 19.26.0.0.0: Home ID is 5fc7e39d-adff-4903-b308-b4046840a38f\",\n  \"updatedTime\" : \"July 16, 2025 00:21:17 CEST\",\n  \"jobType\" : null,\n  \"cpsMetadata\" : null\n}\n[root@node0 ~]#\n\n[root@node0 ~]# odacli describe-job -i b4467935-edd0-46a6-8c84-04e216d05973\n\nJob details\n----------------------------------------------------------------\n                     ID:  b4467935-edd0-46a6-8c84-04e216d05973\n            Description:  DB Home Patching to 19.26.0.0.0: Home ID is 5fc7e39d-adff-4903-b308-b4046840a38f\n                 Status:  Success\n                Created:  July 16, 2025 00:21:17 CEST\n                Message:\n\nTask Name                                Node Name                 Start Time                               End Time                                 Status\n---------------------------------------- ------------------------- ---------------------------------------- ---------------------------------------- ----------------\nCreating wallet for DB Client            node0                 July 16, 2025 00:21:52 CEST              July 16, 2025 00:21:53 CEST              Success\nPatch databases by RHP - [DB1]           node0                 July 16, 2025 00:21:53 CEST              July 16, 2025 00:27:37 CEST              Success\nUpdating database metadata               node1                 July 16, 2025 00:27:37 CEST              July 16, 2025 00:27:37 CEST              Success\nSet log_archive_dest for Database        node0                 July 16, 2025 00:27:37 CEST              July 16, 2025 00:27:38 CEST              Success\nGenerating and saving BOM                node0                 July 16, 2025 00:27:39 CEST              July 16, 2025 00:28:30 CEST              Success\nGenerating and saving BOM                node1                 July 16, 2025 00:27:39 CEST              July 16, 2025 00:28:32 CEST              Success\nTDE parameter update                     node1                 July 16, 2025 00:29:23 CEST              July 16, 2025 00:29:23 CEST              Success\n\n[root@node0 ~]#\n<\/pre>\n<\/br>\n\n\n\n
To wrap up…<\/h3>\n\n\n\n
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.<\/p>\n\n\n\n
I had to run the same resolution for all my dbhome on the primary and standby side.<\/p>\n","protected":false},"excerpt":{"rendered":"
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. […]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2567,2576],"type_dbi":[],"class_list":["post-39571","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oda-2","tag-patching-2"],"acf":[],"yoast_head":"\ndbhome prepatch failing on ODA due to missing sqldeveloper files - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"dbhome prepatch failing on ODA due to missing sqldeveloper files\" \/>\n<meta property=\"og:description\" content=\"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. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-21T06:40:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-21T06:40:37+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"dbhome prepatch failing on ODA due to missing sqldeveloper files\",\"datePublished\":\"2025-07-21T06:40:35+00:00\",\"dateModified\":\"2025-07-21T06:40:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\"},\"wordCount\":733,\"commentCount\":0,\"keywords\":[\"oda\",\"patching\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\",\"name\":\"dbhome prepatch failing on ODA due to missing sqldeveloper files - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2025-07-21T06:40:35+00:00\",\"dateModified\":\"2025-07-21T06:40:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"dbhome prepatch failing on ODA due to missing sqldeveloper files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"dbhome prepatch failing on ODA due to missing sqldeveloper files - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/","og_locale":"en_US","og_type":"article","og_title":"dbhome prepatch failing on ODA due to missing sqldeveloper files","og_description":"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. […]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/","og_site_name":"dbi Blog","article_published_time":"2025-07-21T06:40:35+00:00","article_modified_time":"2025-07-21T06:40:37+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"dbhome prepatch failing on ODA due to missing sqldeveloper files","datePublished":"2025-07-21T06:40:35+00:00","dateModified":"2025-07-21T06:40:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/"},"wordCount":733,"commentCount":0,"keywords":["oda","patching"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/","url":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/","name":"dbhome prepatch failing on ODA due to missing sqldeveloper files - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-07-21T06:40:35+00:00","dateModified":"2025-07-21T06:40:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbhome-prepatch-failing-on-oda-due-to-missing-sqldeveloper-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"dbhome prepatch failing on ODA due to missing sqldeveloper files"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=39571"}],"version-history":[{"count":11,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39571\/revisions"}],"predecessor-version":[{"id":39582,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39571\/revisions\/39582"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=39571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=39571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=39571"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=39571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}