Validate Oracle XDB

XDB.PATH_VIEW is INVALID

In few cases Oracle XDB becomes Invalid and if it needs to be validated again without reinstalling the below work around might work.

Error:

XDB.PATH_VIEW and XDB.XDB_PV_TRIG are in INVALID state 

Fix:

To validate XDB, upgrade table XDB.XDB$H_LINK, then recompile the invalid objects.

Action Plan:

connect / as sysdba

alter table XDB.XDB$H_LINK upgrade;

alter view XDB.PATH_VIEW compile;

alter trigger XDB.XDB_PV_TRIG compile;

Check the XDB Component:

select comp_name,version,Version_Full,status from dba_registry where comp_id = 'XDB';

The XDB should be validated now. If this does not work then you need to reinstall the XDB and befor doing that please consult Oracle, as it might corrupt some dependent XML attributes in other tables. 

You can follow XDB Reinstall to reinstall the XDB.

OR,

Alternative Method for Re Installing:

1. Export any custom tables that has XML type, using Data Pump:

2. Deinstall and reinstall XDB

spool xdb_reinstall.log

set echo on;

connect / as sysdba

shutdown immediate

startup

@?/rdbms/admin/prvtnoqm.plb

@?/rdbms/admin/catproc.sql

@?/rdbms/admin/utlrp.sql

set pagesize 1000

set linesize 150

col comp_name format a36

col version format a12

col status format a8

col owner format a12

col object_name format a35

col object_type format a20

col name format a35

select comp_name, version, status from dba_registry order by status, comp_name;

select owner, object_name, object_type, status 

from dba_objects

where status = 'INVALID'

and owner in ('SYS', 'XDB')

order by owner, object_name;

select owner, name, type, text

from dba_errors

where owner in ('SYS', 'XDB')

order by owner, name;

spool off;

3. Drop the tables in step 1 and import them from the dump file.

Best Wishes!!