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

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

23 Upgrading from GPRS Manager Release 2.0 to Release 3.0

This chapter contains procedures for upgrading your GPRS Manager system directly from Release 2.0 to Release 3.0. It covers Oracle on UNIX (HP-UX and Solaris) platform.

About Upgrading GPRS Manager

  • Install new GPRS Manager software.

  • Update the GPRS Manager database. The new GPRS Manager release includes an updated database schema with new tables and indexes. You use upgrade scripts to update your GPRS Manager database to the new schema.

  • The GPRS Manager 3.0 API is not backward compatible. You must implement a wrapper opcode to parse the existing flist data to the new API format.

Important Information for System Administrators

  • GPRS Manager 3.0 runs only on the Oracle 9i or 10g database.

  • To upgrade any data stored in custom tables, you must create additional SQL scripts. To run these scripts with the default upgrade scripts, add appropriate SQL file entries to the upgrade configuration file, upgrade.cfg. For more information, see "Configuring the Upgrade Parameters".

Oracle Database Character Sets

Portal™ supports only the UTF8 character set on Oracle. If you haven't already done so, you should move your data to a new UTF8 database before you upgrade. For more information about exporting your existing data to a UTF8 database, see ”Modifying your Oracle Database Installation” in BRM Installation Guide.

Preparing Your Environment for the Upgrade

After preparing your environment, prepare your database:

Reviewing the Default Database Schema

Before running the database upgrade scripts, review the default database schema changes between Release 2.0 and Release 3.0. Knowing the schema changes helps you plan your upgrade. For example, if 3.0 contains many new tables, you might need to increase the disk space for your 3.0 database. If your 2.0 custom applications refer to tables that have been modified or deleted in 3.0, you might need to update the applications for 3.0.

To review database schema changes, temporarily install the Release 3.0 database upgrade files on a supplementary server.

In addition, perform the database-specific tasks described in the section "Preparing an Oracle Database".

Preparing an Oracle Database

If you use an Oracle database, perform the following tasks before upgrading Portal:

Upgrading the Oracle Software and Database

You can use GPRS Manager 3.0 only on Oracle 9i or 10g.

Caution:

If you are using an earlier version of Oracle, you must upgrade it before you install GPRS Manager 3.0. For information on upgrading Oracle, see your Oracle documentation.

Changing the Database Character Set to UTF8

GPRS Manager 3.0 supports only the UTF8 character set. If your database character set is not UTF8, re-create your database with the UTF8 database character set.

For information on changing the database character set, see your Oracle documentation.

Configuring Oracle to Run the Upgrade Scripts

To run the database upgrade scripts, you must prepare your Oracle system as follows:

Setting Up Rollback Segments and Temporary Tablespaces

The upgrade scripts modify and sort many Portal tables. Some tables, such as EVENT_T, can contain millions of rows. The recommended rollback segment configuration for normal operation is inadequate for running the upgrade scripts. Therefore, you must adjust the size of the rollback segments to support the upgrade transactions:

  • Unless your database is very small, create two or three rollback segments that are half the size of your largest table (usually the EVENT_T table).

  • Take the smaller rollback segments used during normal operation offline while you run the upgrade scripts.

Granting New Privileges to the Oracle Portal User

The upgrade scripts require you to grant CREATE TABLE and CREATE SEQUENCE privileges directly to the Portal user pin.

To grant those privileges, enter these commands:

SQL> connect system/manager@databaseAlias
SQL> grant create table to pin;
Grant succeeded.
SQL> grant create sequence to pin;
Grant succeeded.
SQL> quit

Upgrading GPRS Manager

This section provides a complete 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.

To upgrade directly from GPRS Manager Release 2.0 to Release 3.0, perform some or all of these tasks, depending on your system:

  1. Backing Up GPRS Manager 2.0 Files

  2. Turning Off Portal Service Authentication and Authorization

  3. Shutting Down Portal

  4. Backing Up Your Portal Database

  5. Installing the Third-Party Software

  6. Installing GPRS Manager Server 3.0

  7. Installing the Upgrade Scripts

  8. Configuring the Upgrade Parameters

  9. Creating Required Database Objects and the Upgrade Log Directory

  10. Performing Pre-upgrade Sanity Checks

  11. Generating List of Tables and Indexes in 3.0 Schema

  12. Running the Database Upgrade Scripts

  13. Running pin_setup to Configure GPRS Manager

  14. Restoring Service Authentication

  15. Dropping Obsolete Database Objects from the Database (Optional)

  16. Upgrading Events

