Recompile Invalid objects in oracle database

Below Scripts can be used for making the database objects valid

set feedback off
      set verify off
      set echo off
      set pagesize 0
      set heading off
      spool compile_invalid_objects

select  'alter ' ||
             decode(object_type, 'PACKAGE BODY', 'package', object_type) ||
             ' ' ||owner ||'.'||
             object_name||
             ' compile' ||
             decode(object_type, 'PACKAGE BODY', ' body;', ';')
      from   dba_objects
      where  status = 'INVALID';

      spool off
      set feedback on
      set verify on
      set heading on
      set pagesize 40
      @compile_invalid_objects