After Upgrade Oid Status Shows Invalid In dba_registry and app_registry tables
(Doc ID 728620.1)
Last updated on AUGUST 18, 2020
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |