Contents

Title and Copyright Information

Preface

• Audience
• Downloading Oracle Communications Documentation
• Documentation Accessibility
• Document Revision History

Part I About Upgrading

1 About Upgrading BRM Releases

• About Upgrading BRM to a New Release
  • About Maintaining Access to the BRM System during the Upgrade Process
    • Upgrading from BRM 7.4 to BRM 7.5
    • Upgrading from Earlier Versions to BRM 7.4
  • Direct and Incremental Upgrades
• Planning Your Upgrade
  • Identifying Your Upgrade Team
  • Identifying Who Is Affected by the Upgrade
  • Collecting Information about Your System
  • Determining the Impact of New Features
  • Estimating How Long the Upgrade Will Take
    • How Long Will It Take to Run the Database Upgrade Scripts?
    • How Long Will It Take to Plan, Prepare for, Test, and Perform the Upgrade?
• Updating Your System Environment
• Creating Test Environments
  • Old Baseline Release
  • Old Customized Release
  • New Baseline Release
  • New Customized Release (Test System)
• Transferring Customizations to the New Release
  • Upgrading Customized Policy Source Files
  • Updating Configuration Files
  • Updating Database Customizations
    • Modifying the Content of Custom Tables
    • Modifying the Structure of Custom Tables
    • Fixing Standard Database Objects with Nonstandard Object IDs
  • Updating Custom Reports
  • Updating Custom Applications
• Testing Your Upgraded System
  • Running Old and New Versions in Parallel
  • Testing the BRM Database
  • Troubleshooting Your Upgraded System
  • Testing Checklist
• Preparing for the Production System Upgrade
• Upgrading Your Production System

Part II Upgrade Impacts

2 Feature Changes from BRM 7.4 to BRM 7.5

• AAA Gateway
  • AAA Gateway Manager Replaced by Online Mediation Controller
• Customer Center
  • Correct Validity Period Set When Product Is Purchased Using Customer Center
• Invoicing
  • Enhanced Invoice Document
  • Invoice Utilities
• Pipeline Manager
  • Rating Multiple Events for a Service
• System Administration
  • IMDB Cache Manager Replaces TIMOS DM

3 Storable Class Changes from BRM 7.4 to BRM 7.5

• New Storable Classes
• Changed Storable Classes
• Obsoleted Storable Classes

4 Opcode Changes from BRM 7.4 to BRM 7.5

• New Policy Opcodes
  • Accounts Receivable FM Policy Opcodes
  • Billing FM Policy Opcodes
  • Customer FM Policy Opcodes
  • General Ledger FM Policy Opcodes
  • Number Manager FM Policy Opcodes
• New Standard Opcodes
  • Billing FM Standard Opcodes
  • Price List FM Standard Opcodes
• Changed Policy Opcodes
  • Billing FM Policy Opcodes
  • Customer FM Policy Opcodes
  • Payment FM Policy Opcodes
  • Rating FM Policy Opcodes
  • Subscription Management FM Policy Opcodes
• Changed Standard Opcodes
  • Activity FM Standard Opcodes
  • Accounts Receivable FM Standard Opcodes
  • Balance FM Standard Opcodes
  • Billing FM Standard Opcodes
  • Collections FM Standard Opcodes
  • Customer FM Standard Opcodes
  • Number Manager FM Standard Opcodes
  • Payment FM Standard Opcodes
  • Pricing FM Standard Opcodes
  • Process Audit FM Standard Opcodes
  • Rating FM Standard Opcodes
  • Rerating FM Standard Opcodes
  • SDK FM Standard Opcodes
  • Services Framework AAA Manager FM Standard Opcodes
  • Subscription Management FM Standard Opcodes
• Renamed Opcodes
• Obsoleted Policy Opcodes
  • Collections FM Policy Opcodes
• Obsoleted Standard Opcodes
  • Balance FM Standard Opcodes
  • Billing FM Standard Opcodes
  • Balance Monitoring FM Standard Opcodes
  • Collections FM Standard Opcodes

5 Utility Changes from BRM 7.4 to BRM 7.5

• Changed Utilities

6 Notification Event Changes from BRM 7.4 to BRM 7.5

