Renetta.nl

Oid Shows Status Invalid In dba_registry and app_registry tables

Deze foutmelding kan voorkomen na een update van de Oracle Internet Directory. De oplossing is te vinden op Oracle Support (Metalink) onder document id 374304.1
De oplossing is als volgt:

# Review $ORACLE_HOME/ldap/admin/LOGS/ldapupgrade.log
Check for any errors or messages.
– If any significant problems are seen, correct them and rerun oidiugrd.sql
– If no problems are found, or invalid status persists after rerunning, continue with the following steps:

# Check the ODS schema for invalid objects and correct as necessary

% sqlplus / as sysdba
SQL> select owner,object_name,object_type from dba_objects
2> where owner=’ODS’ and status=’INVALID’;

# Cut the final validation portion of oidiugrd.sql and run it by itself:

alter session set current_schema = SYS;

execute DBMS_IAS_VERSION.SET_COMPONENT_UPGRADED(COMPONENT_ID=>’OID’);
declare
rc integer;
begin
rc := ods.ldapUpgUtls.validateODS();
if rc = 0 then
DBMS_IAS_VERSION.SET_COMPONENT_VALID(COMPONENT_ID=>’OID’);
else
DBMS_IAS_VERSION.SET_COMPONENT_INVALID(COMPONENT_ID=>’OID’);
end if;
end;