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
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.