Upgrading Applications 11.5.7 Database To 9i Generates 400+ Invalid Objects

Too Many Invalid objects in EBS database

As Oracle account login on database server. 

       % sqlplus apps/ 

         spool invalid_object_before_phase2.1.out

         select count(*) from dba_objects where status <> ‘VALID’;

         select owner, object_name 

         from dba_objects where status <> ‘VALID’;

         spool off

If the count of above query is in hundreds You need to perform following
steps during the Production down time. 
Ref : Metalink note*:239016.1 

Please validate following events are listed in database init file. If the
following events missing please add those with detail comments as follow.  

 
########
#
#       Events
#
#       Events are used by Oracle Support and Development. They should only be
#       set as requested.
#
#       The following events are required for backward compatibility.
#
#       They must be set for Oracle Applications release 11.5.7.
#       For all other certified releases ( 11.5.8 and above ), they
#       are not required and should be either commented out or removed
#       from the init.ora file.
#
########
event="10932 trace name context level 32768"
event="10943 trace name context level 16384"
event="10933 trace name context level 512"

Make sure you are in downtime window and All Application process are down
including Concurrent manager. 

To make above init files changes to take effect, restart the database. 

Verify the database started with above events by performing following check. 

• check alert.log

• run show parameter 

From database node as applmgr account Run 

         adadmin

 The utility will then ask you a series of questions.

 Under the Maintain Applications Database Objects Menu, 

 select Compile APPS schema(s)

 exit out from adadmin

NOTE : This was only when you are EBS 11.5.7 and Oracle 9i.
Read my previous blog where I had ISSUE due to the trace event are not removed after 11.5.10 upgrade