Backing Up GPRS Manager 2.0 Files

Before removing the old GPRS Manager Release 2.0 packages, back up your 2.0 files. In particular, ensure that you back up all customized files, including source code, pin.conf, and pin_setup.values files.

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 the Portal authentication module, see BRM RADIUS Manager in Oracle Communications Billing and Revenue Management (BRM) Documentation.

Shutting Down Portal

  1. Stop all Portal 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 the Connection Managers (CMs) and Data Managers (DMs) are not running.

  3. Ensure that no users are logged on to Portal.

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

Backing Up Your Portal Database

Make a complete offline backup of your Portal database, and ensure that the backup is completely valid and usable. For more information on performing full database backups, see your database software documentation.

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

Installing the Third-Party Software

Install the Third-Party software by following the instructions given in ”Installing the Third-Party Software” in BRM Installation Guide.

Installing GPRS Manager Server 3.0

  1. Install the GPRS Manager Server Release 3.0 package for your platform. Follow the instructions in ”Installing GPRS Manager 3.0" in BRM Telco Integration.

    Caution:

    Do not run the pin_setup script before upgrading your database. Running pin_setup before upgrading your database might corrupt your data.

    Important:

    • Pay particular attention to entries that specify your installation directory; CM and DM port numbers; and database host name, user name, and password.

    • Ensure that the $SETUP_INIT_DB entry is set to YES.

  2. Make a backup copy of the Portal_Home/setup/pin_setup.values file and save it to another location.

    Important:

    The upgrade scripts do not modify these files.

Installing the Upgrade Scripts

Install the upgrade package for your platform:

  1. Download the software to a temporary directory (temp_dir).

    Important:

    • If you download to a Windows workstation, use FTP to copy the .bin file to a temporary directory on your UNIX server.

    • You must increase the heap size used by the Java Virtual Machine (JVM) before running the installation program to avoid ”Out of Memory” error messages in the log file. For information, see ”Increasing heap size to avoid ”Out of Memory” error messages” in BRM Installation Guide.

  2. Go to the directory where you installed the Third-Party package and source the source.me file

    Caution:

    You must source the source.me file to proceed with installation, otherwise ”suitable JVM not found” and other error messages appear.

    Bash shell:

    source source.me.sh
      
    

    C shell:

    source source.me.csh
      
    
  3. Go to the temp_dir directory and enter this command:

    7.3_Patch_GPRS_20_30_OraUpg_platform_32_opt.bin
    

    Note:

    You can use the -console parameter to run the installation in command-line mode. To enable a graphical user interface (GUI) installation, install a GUI application such as X Windows and set the DISPLAY environment variable before you install the software.
  4. Follow the instructions displayed during installation.

Configuring the Upgrade Parameters

The upgrade.cfg file contains your upgrade parameters, such as which scripts to execute and whether to upgrade only the most recent data. You should customize these parameters to meet your business requirements.

