ORA-01400: Cannot Insert NULL Into ("DVSYS"."REALM_OBJECT$"."OWNER_UID#") (Doc ID 2949214.1)

Last updated on AUGUST 06, 2023

Applies to:

Symptoms

Following errors are seen when running the datapatch -verbose

Patch apply: WITH ERRORS

-> Error at line 163668: script rdbms/admin/catmacd.sql
- ORA-01400: cannot insert NULL into ("DVSYS"."REALM_OBJECT$"."OWNER_UID#")
- ORA-06512: at line 7
- ORA-06512: at line 2
-> Error at line 163950: script rdbms/admin/catmacd.sql
- ORA-01400: cannot insert NULL into ("DVSYS"."REALM_OBJECT$"."OWNER_UID#")
- ORA-06512: at line 7
- ORA-06512: at line 2
-> Error at line 165457: script rdbms/admin/catmacd.sql
- ORA-01400: cannot insert NULL into ("DVSYS"."REALM_AUTH$"."GRANTEE_UID#")
- ORA-06512: at line 7
- ORA-06512: at line 2
-> Error at line 166581: script rdbms/admin/catmacd.sql
- ORA-04063: package body "DVSYS.DBMS_MACADM" has errors
- ORA-06508: PL/SQL: could not find program unit being called:
- "DVSYS.DBMS_MACADM"
- ORA-06512: at line 2

Changes

 Running data patch after application of RU

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.