• Changed Notification Events

Part III Upgrade Impacts from Previous Releases

7 Feature Changes from BRM 7.3.1 to BRM 7.4

• AAA Gateway Manager
  • Diameter Changes
• Billing
  • Accounting Type Set at Bill Unit Level
• GSM AAA Standard Opcodes
• Pricing
  • LoadIfwConfig Enhancements
• RADIUS Manager
  • RADIUS Configuration File Changes
• Roaming Manager
• Services Framework
  • Services Framework Now Supports Non-Telco Services
    • About Provisioning Non-Telco Services
    • About Managing Non-Telco Services
    • About Processing AAA Requests for Non-Telco Services
• System Administration
  • MD5 Password Encryption No Longer Supported

8 Storable Class Changes from BRM 7.3.1 to BRM 7.4

• Changed Storable Classes
• Obsoleted Storable Classes

9 Opcode Changes from BRM 7.3.1 to BRM 7.4

• Changed Policy Opcodes
  • Activity FM Policy Opcodes
  • Billing FM Policy Opcodes
  • Content Manager FM Policy Opcodes
  • Customer FM Policy Opcodes
  • GPRS Manager 3.0 FM Policy Opcodes
  • GSM AAA Manager FM Helper Policy Opcodes
  • GSM Manager FM Policy Opcodes
  • IMT Manager FM Policy Opcodes
  • IP Address Manager FM Policy Opcodes
  • Payment FM Policy Opcodes
  • Price List FM Policy Opcodes
  • Process Audit FM Policy Opcodes
  • Provisioning FM Policy Opcodes
  • RADIUS Manager FM Policy Opcodes
  • Rating FM Policy Opcodes
  • Resource Reservation FM Policy Opcodes
  • Services Framework Manager FM Policy Opcodes
  • Subscription Management FM Policy Opcodes
  • Voucher Management FM Policy Opcodes
• Changed Standard Opcodes
  • Accounts Receivable FM Standard Opcodes
  • Active Session Manager FM Standard Opcodes
  • Activity FM Standard Opcodes
  • Balance FM Standard Opcodes
  • Billing FM Standard Opcodes
  • Collections FM Opcodes
  • Context Management Opcodes
  • Customer FM Standard Opcodes
  • GPRS Manager 3.0 FM Standard Opcodes
  • GSM AAA Manager FM Standard Opcodes
  • GSM Manager FM Standard Opcodes
  • Invoicing FM Standard Opcodes
  • Payment FM Standard Opcodes
  • Pricing FM Standard Opcodes
  • Process Audit FM Standard Opcodes
  • Provisioning FM Standard Opcodes
  • RADIUS Manager FM Standard Opcodes
  • Rating FM Standard Opcodes
  • Resource Reservation FM Standard Opcodes
  • Services Framework AAA Manager FM Standard Opcodes
  • Services Framework Manager FM Provisioning Opcodes
  • Subscription Management FM Standard Opcodes
  • Voucher Manager FM Standard Opcodes
• Renamed Opcodes

10 Utility Changes from BRM 7.3.1 to BRM 7.4

• Changed Utilities

11 Pipeline Manager Changes from BRM 7.3.1 to BRM 7.4

• Changed Pipeline Manager Modules
• New BRM EDR Container Fields
  • Associated CAMEL Extension Record
  • Associated Roaming Extension Record
  • Associated Suspense Extension Record
  • Charge Breakdown Record Tax Packet
  • Header Record
  • Supplementary Charge Packet Record
  • Total Advised Charge Value List
• New AAA EDR Container Fields
  • Changed Opcode Blocks

12 Notification Event Changes from BRM 7.3.1 to BRM 7.4

• Changed Notification Events

13 Feature Changes from Portal 7.3 to BRM 7.3.1

• AAA Gateway Manager Changes
  • MBI Protocol Support
    • GSM Requests-to-Opcode Mapping Changes
    • MBI Administrative Messages-to-Opcode Mapping Changes
    • MBI Grammar and Mapping File Changes
    • MBI CDR Grammar and Mapping File Changes
    • EDR Container Changes
    • Changes to the MBI Registry File
  • Timeout and Replay Pipeline Changes
