Upgrading the database schema from Satellite 5.5 or previous to Satellite 5.6 fails with error ORA-01031: insufficient privileges

Solution Verified - Updated -

Issue

  • When upgrading the Red Hat Satellite's database schema from version 5.5 or previous to version 5.6, it fails with the error ORA-01031: insufficient privileges and throws this message:
'SATELLITE-SCHEMA-5.5-TO-SATELLITE-SCHEMA-5.6/036-ENABLE_LOGGING.SQL.ORACL
--------------------------------------------------------------------------
satellite-schema-5.5-to-satellite-schema-5.6/036-enable_logging.sql.oracle


PL/SQL procedure successfully completed.

begin logging.enable_logging('web_contact'); end;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SATELLITE.LOGGING", line 83
ORA-06512: at "SATELLITE.LOGGING", line 128
ORA-06512: at line 1
  • Red Hat Satellite Installation fails with below error message in populate_db.log log:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "RHSADMIN.LOGGING", line 116
ORA-06512: at line 1

Environment

  • Red Hat Satellite 5.6
  • External Oracle Database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.