BSA: 8.7 UPI upgrade fails with Database user does not have sufficient privileges for running database migration

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BladeLogic Server Automation Suite


    APPLIES TO:

    BMC BladeLogic Server Automation Suite 8.7.x Oracle



    PROBLEM:

     

    BMC Server Automation (BSA) 8.7 UPI upgrade fails with the following error in an Oracle environment:

    Begin Error Text/

      


    Database user does not have sufficient privileges for running database migration.
    Remediation steps:

    1 The following grants should be provided to the database user:

    CONNECT, RESOURCE, CREATE TABLE, SELECT ANY DICTIONARY, CREATE SEQUENCE, CREATE TRIGGER, CREATE PROCEDURE,EXECUTE ON DBMS_LOCK, EXECUTE ON DBMS_LOB, EXECUTE ON DBMS_SQL, CREATE VIEW

    /End Error Text

     


    CAUSE:

    The UPI installer checks that the Bladelogic DB user has sufficient rights. This could be a valid catch or it could be an issue where the "UNLIMITED TABLESPACE" is being checked for but technically is not required


    SOLUTION:

     

    Run the following three queries on the Bladelogic DB and match the results with the expected results:

    Query 1 - this should return three rows:

    select * from user_tab_privs where TABLE_NAME in ('DBMS_LOB','DBMS_LOCK','DBMS_SQL');

      

    Query 2 - this should return two rows:

      

    select * from user_role_privs where GRANTED_ROLE in ('CONNECT','RESOURCE');

      

    Query 3 - this should return seven rows

      

    SELECT * from user_sys_privs where privilege in ('CREATE TABLE','SELECT ANY DICTIONARY','CREATE SEQUENCE', 'CREATE TRIGGER','CREATE PROCEDURE','CREATE VIEW','UNLIMITED TABLESPACE');

    Running these queries should highlight the missing privilege based on the expected results listed above. The DBA should grant the missing privilege at least for the duration of the upgrade.
     

      

    Note: In BSA 8.7, the UJPI checks for the "UNLIMITED TABLESPACE" privilege which, according to the BSA documentation, is currently an optional privilege. If this is the one found to be missing, grant "UNLIMITED TABLESPACE" to the Bladelogic DB user for duration of the upgrade and this can then be revoked. A defect (QM001891837) was created for this and resolved in BSA 8.8  and above

     


    Article Number:

    000100029


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles