SAP Knowledge Base Article - Preview

3421076 - SBP Oracle DB upgrade . . . DBJ_SHORT_NAME INVALID . . . JAVAVM INVALID INCOMPLETE INVALID OBJECTS

Symptom

   Overall Status: INCOMPLETE, WARNINGS
   . . .
   SELECT owner,
         object_type,
         object_name,
         status
   FROM   dba_objects
   WHERE  status = 'INVALID'
   ORDER BY owner, object_type, object_name;
   
   OWNER  OBJECT_TYPE  OBJECT_NAME        STATUS
   ------ ------------ ------------------ -------
   PUBLIC SYNONYM      DBJ_SHORT_NAME     INVALID
   SYS    FUNCTION     DBJ_SHORT_NAME     INVALID
   SYS    PACKAGE BODY DBMS_JVM_EXP_PERMS INVALID

   select comp_id, version_full, status, modified from dba_registry order by comp_id;
   COMP_ID VERSION_FULL STATUS MODIFIED
   --------------------------------- --------------------------
   CATALOG 19.21.0.0.0 VALID 19-DEC-2023 24:mm:ss
   CATPROC 19.21.0.0.0 VALID 19-DEC-2023 24:mm:ss
   JAVAVM 19.21.0.0.0 INVALID 19-DEC-2023 24:mm:ss
   RAC 19.21.0.0.0 OPTION OFF 22-OCT-2021 24:mm:ss
   XDB 19.21.0.0.0 VALID 19-DEC-2023 24:mm:ss
   XML 19.21.0.0.0 VALID 19-DEC-2023 24:mm:ss
   6 rows selected


Read more...

Environment

Oracle LINUX.X64

   here are last 9 rows . . . of dba_registry_history
   select action_time, action, namespace, comments from dba_registry_history order by action_time asc;
   . . .
   14-JAN-20 02.39.02.123785 PM APPLY SERVER SBP 12.1.0.2.190716 201908 containing CPUJul2019
   22-OCT-21 09.32.45.233118 PM RU_APPLY SERVER Patch applied on 19.11.0.0.0: Release_Update - 210413004009
   22-OCT-21 09.49.34.114017 PM UPGRADE SERVER Upgraded from 12.1.0.2.0 to 19.11.0.0.0
   06-OCT-22 10.12.31.155626 AM RU_APPLY SERVER Patch applied from 19.11.0.0.0 to 19.14.0.0.0: Release_Update - 211225122123
                                BOOTSTRAP DATAPATCH RDBMS_19.21.0.0.0DBRU_LINUX.X64_230923
   19-DEC-23 03.54.00.884037 PM INCOMPLAPL SERVER SBP 19.21.0.0.231017 202311 containing CPUOct2023
   19-DEC-23 03.57.27.377708 PM RU_APPLY SERVER Patch applied from 19.14.0.0.0 to 19.21.0.0.0: Release_Update - 230930151951
   19-DEC-23 04.06.34.553370 PM INCOMPLAPL SERVER SBP 19.21.0.0.231017 202311 containing CPUOct2023
   19-DEC-23 04.15.33.602308 PM INCOMPLAPL SERVER SBP 19.21.0.0.231017 202311 containing CPUOct2023
   24 rows selected

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-ORA-RAC , Real Application Clusters (RAC) , 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.