Oracle XDK invalid issue in DBA Registry

Validate the Oracle XDK component in Oracle Registry

Error: Invalid the ORacle SDK component in Oracle Registry table:

set pagesize 1000
COLUMN comp_name format a30
COLUMN version format a20
COLUMN status format a20
select comp_name,version,status from dba_registry where comp_name='Oracle XDK';

COMP_NAME                      VERSION              STATUS
------------------------------ -------------------- --------------------
Oracle XDK                     18.0.0.0.0           INVALID

Solution:

  1. Check the invalid objects present in the database.
select object_name,object_type from dba_objects where status='INVALID';

2. If we have invalid objects then we will compile them manually or with utlrp.sql

@?\rdbms\admin\utlrp.sql;

or 

ALTER PROCEDURE procedurename compile;

3. Verify the registry entry for the XDB component if remains invalid then we need to execute XDK scripts for recreating before it takes a complete backup of the database:

sqlplus / as sysdba

%ORACLE_HOME%\xdk\admim\rmxml.sql
%ORACLE_HOME%\xdk\admin\initxml.sql

4. Verify again:

set pagesize 1000
COLUMN comp_name format a30
COLUMN version format a20
COLUMN status format a20
select comp_name,version,status from dba_registry where comp_name='Oracle XDK';