2125248 - Is it necessary to execute catsbp or datapatch scripts?

Not executing the post-installation instructions after a systemcopy (export/import method with create database), Oracle database upgrade or Oracle Software installation, may leave the database in a not completely consistent state regarding the correspondence between Oracle binaries on the OS level and the definitions in the system tablespace and thus lead to undesirable result.

As a consequence dba_registry_history / dba_registry_sqlpatch may not list the applied SBP (Bundle Patch), while "opatch lsinventory" shows the same SBP (Bundle Patch) as installed.

Below you can see a BAD and a GOOD SBP installation

BAD installation (NOTE: SBP 201902 is listed by "opatch lsinventory" BUT NOT SHOWN in dba_registry... views"!)

opatch lsinventory

Patch 28822515 : applied on Wed May 15 04:47:16 CEST 2019
Unique Patch ID: 22643236
Patch description: "Database Jan 2019 Release Update : 12.2.0.1.190115 (28822515)"
Created on 22 Dec 2018, 23:13:23 hrs PST8PDT

dba_registry_history

ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS
------------------------------- ----------------- ---------- ----------- ------- ------------------------------------------------------
BOOTSTRAP DATAPATCH 12.2.0.1 RDBMS_12.2.0.1.0DBJAN2019RU_HPUX.IA64_181203
15-MAY-19 09.05.26.870714000 AM VIEW INVALIDATE 8289601 view invalidation
15-MAY-19 09.29.50.031087000 AM UPGRADE SERVER 12.2.0.1.0 Upgraded from 11.2.0.4.0
<Missing entry for SBP 190115>

dba_registry_sqlpatch

PATCH_ID PATCH_UID VERSION FLAGS ACTION STATUS INSTALL_ID ACTION_TIME DESCRIPTION
---------- ---------- ---------- ---------- ------ --------- ---------- ------------------------------- -----------------------------------------
<Missing entry for SBP 190115>
27759232 22342531 12.2.0.1 N APPLY SUCCESS 1 15-MAY-19 09.59.43.222304000 AM DBMS_INMEMORY_ADMIN API POPULATE_WAIT() 
28697806 22670910 12.2.0.1 N APPLY SUCCESS 1 15-MAY-19 09.59.43.367897000 AM ILM/KDILM JOB OVERWRITES COMPLETION_TIME

GOOD installation (NOTE: SBP 201902 is listed by "opatch lsinventory" AND shown in dba_registry... views!)

opatch lsinventory

Patch 28822489 : applied on Wed Apr 03 13:20:16 CEST 2019
Unique Patch ID: 22669539
Patch description: "Database Release Update : 18.5.0.0.190115 (28822489)"
Created on 18 Dec 2018, 22:44:52 hrs PST8PDT

dba_registry_history

ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS
------------------------------ --------------- --------- ---------- ---------- --------------------------------------------------
BOOTSTRAP DATAPATCH 18 RDBMS_18.5.0.0.0DBRU_LINUX.X64_181215
05-APR-19 04.15.26.270630 PM VIEW INVALIDATE 8289601 view invalidation
05-APR-19 04.15.31.833972 PM UPGRADE SERVER 18.0.0.0.0 Upgraded from 12.2.0.1.0 to 18.5.0.0.0
06-APR-19 02.10.08.418468 PM APPLY SERVER 18.0.0.0 201902 SBP 18.5.0.0.190115 201902 containing CPUJan2019 

dba_registry_sqlpatch
 

PATCH_ID PATCH_UID PATCH_TYPE ACTION STATUS ACTION_TIME DESCRIPTION
---------- ---------- ---------- ------ ------- ------------------------------ ----------------------------------------------------------------------------------------------------
28822489 22669539 RU APPLY SUCCESS 05-APR-19 04.15.24.434509 PM Database Release Update : 18.5.0.0.190115 (28822489)
27144324 22642481 INTERIM APPLY SUCCESS 05-APR-19 04.34.41.132354 PM LONG WAIT TIME AT THE END OF 12.2.0.1 DATAPUMP EXPORT JOB
27759232 22405754 INTERIM APPLY SUCCESS 05-APR-19 04.34.41.140937 PM DBMS_INMEMORY_ADMIN API POPULATE_WAIT()
28697806 22650036 INTERIM APPLY SUCCESS 05-APR-19 04.34.41.201583 PM ILM/KDILM JOB OVERWRITES COMPLETION_TIME

• Oracle Release Independent
• SAP Release Independent
• Windows
• LINUX/UNIX

SWPM, SAPINST, system copy, catwinbundle, dba_registry_history, bundle, fix, bug, issue, error, patch, bundlepatch,dbbp,sbp, catsbp, datapatch, dba_registry_sqlpatch, sqlpatch , KBA , BC-DB-ORA , Oracle , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , How To