Upgrading the database schema from Satellite 5.5 or previous to Satellite 5.6 fails with error ORA-01031: insufficient privileges
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.