Translate

Monday, July 7, 2014

Find Invalid Objects in Oracle DBA

An Simple Sql Script can help you to Find all the Invalid Objects

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)


No comments:

Post a Comment