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 privilegesand 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.loglog:
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
