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';

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.