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
Environment
- Red Hat Satellite 5.4.1
- Schema upgrade from 5.4.0.19 to 5.4.0.20
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
