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, 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