Saturday 4 March 2017

[Solved]Automatically objects are getting invalid after some days.

Issue:
we have facing some issue that some objects are automatically gets invalid after some days.
after running script utlrp.sql it will get valid but issue comes again after some days.

Solution:
Please follow the below steps.
1) Run 'Re-create grants and synonyms for APPS schema' in adadmin.
2) As sysdba, run the following twice in order to compile any dependent objects
SQL > @?/rdbms/admin/utlrp.sql
3) Run 'Compile APPS Schema' in adadmin
4) Run 'Validate APPS Schema' in adadmin
5) Run the following report:
$AD_TOP/sql/adutconf.sql


I hope issue has been resolved invalid objects.

No comments:

Post a Comment