To edit the upgrade.cfg file:

  1. Log in as user pin, go to Portal_Home/upgrade/gprs/20_30, and open the upgrade.cfg file in a text editor such as vi:

    % su - pin
    % cd Portal_Home/upgrade/gprs/20_30
    % vi upgrade.cfg
      
    
  2. Configure the file's parameters as necessary. For information on each parameter, see the comments in the upgrade.cfg file. Pay particular attention to the parameters described in Table 23-1:

    Table 23-1 upgrade.cfg File Parameters

    Parameter Description

    SQLPLUS

    IMP

    EXP

    Specify the location of the database utilities and executables. By default, they are set to sqlplus, imp, and exp, respectively.

    OWNER

    Specifies the Portal database user name. By default, this is set to pin.

    PASSWD

    Specifies the Portal database password. By default, this is set to pin.

    DBNAME

    Specifies the name of the Portal database you are upgrading. By default, this is set to pindb.

    PIN_CONF_TBLSPACEn

    PIN_CONF_TBLSPACEXn

    Specify the tablespaces where your new tables and indexes will be created.

    PIN_CONF_STORAGE_SMALL

    PIN_CONF_STORAGE_SMALL_INS

    PIN_CONF_STORAGE_MED

    PIN_CONF_STORAGE_MED_INS

    PIN_CONF_STORAGE_LARGE

    PIN_CONF_STORAGE_LARGE_INS

    Specify the storage parameters to use when the tables and indexes are created.

    Note: Information on how your tablespace and storage parameters are configured in Release 2.0 is in your Release 3.0 Portal_Home\setup\scripts\pin_tables.values file. You can use this information to help you configure the parameters in your Release 3.0 upgrade.cfg file.

    @ALL_SCRIPTS

    Specifies which upgrade scripts are executed by the upgrade.pl script. By default, all upgrade scripts are executed.

    $UPGRADE_LOG_DIR

    Specifies in which directory to create the log and pinlog files generated by the upgrade process.

    $UPG_DATA_START_TIME

    Specifies the start date for upgrading only the most recent data.

    Only objects created during the time period defined by $UPG_DATA_START_TIME and $UPG_DATA_END_TIME are upgraded. An object's created time is used to calculate the age of its data.

    Note:

    • This parameter applies only to event, item, bill, and ledger_report objects. The remainder of the Portal database is fully upgraded.

    • If you specify only a date, the default time is 00:00:00 on the specified date. Therefore, the start date is inclusive.

    • To upgrade all the data in your database, specify a date range that covers all the data. To find the entire range, run the upg_mgr.pl script with the -t parameter.

    $UPG_DATA_END_TIME

    Specifies the end date for upgrading only the most recent data.

    Important: You must change the default value of this parameter.

    Note: If you specify only a date, the default time is 00:00:00 on the specified date. Therefore, the end date is exclusive.

    For more information, see $UPG_DATA_START_TIME.


  3. Save and close the file.

Creating Required Database Objects and the Upgrade Log Directory

To create the database objects required for the upgrade and the upgrade log directory, run the upg_mgr.pl script with the -o parameter. For more information, see "About the upg_mgr.pl Script".

Performing Pre-upgrade Sanity Checks

Run the upg_mgr.pl script with the -s parameter to verify the following:

The -s parameter also reports how much disk space is required for event table partitioning.

Results are printed to the Portal_Home/upgrade/gprs/20_30/sqllog/pre_upg_sanity_chk2.sql.log file. For more information, see "About the upg_mgr.pl Script".

Note:

To reduce system downtime, you can perform the sanity checks before stopping Portal (see "Shutting Down Portal").

Generating List of Tables and Indexes in 3.0 Schema

To see what modifications you made to the default Release 2.0 database schema, compare the tables and indexes in your 2.0 database with those in the default 2.0 database. You need this information to interpret error messages that might be generated when you run the upgrade scripts (see "Running the Database Upgrade Scripts") and when you add custom tables and indexes to the upgraded Release 3.0 database.

Generating Your 3.0 Tables List

The schema_tbls.sql script generates a list of your Release 3.0 database table columns and writes it to the table_schema.out file.

Run the schema_tbls.sql script from the UNIX prompt:

% cd Portal_Home/upgrade/gprs/20_30
% perl upg_mgr.pl –e schema_tbls.sql

Generating 3.0 Index List

The schema_idxs.sql script generates a list of your Release 3.0 database indexes and writes it to the index_schema.out file.

Run the schema_idxs.sql script from the UNIX prompt:

% cd Portal_Home/upgrade/gprs/20_30
% perl upg_mgr.pl –e schema_idxs.sql

Running the Database Upgrade Scripts

The upgrade.pl script runs a series of scripts that upgrade the Release 2.0 database to Release 3.0. By default, the upgrade.pl script runs all the upgrade scripts.

To run only the offline scripts, you must first edit the upgrade.cfg file. See "Configuring the Upgrade Parameters".

For more information about the upgrade.pl script, see "About the upgrade.pl Script".

