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

E16723-08
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

21 Upgrading from Portal 7.3 to BRM 7.4

This chapter contains procedures for upgrading from Portal release 7.3 to Oracle Communications Billing and Revenue Management (BRM) 7.4. It covers BRM on HP-UX IA64 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: 7594320. This overlay upgrade patch includes the changes that are necessary for upgrading Portal 7.3 to BRM 7.4. It upgrades the following components:

  • 32-bit Portal Base

  • Portal SDK

  • 32-bit Third-Party software

  • SNMP

  • Pipeline Manager

  • Pipeline PDK

  • TIMOS Data Manager

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

Refer to the upgrade patch README for more information.

7.3-to-7.4 Upgrade

This section lists the upgrade tasks.

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 Portal Service Authentication and Authorization

  4. Backing Up Your Portal 7.3 Database

  5. Installing Portal 7.3 Patches

  6. Setting the Environment Variables

  7. Installing the Overlay Upgrade Patch

  8. Upgrading the Portal Database Schema

  9. Upgrading the Pipeline Manager Database Schema

  10. Installing the Overlay Upgrade Patch on a Multidatabase System

  11. Installing BRM 7.4 Client Applications

  12. Adding Customizations

  13. Restoring Service Authentication

Shutting Down the Current Instance

To shut down Portal 7.3:

  1. Stop all Portal 7.3 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 Portal 7.3 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 Portal Service Authentication and Authorization

To maintain a controlled environment for pre-upgrade testing, cut off interaction between your Portal 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 Oracle Communications Billing and Revenue Management (BRM) Documentation.

Backing Up Your Portal 7.3 Database

Make a complete offline backup of your Portal 7.3 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 Portal 7.3 tables. This helps to restore individual tables, if necessary.

Installing Portal 7.3 Patches

Go to the Oracle My Support Web site:

https://support.oracle.com

and download and install the mandatory Portal 7.3 patches 5835756 (04489), 5903622, and 6787882 for your platform. Follow the installation instructions in the README downloaded with the patches.

Setting the Environment Variables

Before installing the overlay upgrade patch, 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 7594320 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_7594320_Portal_Base_platform_32_opt for upgrading Portal plus any Portal optional components installed on your system.

    • 7.4_7594320_Portal_SDK_platform_32_opt for upgrading the Portal SDK.

    • 7.4_7594320_ThirdParty_Upgrade_platform_32_opt for upgrading the Third-Party software (this will install the RDA tool and upgrade JRE to 1.5.0_09-b03). For more information, see ”Collecting Diagnostic Information by Using RDA” in BRM System Administrator's Guide.

    • 7.4_7594320_SNMP_3rd_party_tool_platform_64_opt for upgrading SNMP.

    • 7.4_7594320_Pipeline_platform_64_opt for upgrading Pipeline Manager.

    • 7.4_7594320_Pipeline_PDK_platform_64_opt for upgrading the Pipeline PDK.

    • 7.4_7594320_Timos_platform_64_opt for upgrading TIMOS Data Manager.

      where platform is hpux_ia64 or solaris.

      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 Portal 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_7594320_Timos_platform_64_opt, where platform is hpux_ia64 or solaris.)

The pin_73patch_74_upgrade.pl script runs a series of scripts that upgrade Portal 7.3 to BRM 7.4.

To upgrade your Portal 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_73patch_74_upgrade.pl script from the UNIX prompt:

    % cd BRM_Home/setup/scripts
    % perl pin_73patch_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 your 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 you 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 the 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. Open the 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_73patch_74_upgrade.pl script from the UNIX prompt:

    % cd BRM_Home/setup/scripts
    % perl pin_73patch_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 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. For more information, see "Updating Custom Applications".

Adding Customizations

Important:

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

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

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

Restoring Service Authentication

See ”Using the Authentication and Authorization Modules” in BRM RADIUS Manager.

Post-Upgrade Procedures

This section includes the post-upgrade tasks. Be sure to check whether these tasks are required for your system.

Loading pin_notify

If your system includes Pipeline Manager, 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
    

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.

    Note:

    Uninstalling the Third-Party upgrade package does not uninstall JRE 1.5.0_09-b03, which is the latest version recommended for BRM 7.4.