SAP Knowledge Base Article - Preview

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

Symptom

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

 

 


Read more...

Environment

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

Product

SAP ERP 6.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.