RCU-6083:Failed - Check prerequisites requirement for selected component:OIM

Error: XDB is installed on the database with some errors. Objects in XDB schema are in unusable \ invalid state

1) Check for Invalid objects of XDB Schema

Login to Oracle Database as sysdba

SQL> select * from dba_objects where status='INVALID' and owner='XDB';

It will return Invalid Objects

Then we need to compile those invalid objects

SQL> exec dbms_utility.compile_schema(schema=>'XDB');

Again check for Invalid Objects

SQL> select * from dba_objects where status='INVALID' and owner='XDB';

If there is no Data return by this Select Statement then all Invalid objects are compiled

Error: Oracle TEXT is installed on the database with some errors. Objects in CTXSYS schema are in unusable\invalid state.

1) Check for Invalid objects of CTXSYS Schema

Login to Oracle Database as sysdba

SQL> select * from dba_objects where status='INVALID' and owner='CTXSYS';

It will return Invalid Objects

Then we need to compile those invalid objects

SQL> exec dbms_utility.compile_schema(schema=>'CTXSYS');

Again check for Invalid Objects

SQL> select * from dba_objects where status='INVALID' and owner='CTXSYS';

If there is no Data return by this Select Statement then all Invalid objects are compiled