how to compile invalid objects.

1- log in to unix or linux as applmgr user.

2-Find the number of invalid objects:

SQL>sqlplus apps/passwd


SQL>select count(*) from dba_objects where status=’INVALID’;


You can use utlrp.sql script to compile invalid objects

$cd $ORACLE_HOME/rdbms/admin

SQL>@utlrp.sql


After that check again by using same sql statement

SQL>select count(*) from dba_objects where status=’INVALID’;