This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BladeLogic Server Automation Suite
BMC BladeLogic Server Automation Suite 8.7.x Oracle
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.
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
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
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