Skip Headers
Oracle® Communications Billing and Revenue Management Upgrade Guide
Release 7.5

E16723-07
Go to Documentation Home
Home
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

20 Upgrading from BRM 7.3.1 to BRM 7.4

This chapter contains procedures for upgrading from Oracle Communications Billing and Revenue Management (BRM) 7.3.1 to BRM 7.4. It covers BRM on HP-UX IA64, Linux, AIX, and Oracle Solaris.

Important:

Before performing this upgrade, see "About Upgrading BRM Releases" for information on how to plan, prepare for, and test your upgrade.

Upgrade Patches

There is one overlay upgrade patch: 7594327. This overlay upgrade patch includes the changes that are necessary for upgrading BRM 7.3.1 to BRM 7.4. It upgrades the following components:

  • 32-bit BRM

  • BRM SDK

  • 32-bit Third-Party software

  • BRM SNMP

  • Pipeline Manager

  • Pipeline PDK

  • TIMOS Data Manager

The upgrade identifies BRM components already installed in your environment and upgrades them to BRM 7.4.

Refer to the upgrade patch README for more information.

7.3.1-to-7.4 Upgrade

This section provides a list of upgrade tasks. Some tasks are optional or apply only to certain platforms or system configurations. Be sure to check whether a task is required for your system.

Caution:

When upgrading a multidatabase system, perform each task on both the primary and secondary system.

Perform these tasks when upgrading your BRM system:

  1. Shutting Down the Current Instance

  2. Backing Up Files

  3. Turning Off BRM Service Authentication and Authorization

  4. Backing Up Your BRM 7.3.1 Database

  5. Setting the Environment Variables

  6. Installing the Overlay Upgrade Patch

  7. Upgrading the BRM Database Schema

  8. Upgrading the Pipeline Manager Database Schema

  9. Installing the Overlay Upgrade Patch on a Multidatabase System

  10. Installing BRM 7.4 Client Applications

  11. Adding Customizations

  12. Restoring Service Authentication

Shutting Down the Current Instance

To shut down BRM 7.3.1:

  1. Stop all BRM 7.3.1 processes.

    Only the database instance should be running during the upgrade. For more information, see ”Starting and Stopping the BRM System” in BRM System Administrator's Guide.

  2. Ensure that no users are logged in.

    Users include customers, client applications, customer service representatives (CSRs), and so on.

Backing Up Files

Back up your BRM 7.3.1 files. In particular, ensure that you back up all customized files, including source code, policy files, pin.conf, pin_setup.values, and Infranet.properties files. Copy your customizations from these files to the BRM 7.4 files after upgrading to BRM 7.4.

Important:

Back up all the customized load utility files to a different location. After the upgrade is completed and services start running, restore the customized load utility files to their original location. Run the load utility applications to restore the customized entries in the database.

For more information, see "Transferring Customizations to the New Release".

Turning Off BRM Service Authentication and Authorization

To maintain a controlled environment for pre-upgrade testing, cut off interaction between your BRM system and your customers.

For information on providing access to services while authentication is turned off, see "About Maintaining Access to the BRM System during the Upgrade Process".

For information on the BRM authentication module, see BRM RADIUS Manager in the BRM 7.4 documentation.

Backing Up Your BRM 7.3.1 Database

Make a complete offline backup of your BRM 7.3.1 database and ensure that the backup is completely valid and usable. See your database software documentation for more information on performing full database backups.

In addition to the backup, use the Oracle export utility to export all BRM 7.3.1 tables. This helps to restore individual tables, if necessary.

Setting the Environment Variables

Before installing the upgrade, ensure the environment variables are set correctly:

  1. Go to the directory in which you installed the Third-Party package and source the source.me file:

    • Bash shell:

      % source source.me.sh
        
      
    • C shell:

      % source source.me.csh
      

Installing the Overlay Upgrade Patch