• Pipeline Manager Changes
  • Pipeline Manager Uses Business Parameter Settings from the BRM Database
• Taxation Changes
• Telco Framework Changes
  • Telco Framework Renamed to Services Framework

14 Storable Class Changes from Portal 7.3 to BRM 7.3.1

• Changed Storable Classes

15 Opcode Changes from Portal 7.3 to BRM 7.3.1

• Changed Policy Opcodes
  • Activity FM Policy Opcodes
  • Accounts Receivable FM Policy Opcodes
  • Billing FM Policy Opcodes
  • Customer FM Policy Opcodes
  • GPRS AAA Manager FM Policy Opcodes
  • GSM AAA Manager FM Policy Opcodes
  • GSM Manager FM Policy Opcodes
  • Invoice Manager FM Policy Opcodes
  • Number Manager Policy Opcodes
  • Payment FM Policy Opcodes
  • Pricing FM Policy Opcodes
  • Process Audit FM Policy Opcodes
  • Rating FM Policy Opcodes
  • Remittance FM Policy Opcodes
  • Resource Reservation FM Policy Opcodes
  • SIM Card Manager FM Policy Opcodes
  • Subscription FM Policy Opcodes
  • Services Framework AAA Manager FM Policy Opcodes
  • Voucher FM Policy Opcodes
  • Zone Map FM Policy Opcodes
• Changed Standard Opcodes
  • Activity FM Standard Opcodes
  • Accounts Receivable (A/R) Standard Opcodes
  • Balance FM Standard Opcodes
  • Balance Monitoring FM Standard Opcodes
  • Base Opcodes
  • Billing FM Standard Opcodes
  • Channel FM Standard Opcodes
  • Content Manager FM Standard Opcodes
  • Customer FM Standard Opcodes
  • Device FM Standard Opcodes
  • Filter Set FM Standard Opcodes
  • Group FM Standard Opcodes
  • GSM AAA Manager FM Standard Opcodes
  • GSM Manager FM Standard Opcodes
  • IC FM Standard Opcodes
  • Invoicing FM Standard Opcodes
  • Number Manager FM Standard Opcodes
  • Order Manager FM Standard Opcodes
  • Payment FM Standard Opcodes
  • Permissioning FM Standard Opcodes
  • Price FM Standard Opcodes
  • Process Audit FM Standard Opcodes
  • RADIUS Manager FM Standard Opcodes
  • Rating FM Standard Opcodes
  • Remittance FM Standard Opcodes
  • Resource Reservation FM Standard Opcodes
  • SDK FM Standard Opcodes
  • Subscription FM Standard Opcodes
  • Suspense FM Standard Opcodes
  • Services Framework AAA Manager FM Standard Opcodes
  • Voucher FM Standard Opcodes
• Renamed Opcodes

16 Utility Changes from Portal 7.3 to BRM 7.3.1

• Changed Utilities

17 Pipeline Manager Changes from Portal 7.3 to BRM 7.3.1

• Changed Pipeline Manager Modules
• New EDR Container Fields
  • Basic Detail Record
  • Associated Charge Breakdown Record - Update Balance Packet
  • Associated Charge Breakdown Record - Supplementary Charge Packet Record
  • Split Charge Packet
  • Discount Sub-balance Packet

18 Notification Event Changes from Portal 7.3 to BRM 7.3.1

• Changed Notification Events

Part IV Upgrade Procedures

19 Upgrading BRM and Pipeline Manager

• About the Upgrade
  • System Configurations Supported by This Upgrade
    • Oracle In-Memory Database (IMDB) Cache Manager
    • Online Charging Connectivity and BRM 7.5
• Tasks Involved in the BRM 7.4-to-7.5 Upgrade Process
• Shutting Down the Current Instance
• Turning Off BRM Service Authentication and Authorization
• Creating a Backup of the IMDB Cache Data
• Backing Up Files
  • Backing Up Pipeline Manager Files
  • Backing Up Your BRM 7.4 Database
• Installing BRM 7.5
  • Restricting Schema Creation
  • Setting the Environment Variables
  • Installing the BRM 7.5 Database Upgrade Package
