While upgrading schema from RHN Satellite v 5.4.X to 5.5 fails with "ORA-01418: specified index does not exist" for rhn_ram_sid_idx index
Issue
- During schema upgrade for the errata RHBA-2013:0853-1 Satellite 5.4 schema errata, the index rhn_ram_sid_idx is dropped. If this index does not exist the sql error below is thrown and schema update fails:
'SATELLITE-SCHEMA-5.4-TO-SATELLITE-SCHEMA-5.5/125-ALTER-INDEX-RHNRAM.SQL.ORACL
------------------------------------------------------------------------------
satellite-schema-5.4-to-satellite-schema-5.5/125-alter-index-rhnRam.sql.oracle
0 rows deleted.
DROP INDEX rhn_ram_sid_idx
*
ERROR at line 1:
ORA-01418: specified index does not exist
Environment
- Red Hat Satellite 5.4.x
- RHBA-2013:0853 , spacewalk-schema-1.2.21-17.elXsat.noarch.rpm & spacewalk-schema-1.2.21-17.elXsat.noarch.rpm
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.