My Oracle Support Banner

Issues While Executing Multi-schema Script On Top Of 7.5_RTW + 7.5_PS3 (Doc ID 1518698.1)

Last updated on MARCH 21, 2019

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:Installed 7.5_RTW, during the part of 7.5_PS3 installations, executed pin_75ps3_upgrade.pl script for secondary schema, failed with the following error:

Snippet of the logs:
-----------------------

Upgrade BRM 75ps3 is now executing create_new_objects_75ps2()
  Execute SQL statement from file
  /app/brm75/base/sys/dd/data/pre_modular_oracle.sql
  ################################################
  /app/brm75/base/sys/dd/data/dd_objects_audit_coll_gdtls.source found
  Started dd_objects_audit_coll_gdtls.source at Mon Dec 17 18:20:40 2012
  Creating Objects in BRM Database
  Updating DB Schema
  Loading objects from file
  /app/brm75/base/sys/dd/data/dd_objects_audit_coll_gdtls.source
  *** Error: Unable to update the Portal Base database.
  Exiting from the install without finishing successfully.
  Please check for errors in /app/brm75/base/tmp/tmp.out
  and then rerun this program.

Qn2: Please confirm the following files (part of PS3 intaller) can be used to upgrade to 7.4_PS14 database to 7.5_SP3 database?

7.5PS3_Pipeline_Upgrade_74_75_linux_32_opt.bin
7.5PS3_PortalBase_Upgrade_74_75_linux_32_opt.bin
 
Qn3: Please clarify the following?

    1 ) Install 7.5 RTW (on a fresh environment)
    2 ) Run pin_setup
    3 ) Install PS3
    4 ) Now Run pin_75ps3_upgrade.pl -- will it upgrade the 7.4 PS14 database to 7.5 PS3?   
    5 ) 7.5 database setup took place at above step 2 (pin_setup during 7.5 RTW), will be repeated during this step as well?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.