I usually don't work on 11g OID,but was helping out a team here.Issue comes on OID version 10.1.2.0.2 to 10.1.4.3
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'
OID shows invalid.
OID 10.1.4.0.1 INVALID
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';
This could be caused due to possible problem with upgrade script (oidiugrd.sql).OID showing as invalid in dba_registry and app_registry tables, however when viewing ODS objects -- all are valid
Errors can be found in $ORACLE_HOME/ldap/admin/LOGS/ldapupgrade.log
Fix
===
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;
/
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'
OID shows invalid.
OID 10.1.4.0.1 INVALID
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';
This could be caused due to possible problem with upgrade script (oidiugrd.sql).OID showing as invalid in dba_registry and app_registry tables, however when viewing ODS objects -- all are valid
Errors can be found in $ORACLE_HOME/ldap/admin/LOGS/ldapupgrade.log
Fix
===
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;
/
No comments:
Post a Comment