• Pointing the BRM 7.5 Installation to the New Database Schema
• Upgrading the BRM Database Schema to the BRM 7.5 Schema
  • Upgrading the Schema on Single Database Systems
  • Upgrading the Schema on Multidatabase Systems
• Upgrading the Pipeline Manager Database Schema to the BRM 7.5 Schema
• Installing the BRM 7.5 Client Applications
  • Installing Optional Components
    • Completing the Upgrade from IMDB Cache Manager Version 1 to Version 2
    • Installing Online Mediation Controller for Authentication/Authorization in BRM 7.5
  • Other Database Configurations
    • Update DM_IFW_SYNC Queue Database Configuration Setting
    • Verify IFW_SYNC_QUEUE Queue in the Database
    • Update the Default Settings for the pin_rel Utility
  • Restoring Customizations
    • BRM Production Systems and pin_virtual_time Configuration Entries
• Post-Upgrade Procedures
  • Updating Pipeline Manager Configuration Data
  • Creating an Oracle AQ Database Queue
  • Loading the pin_notify File
• Restoring Service to Your Customers
• Rolling Back an Upgrade

20 Upgrading from BRM 7.3.1 to BRM 7.4

• Upgrade Patches
• 7.3.1-to-7.4 Upgrade
  • Shutting Down the Current Instance
  • Backing Up Files
  • Turning Off BRM Service Authentication and Authorization
  • Backing Up Your BRM 7.3.1 Database
  • Setting the Environment Variables
  • Installing the Overlay Upgrade Patch
  • Upgrading the BRM Database Schema
  • Upgrading the Pipeline Manager Database Schema
  • Installing the Overlay Upgrade Patch on a Multidatabase System
  • Installing BRM 7.4 Client Applications
  • Adding Customizations
  • Restoring Service Authentication
• Post-Upgrade Procedures
  • Creating an Oracle AQ Database Queue
  • Loading pin_notify
  • Removing the Unused Procedures and Packages from the BRM Database
  • Removing the xml.jar File (AIX Only)
• Uninstalling an Upgrade Package

21 Upgrading from Portal 7.3 to BRM 7.4

• Upgrade Patches
• 7.3-to-7.4 Upgrade
  • Shutting Down the Current Instance
  • Backing Up Files
  • Turning Off Portal Service Authentication and Authorization
  • Backing Up Your Portal 7.3 Database
  • Installing Portal 7.3 Patches
  • Setting the Environment Variables
  • Installing the Overlay Upgrade Patch
  • Upgrading the Portal Database Schema
  • Upgrading the Pipeline Manager Database Schema
  • Installing the Overlay Upgrade Patch on a Multidatabase System
  • Installing BRM 7.4 Client Applications
  • Adding Customizations
  • Restoring Service Authentication
• Post-Upgrade Procedures
  • Loading pin_notify
  • Removing the Unused Procedures and Packages from the BRM Database
• Uninstalling an Upgrade Package

22 Upgrading from Portal 7.3 to BRM 7.3.1

• Upgrade Patches
• 7.3-to-7.3.1 Upgrade
  • Shutting Down the Current Instance
  • Backing Up Files
  • Turning Off Portal Service Authentication and Authorization
  • Backing Up Your Portal 7.3 Database
  • Installing Portal 7.3 Patches 5835756 and 5903622
  • Installing the JDK
  • (UNIX Only) Setting the Environment Variables
  • Installing Upgrade Patch 6498580
    • Installing Patches in a Conventional (ISMP) Environment
    • Installing Patches in a Prepaid (RPM) Environment
  • Running the Database Upgrade Script
  • Installing the Upgrade Patch on a Multidatabase System
  • Installing BRM 7.3.1 Client Applications
    • Upgrading Custom Client Applications
  • Adding Customizations
  • Restoring Service Authentication
  • Testing the Upgraded System
• Uninstalling Portal 7.3 Applications

23 Upgrading from GPRS Manager Release 2.0 to Release 3.0

• About Upgrading GPRS Manager
• Important Information for System Administrators
  • Oracle Database Character Sets
  • Preparing Your Environment for the Upgrade
    • Reviewing the Default Database Schema
    • Preparing an Oracle Database