To upgrade your database schema:

  1. Run the upgrade.pl script from the UNIX prompt:

    % cd Portal_Home/upgrade/gprs/20_30
    % perl upgrade.pl
      
    
  2. Check each script's log and pinlog files in the directory specified by the UPGRADE_LOG_DIR parameter in your upgrade.cfg file (by default, Portal_Home/upgrade/gprs/20_30/sqllog). These log files show how long each script took to execute and list any errors that occurred.

    Important:

    If any errors are reported, fix them, and then rerun the upgrade.pl script.

Running pin_setup to Configure GPRS Manager

The pin_setup script reads the pin_setup.values file and configures Portal by initializing the database, configuring various pin.conf files, and starting various servers, including the dm_oracle server, the Connection Manager (CM), and the Java server.

To run the pin_setup script:

  1. Log in as user pin, go to the Portal_Home/setup directory, and run the pin_setup script:

    % su - pin
    % cd Portal_Home/setup
    % ./pin_setup 
      
    
  2. Check the following files for errors:

    • Portal_Home/setup/pin_setup.log

    • Portal_Home/sys/cm/CM.log

    • Portal_Home/var/cm/cm.pinlog

    • Portal_Home/sys/dm_database/DM.log

    • Portal_Home/var/dm_database/dm_database.pinlog

Restoring Service Authentication

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

Dropping Obsolete Database Objects from the Database (Optional)

Perform it after you verify that the upgrade is successful. Dropping obsolete database objects from the database is optional.

To drop obsolete database tables and columns, run the drop_tables.sql script from the UNIX prompt:

% cd Portal_Home/upgrade/gprs/20_30
% perl upgrade.pl drop_tables.sql

Upgrading Events

After you upgrade GPRS Manager from Release 2.0 to Release 3.0, you must check for old duplicate event types. To perform a check on the old duplicate event types, do one of the following:

  • Run GPRS Release 2.0 only to check for the old duplicate event types for the time specified by the network element. Next, run GPRS Release 2.0 and GPRS Release 3.0 in parallel to check the old and new duplicate event types respectively. Then, customize GPRS Release 3.0 to check both the old and new duplicate event types.

    Note:

    This option enables you to stay online all the time, requires both GPRS Release 2.0 and GPRS Release 3.0, needs a custom setup to be developed, requires migrating GPRS Release 2.0 services to GPRS Release 3.0, and requires pricing for both managers.
  • Run GPRS Release 3.0 to check for old duplicate event types. This can be done only if all open sessions can be closed.

    Note:

    This option requires an interruption of service, needs a custom setup to be developed, requires migrating the GPRS Release 2.0 services to GPRS Release 3.0, and requires pricing for both managers. This option requires only GPRS 3.0 version.
  • Pre-create /active_session objects in the database by maintaining information in TIMOS. If you do not use TIMOS, the active sessions can still be created. Then, perform a duplicate check on these /active_session objects. Performing a check on the active session objects serves the same purpose.

    Note:

    This option provides better performance and TIMOS would be more leveraged initially.

Command-Line Scripts

The following command-line scripts automate routine upgrade tasks:

Run these scripts from the UNIX prompt.

About the upg_mgr.pl Script

This Perl script performs many of the upgrade tasks, such as creating database objects and running sanity checks.

Syntax

perl upg_mgr.pl -o | -s | -e sql_script_name.sql | -r step_name | -d step_name | -t | -n | -h 

Note:

  • Specify only one parameter at a time.

  • Run upg_mgr.pl with the -o parameter before you run it with any other parameters.

  • If you omit sql_script_name after the -e parameter or step_name after the -r or -d parameter, the script does nothing.

Parameters

The upg_mgr.pl parameters are described in Table 23-2:

Table 23-2 upg_mgr.pl Parameters

Parameter Description

-o

Creates the database objects required for the upgrade.

Important: Run upg_mgr.pl with the -o parameter before you run it with any other parameters.

This parameter performs these operations:

  • Creates the UPG_LOG_T table that logs all the information about the upgrade.

  • Creates the pin_upg_common package that contains all the common routines for the upgrade.

-s

Runs the pre-upgrade sanity check. See "Performing Pre-upgrade Sanity Checks".

Note: This requires a database administrator (DBA) user name and password for the Portal database. See the upgrade.cfg file for details.

