On Red Hat Satellite v 5.4.1, while upgrading schema version it fails with error "ORA-20001: SCHEMA UPGRADE ENDS WITH INVALD OBJECTS "

Issue

• spacewalk-schema-upgrade fails with bellow error message:

SQL> -- check whether all objects are valid
SQL> declare
  2    invalid_objects number;
  3  begin
  4    select count(*)
  5      into invalid_objects
  6      from user_objects
  7     where status <> 'VALID' and
  8           (object_name, object_type) not in (select object_name, type from recyclebin);
  9   if invalid_objects > 0 then
 10      RAISE_APPLICATION_ERROR(-20001, 'SCHEMA UPGRADE ENDS WITH INVALD OBJECTS');
 11   end if;
 12  end;
 13  /
declare
*
ERROR at line 1:
ORA-20001: SCHEMA UPGRADE ENDS WITH INVALD OBJECTS 
ORA-06512: at line 10 

In /rhnsat/admin/rhnsat/bdump/alert_rhnsat.log, can see messages like

Tue May  7 14:13:14 2013
Errors IN FILE /rhnsat/admin/rhnsat/bdump/rhnsat_reco_16013.trc:
ORA-04031: unable TO allocate 4160 bytes OF shared memory ("shared pool","unknown object","sga heap(1,0)","KQR ENQ")
Tue May  7 14:13:14 2013
RECO: terminating instance due TO error 4031