To install the overlay upgrade patch:

  1. Go to the My Oracle Support Web site:

    https://support.oracle.com

    and download patch 7594327 to a temporary directory (temp_dir) on your system.

  2. Go to temp_dir and run the following command, which installs the overlay upgrade patch software:

    % PatchPackageName.bin
      
    

    where PatchPackageName is:

    • 7.4_7594327_Portal_Base_platform_32_opt for upgrading BRM plus any BRM optional components installed on your system.

    • 7.4_7594327_Portal_SDK_platform_32_opt for upgrading the BRM SDK.

    • 7.4_7594327_ThirdParty_Upgrade_platform_32_opt for upgrading Third-Party software (this will install the RDA tool). For more information, see ”Collecting Diagnostic Information by Using RDA” in BRM System Administrator's Guide.

    • 7.4_7594327_SNMP_3rd_party_tool_platform_64_opt for upgrading BRM SNMP.

    • 7.4_7594327_Pipeline_platform_64_opt for upgrading Pipeline Manager.

    • 7.4_7594327_Pipeline_PDK_platform_64_opt for upgrading the Pipeline PDK.

    • 7.4_7594327_Timos_platform_64_opt for upgrading TIMOS Data Manager.

      where platform is hpux_ia64, solaris, linux, or aix.

      Note:

      You can use the -console parameter to run the installation from a command line. To install using a GUI, obtain a GUI application, such as X Windows, and set the DISPLAY environment variable before you install BRM 7.4.

Upgrading the BRM Database Schema

Important:

First run the database upgrade script on the secondary databases and then on the primary database.

Note:

If your base system has TIMOS DM installed, before running the upgrade script, install the TIMOS DM upgrade package (7.4_7594327_Timos_platform_64_opt, where platform is hpux_ia64, solaris, linux, or aix.)

The pin_731_74_upgrade.pl script runs a series of scripts that upgrade BRM 7.3.1 to BRM 7.4.

To upgrade your BRM database schema:

  1. Open the BRM_Home/setup/pin_setup.values file.

  2. (Optional) Set the values of the following parameters:

    • PIN_TEMP_DIR to the directory in which you want to create the temporary files.

    • PIN_LOG_DIR to the directory in which you want to create the BRM log files.

  3. In the Information about the databases section, configure the database settings as required.

  4. Save and close the file.

  5. Run the pin_731_74_upgrade.pl script from the UNIX prompt:

    % cd BRM_Home/setup/scripts
    % perl pin_731_74_upgrade.pl
    

Upgrading the Pipeline Manager Database Schema

Important:

First run the database upgrade script on the secondary databases and then on the primary database.

To upgrade the Pipeline Manager database schema:

  1. Open the Pipeline_Home/upgrade/pin_setup.values file.

  2. Set the value of the PIN_TEMP_DIR parameter to the directory in which want to create the temporary files.

  3. Point $PIPELINE_TBLSPACE to the tablespace where you want to create pipeline database objects.

  4. In the Information about the databases section, configure the database settings as required.

  5. Save and close the file.

  6. Run the pin_731_74_pipeline_upgrade.pl script from the UNIX prompt:

    pin_731_74_pipeline_upgrade.pl
    % cd Pipeline_Home/upgrade/731_74
    % perl pin_731_74_pipeline_upgrade.pl
      
    
  7. Update the AccessLib registry entry from oci10g61 to oci10g63 for Login, LoginInfranet, and LoginQueue modules. This includes files such as wireless.reg, rerating.reg, roaming.reg, and other registry files located in Pipeline_Home/conf directory.

Installing the Overlay Upgrade Patch on a Multidatabase System

Important:

First install the overlay upgrade patch on the secondary database and then on the primary database.
  1. Go to BRM_Home/setup/pin_setup.values file.

  2. Change the $DM_ORACLE{'db_num'} entry, where db_num is the number of the secondary database to upgrade.

  3. Save and close the file.

  4. Run the pin_731_74_upgrade.pl script from the UNIX prompt:

    % cd BRM_Home/setup/scripts
    % perl pin_731_74_upgrade.pl
    

Installing BRM 7.4 Client Applications

