An Simple Sql Script can help you to Find all the Invalid Objects
select count(*) from dba_objects where status = 'INVALID';
select count(*) from dba_objects where status = 'INVALID';
If the count is large, proceed with step 5.
Otherwise, proceed with step 9
Compile Invalid Packages
adadmin
Compile/Reload Applications Database Entities menu
Compile APPS schema
Re-create Missing Grants/Synonyms
adadmin
Maintain Applications Database Entities
Re-create grants and synonyms for APPS schema
Validate APPS Schema
adadmin
Maintain Applications Database Entities
Validate APPS schema
Check the output of Validate APPS schema (in APPS.lst)
Make sure there are no invalid objects and no missing grants/synonyms
If there are you can repeat the above steps
Check for the number of invalid objects (should be minimal)
Otherwise, proceed with step 9
Compile Invalid Packages
adadmin
Compile/Reload Applications Database Entities menu
Compile APPS schema
Re-create Missing Grants/Synonyms
adadmin
Maintain Applications Database Entities
Re-create grants and synonyms for APPS schema
Validate APPS Schema
adadmin
Maintain Applications Database Entities
Validate APPS schema
Check the output of Validate APPS schema (in APPS.lst)
Make sure there are no invalid objects and no missing grants/synonyms
If there are you can repeat the above steps
Check for the number of invalid objects (should be minimal)
No comments:
Post a Comment