Execution of database upgrade scripts fails with "ORA-06576" error

Products	Versions
TIBCO Order Management	5.1.0-HF6, 5.1.0-HF7

Description

If oracle database is used by OM, then to deploy the hotfix 5.1-HF6, execution of the below script is needed.
-$OM_HOME/db/dbscripts/oracle/order/upgrade_5.1.0hf5_to_5.1.0hf6_db-setup.sh

And for OM 5.1-HF7, the following scripts should be executed:
-$OM_HOME/db/dbscripts/oracle/order/upgrade_5.1.0hf5_to_5.1.0hf6_db-setup.sh
-$OM_HOME/db/dbscripts/oracle/archival/upgrade_5.1.0hf6_to_5.1.0hf7_db-setup.sh

The execution of above scripts can fail with the below error:
===
call DBMS_REDEFINITION.Can_Redef_Table('OM_ARCHIVAL_USER', 'ORDERS_ARCHIVE')
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
====

See attached files for more details.

Issue/Introduction

This KB article deals with the oracle "ORA-06576" error that can be encountered when executing below scripts: -$OM_HOME/db/dbscripts/oracle/order/upgrade_5.1.0hf5_to_5.1.0hf6_db-setup.sh (order database). -$OM_HOME/db/dbscripts/oracle/archival/upgrade_5.1.0hf6_to_5.1.0hf7_db-setup.sh (archival database).

Environment

ALL

Resolution

To solve the issue, you need to grant archival and order database users the below privileges:
===
grant resource, connect, create session to OM_ORDER_USER;
grant alter session to OM_ORDER_USER;
grant execute on dbms_redefinition to OM_ORDER_USER;
grant create any sequence to OM_ORDER_USER;
grant create any table to OM_ORDER_USER;
grant alter any table to OM_ORDER_USER;
grant drop any table to OM_ORDER_USER;
grant lock any table to OM_ORDER_USER;
grant select any table to OM_ORDER_USER;
grant create any index to OM_ORDER_USER;
grant create any trigger to OM_ORDER_USER;
grant create any job to OM_ORDER_USER;
===

Attachments

Execution of database upgrade scripts fails with "ORA-06576" error get_app

Welcome to "KB Articles"