Symptom
Executing catsbp fails with below error:
Prerequisite check failed:
Cause: The history of patch 32218454/24018797 in the database is in a
state that this script cannot process.
Action: Open an SAP incident using component BC-DB-ORA and provide
the log file generated by this script.
catsbp completed with errors, post-installation of this SAP Bundle
Patch is INCOMPLETE.
Further upwards in the logfile, we see RU and 'Interim Patch' got applied at once (INSTA = <the same number for all affected entries>). While the actual timestamp of the OS is still before the ACTION_TIME
Dumping registry$sqlpatch...
select install_id, patch_id, patch_uid, patch_type, action, action_time, status, source_version, target_version, nvl( description, 'NONE' ), logfile from registry$sqlpatch order by action_time;
INSTA PATCH_ID PATCH_UID PATCH_TYPE ACTION ACTION_TIME STATUS SOURCE_VERSI TARGET_VERSI DESCRIPTION LOGFILE
1 32218454 24018797 RU APPLY 05-MAY-2021 04:15:46 SUCCESS 19.1.0.0.0 19.10.0.0.0 Database Release Update : 19.10.0.0.210119 (322184 /oracle/BM0/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_BM0_2021May05_04_10_37.log
1 32308618 24027550 INTERIM APPLY 05-MAY-2021 04:15:47 SUCCESS 19.1.0.0.0 19.1.0.0.0 MERGE ON DATABASE RU 19.10.0.0.0 OF 28357349 28555 /oracle/BM0/cfgtoollogs/sqlpatch/32308618/24027550/32308618_apply_BM0_2021May05_04_11_39.log
1 32395634 24023078 INTERIM APPLY 05-MAY-2021 04:15:47 SUCCESS 19.1.0.0.0 19.1.0.0.0 MERGE ON DATABASE RU 19.10.0.0.0 OF 27957963 28052 /oracle/BM0/cfgtoollogs/sqlpatch/32395634/24023078/32395634_apply_BM0_2021May05_04_15_41.log
3 rows selected.
If you would have used catsbp instead as documented in the SBP readme, not calling datapatch directly, catsbp would have called datapatch multiple times to always execute only one action at a time, thus being able to vaildate if the datapatch action was successful or not for this particular datapatch action.
catsbp would stop if the return code isn't SUCCESS and won't continue with the next datapatch call.
With catsbp being used, you'd see only one action listed per install_id .
in the database is in a stat that this script cannot process""> Read more...
Environment
- Linux / UNIX Operating System
- as of Oracle RDBMS 19c
- SAP Netweaver
- SAP Solution Manager
Product
Keywords
catsbp, datapatch, SGR, SBP, oracle, opatch, mopatch, bundle patch, error, 19c, 19, The history of path in the database is in a stat that this script cannot process , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.