Step to validate objects which are not compiled by adadmin in Oracle Application

Please Visit http://www.conacent.com/?page_id=218


Workdone
After Database upgrade.

CauseSome of the existing packages might get invalidated in the process. Therefore the packages could not be recompiled.

SolutionRunning the scripts utlirp.sql and utlrp.sql after the upgrade should resolve the issue. The scripts should be run in the below way:

Shutdown the database and start it up in upgrade mode from SQL*Plus run

$su - testora
$cd $ORACLE_HOME/rdbms/admin
$sqlplus "/as sysdba"

SQL>startup upgrade;
SQL>@utlirp.sql

Note:- This SQL will take more than an hour to execute

SQL> shutdown;
SQL> exit;

Start it up in normal mode from SQL*Plus run

$sqlplus "/as sysdba"
SQL>startup;
SQL>@utlrp.sql

Note:- This SQL will take more than an 5-6 hour to execute.
Note:- If you find their is few amount of invalid objects are present after completion of the utlrp.sql. Run again the same script.

SQL>shutdown;