-e sql_script_name.sql

Executes the specified SQL script against the Portal schema. It replaces all the Perl variables before running the script.

Important: You must include the .sql extension with the script name.

-r step_name

Prints a report of the status of the specified step and directs the report to the Portal_Home/upgrade/gprs/20_30/sqllog/step_name.sql.pinlog file.

Important: Do not include the file extension with the script name.

-d step_name

Deletes all the information related to an upgrade script from the upgrade log tables.

After a script is run, its completion is logged in the upgrade log tables. If a user tries to rerun the script, the upgrade software first checks those tables. When it finds the script has already run, it skips the script. Thus, you must run upg_mgr.pl -d to delete all information about a previously run script from the tables before rerunning the script.

Important: Do not include the file extension with the script name.

-t

Displays the maximum and minimum CREATED_T for the EVENT_T, ITEM_T, and BILL_T tables.

-h

Displays these parameter descriptions.


About the upgrade.pl Script

This Perl script is the main upgrade script. It runs many other SQL scripts in the correct order.

To run all the scripts listed in the upgrade.cfg file's @ALL_SCRIPTS parameter, enter this command at the UNIX prompt:

% cd Portal_Home/upgrade/gprs/20_30
% perl upgrade.pl

Note:

The scripts are run in the order they are listed in the parameter. For more information, see "Configuring the Upgrade Parameters".

To run a single script, enter this command:

% cd Portal_Home/upgrade/gprs/20_30
% perl upgrade.pl script_name.sql

Important:

script_name must include the file extension.

About the Upgrade Scripts and Files

This section describes the scripts and files used to upgrade your Portal database.

Offline Scripts

The following scripts in Table 23-3 are configuration files executed offline.

Table 23-3 Offline Scripts

Script Description

pin_upg_common.sql

SQL script that creates the common routines needed for the upgrade.

add_new_tables_30.sql

SQL script that adds the new Release 3.0 tables.

add_new_indexes_30.sql

SQL script that adds the new Release 3.0 indexes.


Online Scripts

The following scripts in Table 23-4 are configuration files executed online.

Table 23-4 Online Scripts

Script Description

update_service_type.sql

SQL script that updates the service type from /service/ip/gprs to /service/telco/gprs and event type from /event/session/gprs to /event/session/telco/gprs.

drop_tables.sql

SQL script that drops the obsolete tables, which are not required in the new version.


Miscellaneous Scripts and Files

The following scripts in Table 23-5 are configuration files executed by offline or online scripts.

Table 23-5 Miscellaneous Scripts and Files

Script or File Description

schema_idxs.sql

SQL script that produces the index schema listings.

schema_tbls.sql

SQL script that produces the table schema listings.

delete_info.sql

SQL script that deletes the UPG_LOG_T table entries related to a specific script.

get_created_t.sql

SQL script that retrieves the max and min CREATED_T from various tables.

pre_upg_sanity_chk1.sql

pre_upg_sanity_chk2.sql

SQL scripts that perform sanity checks.

crt_pinlog.sql

SQL script that creates the pinlog files.

pin_pre_cmp_tcframework.pl

Perl script that configures the tcframework component.

pin_pre_cmp_gprs_30.pl

Perl script that configures the gprs_30 component.

pin_pre_cmp_tcf_aaa.pl

Perl script that configures the tcf_aaa component.

pin_pre_cmp_gprs_aaa.pl

Perl script that configures the gprs_aaa component.

upgrade.cfg

Configuration file in which you must enter details about the Oracle Server database configuration before you run the upgrade scripts. All the upgrade Perl scripts parse this file to get the database connection parameters.

upg_oracle_functions.pl

Perl script that performs many miscellaneous upgrade tasks related to the Oracle database.

upg_mgr.pl

Perl script that manages many miscellaneous upgrade tasks.

upgrade.pl

Master Perl script for the upgrade process. This Perl script calls other SQL scripts to perform the upgrade.

crt_upg_indexes.sql

SQL script that creates a unique index for BILL_T, EVENT_T, and ITEM_T tables.

drop_procedures.sql

SQL script that drops all the stored procedures from the Portal schema.