• Upgrading GPRS Manager
  • Backing Up GPRS Manager 2.0 Files
  • Turning Off Portal Service Authentication and Authorization
  • Shutting Down Portal
  • Backing Up Your Portal Database
  • Installing the Third-Party Software
  • Installing GPRS Manager Server 3.0
  • Installing the Upgrade Scripts
  • Configuring the Upgrade Parameters
  • Creating Required Database Objects and the Upgrade Log Directory
  • Performing Pre-upgrade Sanity Checks
  • Generating List of Tables and Indexes in 3.0 Schema
    • Generating Your 3.0 Tables List
    • Generating 3.0 Index List
  • Running the Database Upgrade Scripts
  • Running pin_setup to Configure GPRS Manager
  • Restoring Service Authentication
  • Dropping Obsolete Database Objects from the Database (Optional)
  • Upgrading Events
• Command-Line Scripts
  • About the upg_mgr.pl Script
    • Syntax
    • Parameters
  • About the upgrade.pl Script
  • About the Upgrade Scripts and Files
    • Offline Scripts
    • Online Scripts
    • Miscellaneous Scripts and Files

Part V Upgrading Pipeline Manager

24 Upgrading from Pipeline Manager 7.2 to Pipeline Manager 7.3

• Important Information for System Administrators
  • Oracle Database Character Sets
  • Verifying the Pipeline Manager Release Number
• Upgrading the Oracle Software and Database
• Granting New Privileges to the Portal Integrate User
• Upgrading Pipeline Manager
  • Shutting Down Pipeline Manager
  • Uninstalling Pipeline Manager 7.2
  • Installing the Third-Party software
  • Installing Pipeline Manager
  • Installing the Upgrade Scripts
  • Configuring the Upgrade Parameters
  • Creating Required Database Objects and the Upgrade Log Directory
  • Running the Database Upgrade Scripts
  • Re-creating Your Account Synchronization Queues
  • Enabling Auditable Fields
  • Testing the Upgraded Pipeline System
  • Loading the Tailor-Made Stored Procedure
• Command-Line Scripts
  • About the crt_upg_obj.pl Script
  • About the Upgrade.pl Script
  • About the Upgrade Scripts and Files

Part VI Upgrading IMDB Cache Data Manager

25 Upgrading IMDB Cache Manager from Version 1 to Version 2

• About IMDB Cache Manager
  • Prerequisites for this Upgrade
  • Supported Scenarios for the Upgrade
  • About Upgrading Complex BRM System Architectures
• Preparing for the Upgrade to IMDB Cache Manager Version 2
  • Tasks Involved in Preparing for the Upgrade
  • Storing Any Customizations of Cache Groups
  • Unloading All Cache Groups
  • Detaching All IMDB Nodes from the Cache Grid
  • Stopping the Replication Agent
  • Dropping All Cache Groups
    • Dropping All Default Cache Groups
    • Dropping All Custom Cache Groups
  • Stopping the TimesTen Cache Agent
  • Destroying the Data Store
  • Stopping All Components Associated with IMDB Cache Manager Version 1
  • Uninstalling IMDB Cache Manager Version 1
  • Uninstalling IMDB Cache
  • What's Next?
• Upgrading the Oracle Schema for IMDB Cache Manager Version 2
  • Tasks Involved in Completing the Upgrade
  • Installing IMDB Cache
  • Installing IMDB Cache Manager Version 2
  • Re-creating the Data Store in IMDB Cache Manager Version 2
  • Generating the BRM Cache Group Schema
  • Initializing Your Data Store in Oracle IMDB Cache
  • Reestablishing Connections to BRM
  • Configuring the CM Connections to IMDB Cache DM

Part VII Upgrading GSM Manager

26 Upgrading from GSM Manager Release 1.0 to Release 2.0

• About Upgrading GSM Manager
• Important Information for System Administrators
  • Oracle Database Character Sets
  • Preparing Your Environment for the Upgrade
    • Reviewing the Default Database Schema
    • Preparing an Oracle Database
