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

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content