When you install client applications, be sure to update the BRM 7.4 Infranet.properties and INI files with any 7.3.1 customizations.

Important:

You must upgrade all client applications and optional components to BRM 7.4.

To upgrade custom client applications, recompile them with BRM 7.4 libraries.See "Updating Custom Applications" for more information.

Adding Customizations

Important:

First incorporate customizations on the secondary databases and then on the primary database.

Incorporate any customizations you made to your Release 7.3.1 policy source code, configuration files, invoicing, reports, and general ledger reporting. See "Transferring Customizations to the New Release" for more information.

(Production system only) Ensure that you remove all entries for the pin_virtual_time utility from the configuration files.

Restoring Service Authentication

See BRM RADIUS Manager in the BRM 7.4 documentation.

Post-Upgrade Procedures

This section provides a list of post-upgrade tasks. Some tasks are optional or apply only to certain platforms or system configurations. Be sure to check whether a task is required for your system.

Perform these tasks after you upgrade your BRM system:

  1. Creating an Oracle AQ Database Queue

  2. Loading pin_notify

  3. Removing the Unused Procedures and Packages from the BRM Database

  4. Removing the xml.jar File (AIX Only)

Creating an Oracle AQ Database Queue

If your system includes the Synchronization Queue Data Manager, you must re-create your Oracle AQ database queue before you can begin synchronizing pricing data. For more information on how to create a database queue, see ”Manually Creating a Database Queue on Oracle” in BRM Synchronization Queue Manager.

After you re-create the Oracle AQ database queue, perform these steps:

  1. Update BRM_Home/sys/dm_aq/aq_queuenames with the re-created Oracle AQ database queue name.

  2. Restart DM_AQ services.

Loading pin_notify

If your system includes Pipeline Manager, you must reload the event notification configuration file, pin_notify, in the BRM database. For more information, see ”About the Event Notification List” in BRM Developer's Guide.

To load the pin_notify file:

  1. Go to the BRM_Home/sys/data/config directory.

  2. Run the following command:

    load_pin_notify pin_notify
      
    

    If you do not run the utility from the directory in which the configuration file is located, include the complete path to the file.

  3. Stop and restart the Connection Manager (CM).

Removing the Unused Procedures and Packages from the BRM Database

Remove the unused procedures and packages from the BRM database.

To remove the unused procedures and packages from the BRM database:

  1. Enter the following command, which opens SQL*Plus:

    sqlplus login/password@ORACLE_SID
    

    where:

    • login is the user name for the database schema you are updating.

    • password is the password for the specified user name.

    • ORACLE_SID is the BRM database alias of the schema you are updating.

  2. Enter the following commands in the given order:

    SQL>drop procedure DROP_PROCEDURES;
    SQL>drop package EVENT_PARTITION;
    

    The unused procedures and packages are removed.

  3. Enter the following command, which exits SQL*Plus:

    SQL>exit
    

Removing the xml.jar File (AIX Only)

For AIX only, you must remove or rename the xml.jar file from the JRE bundle to avoid a conflict with a Third-Party package.

To remove or rename the xml.jar file:

  1. Go to the BRM_Home/opt/portal/7.4/ThirdPartyApps/jre/1.5.0/lib directory.

  2. Remove or rename the xml.jar file.

Uninstalling an Upgrade Package

To uninstall any upgrade package:

  1. Back up the BRM database.

  2. Back up all the BRM files.

  3. Stop all BRM daemons, processes, and managers.

  4. Log in as user pin.

  5. Go to the directory in which you installed the Third-Party package and source the source.me file:

    • Bash shell:

      % source source.me.sh 
        
      
    • C shell:

      % source source.me.csh 
        
      
  6. Run the BRM_Home/uninstaller/PatchPackageName/uninstaller.bin program, where PatchPackageName is the name of the upgrade package you want to uninstall.

    Note:

    You can use the -console parameter to run uninstall from a command line.

    This starts a series of interactive prompts.

  7. Follow the instructions on the screen.