Questions on Migration To Oracle 10g Database with BRM version 7.2 (Doc ID 735244.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.2.0.0.0 and later   [Release: 7.2.0 and later ]
Information in this document applies to any platform.

Goal

Question 1.
1.1 - Can the size of indexes be changed from 4k (default value on BRM) to 2k depending the
specific scenario or is it mandatory to set them all at 4k?
1.2 - Can reverse indexes be used when it is needed or could there be any technical issue using this type of indexes in the core tables?
1.3 - Can the core indexes be changed to reverse indexes if needed?

Question 2:
Is it possible to install patch003 for Portal 7.2 without upgrading the Oracle database to Oracle 10g first? If so, any special consideration?

Question 3:
With a multi-db environment, could the upgrade process from Oracle 9i to Oracle 10g be done in only one of the databases and, a few months later, carry on with the rest of them?

Question 4:
In case of any of the database is upgraded to Oracle 10g, is it mandatory to install the patch003 or could it be done when all databases would have been upgraded?

Question 5:  Please confirm upgrade path when upgraded to Oracle 10g support. 
(1) upgrade Oracle database from version 9.2.0.8 to Oracle 10g
(2) install the Patch003 for Portal 7.2

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