Execution Of Install.sh & Pin_75_75ps10_upgrade.pl Failed As Part Of 7.5 PS10 Upgrade. (Doc ID 1999865.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Qn1:

On : 7.5.0.10.0 version, Infranet Install

We are upgrading BRM from 7.5 PS4 to 7.5 PS10 and faced errors during execution of below mentioned upgrade scripts -

1) Run the install.sh script: (which is under section - Upgrading the Schema on Multischema Systems)
cd BRM_Home/apps/multi_db
./install.sh

2) Run the pin_75_75ps10_upgrade.pl script from the UNIX prompt:
cd BRM_Home/setup/scripts
pin_75_75ps10_upgrade.pl (Failed on Primary schema but executed succesfully on secondary schemas)

ERROR
-----------------------
1.
BRM_Home/apps/multi_db
./install.sh

and see the following errors (the sippet of fix_multi_schema.log):



It says - 'INTEGRATE_ROLE_SEL' does not exist, so possibly ifw_Roles.sql was not executed in past.
On this point.
1) Shall we comment the creation of INTEGRATE schema which is part of the ifw_Roles.sql and proceed further with execution of ifw_Roles.sql and then 'create_pricing_discountmodel_procedures.plb' because we do not want to create INTEGRATE DB user but need the Role 'INTEGRATE_ROLE_SEL' ?

2) Post this, should we execute 'create_pricing_discountmodel_procedures.plb' on INTEGRATE (ifw) DB schema from both application schemas or executing it only once is sufficient ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms