After Upgrade Oid Status Shows Invalid In dba_registry and app_registry tables (Doc ID 728620.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Internet Directory - Version 10.1.2.0.2 to 10.1.4.3 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.

Symptoms

OID showing as INVALID in dba_registry and app_registry tables.

select * from dba_registry where status='INVALID' and

select * from app_registry where status ='INVALID'



The output of the SELECT comp_id,version,status FROM app_registry is as follows,

COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
SYNDICATION 10.1.2.0.2 VALID
PORTAL 10.1.2.0.2 VALID
SSO 10.1.4.0.1 VALID
WORKFLOW 10.1.2.0.2 VALID
B2B 10.1.2.0.2 VALID
BAM 10.1.2.0.2 VALID
MRC 10.1.2.0.2 VALID
OCA 10.1.2.0.2 VALID
OID 10.1.4.0.1 INVALID
DCM 10.1.2.0.2 VALID
DISCOVERER 10.1.2.0.2 VALID

COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
WCS 10.1.2.0.2 VALID
UDDI 10.1.2.0.2 VALID
WIRELESS 10.1.2.0.2 VALID



OID showing as invalid in dba_registry and app_registry tables, however when viewing ODS objects -- all are valid

SQL> select owner,object_name,object_type from dba_objects where owner='ODS' and status='INVALID';

 

Changes


Upgrade of the product

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms