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.
SAP Knowledge Base Article - Preview