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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.