Compiling Invalid Objects in Oracle Database

 UTLRP.sh (script)

1^st – sshsu ora _ _ _ _

2^nd – Check to make sure utlrp.sh script is in ORACLE_HOME

>cd $ORACLE_HOME

>cd rdbms/admin/utlrp.sh

3^rd – logon to sqlplus (as sysdba)

            >sqlplus ‘/as sysdba’

4^th – Run query to count how many invalid objects in the instance

            > SELECT COUNT(*) "num_invalid_objects"

   FROM DBA_OBJECTS

   WHERE STATUS = 'INVALID'

   and OWNER NOT IN ('NOETIX', 'NOETIX_SYS');

5^th – Run the UTLRP script

            >@utlrp

6^th – Run the query to count invalid objects again, the number must go down.

            > SELECT COUNT(*) "num_invalid_objects"

   FROM DBA_OBJECTS

   WHERE STATUS = 'INVALID'

   and OWNER NOT IN ('NOETIX', 'NOETIX_SYS') ;