• Upgrading GSM Manager
  • Backing Up GSM Manager 1.0 Files
  • Turning Off Portal Service Authentication and Authorization
  • Shutting Down Portal
  • Backing Up Your Portal Database
  • Installing the Third-Party Software
  • Installing GSM Manager Server 2.0
  • Installing the Upgrade Scripts
  • Configuring the Upgrade Parameters
  • Creating Required Database Objects and the Upgrade Log Directory
  • Performing Pre-upgrade Sanity Checks
  • Generating a List of Tables and Indexes in the 2.0 Schema
    • Generating Your 2.0 Tables List
    • Generating 2.0 Index List
  • Running the Database Upgrade Scripts
  • Installing Patch 4489
  • Running pin_setup to Configure GSM Manager
  • Restoring Service Authentication
  • Dropping Obsolete Database Objects from the Database (Optional)
• Command-Line Scripts
  • About the upg_mgr.pl Script
    • Syntax
    • Parameters
  • About the Upgrade.pl Script
  • About the Upgrade Scripts and Files
    • Offline Scripts
    • Online Scripts
    • Miscellaneous Scripts and Files

Part VIII Upgrading Revenue Assurance Manager

27 Upgrading from Revenue Assurance Manager Release 2.0 to Release 3.0

• Preparing Your Environment for the Upgrade
  • Upgrading the Oracle Software and Database
• Upgrading the Portal Database for Revenue Assurance Manager 3.0
  • Backing Up Revenue Assurance Manager 2.0 Files
  • Loading Release 2.0 Batch Rating Data
  • Shutting Down Portal
  • Backing Up Your Portal Database
  • Installing the Third-Party Software
  • Installing Revenue Assurance Manager Server 3.0
  • Installing the Upgrade Scripts
  • Configuring the Upgrade Parameters
  • Creating Required Database Objects and the Upgrade Log Directory
  • Performing Pre-upgrade Sanity Checks
  • Running the Database Upgrade Scripts
  • Running pin_setup to Configure Revenue Assurance Manager
  • Restoring Service Authentication
  • Dropping Obsolete Database Objects from the Database (Optional)
• Updating the Revenue Assurance Configuration
  • Updating to Revenue Assurance Manager Release 3.0 Scenarios
  • Changing the Constraint on the IFW_AGGREGATION Table
  • Loading Release 3.0 Scenarios
  • Loading New UE Loader Templates into the Portal Database
  • Updating All the Control Points to Collect Batch Processing Timestamps
  • Changing the Date Format to Collect Call Processing Start and End Timestamps
  • Updating the Pipeline Registry to Track iScript File Name Changes
  • Updating the CollectProcessAuditForIREL Trigger with the New SQL Script
  • (Optional) Tracking Changes in /process_audit/billing Objects
  • (Optional) Changing Custom Revenue Assurance Aggregation Scenarios
• Command-Line Scripts
  • About the upg_mgr.pl Script
    • Syntax
    • Parameters
  • About the upgrade.pl Script
  • About the Upgrade Scripts and Files
    • Offline Scripts
    • Miscellaneous Scripts and Files

Part IX Migrating Discount Data

28 Understanding and Migrating Discount Data

• About Discount Data Migration
• Discounting Differences between Infranet 6.5 and Portal 7.3
• Migrating Discount Data
  • Overview of the Discount Data Migration Process
  • Upgrading Your System to Portal 7.3
  • Migrating Discount Data from the Pipeline 6.5 Database to the Portal 7.3 Database
    • Re-creating Your Custom Resource IDs on the Portal 7.3 Database
    • Retrieving the Discount Migration Utility
    • Modifying Service Code Mappings
    • Extracting Discount Data from the Pipeline 6.5 Database
    • Loading Discount Configuration Data into the Portal 7.3 Database
    • Retaining Discount Model ERAs from Portal Release 6.5
    • Loading Subscription Mapping Data into the Portal 7.3 Database
    • Loading Discount Balance Data into the Portal 7.3 Database
  • Upgrading Your System to Pipeline Manager 7.3
  • Performing Post-migration Updates
    • Updating Cross-Product Discounts after Migrating Discount Data
    • Creating System Discounts after Migrating Discount Data
• Using Discount Data Migration Utilities
  • DMTDscntMig
  • migrate_discount_balances.pl
  • pin_smt