Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 from Other Products > Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0 >

Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database from Oracle9i to Oracle Database 10g (UNIX and Windows)


This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 database from Oracle9i to Oracle Database 10g (10.2.0.2) on UNIX or Windows.

This task is a step in Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0.

To migrate the Oracle Communications Billing Analytics version 5.1.1 QF2 database from Oracle9i to Oracle Database 10g (10.2.0.2) on UNIX and Windows

  1. On UNIX, log in as the ORACLE user for migration activity. Export your existing Oracle Communications Billing Analytics version 5.1.1 OLAP and OLTP databases from Oracle9i:

    exp system/manager@olap_sid file=olap_export.dmp FULL=Y

    exp system/manager@oltp_sid file=oltp_export.dmp FULL=Y

  2. Install Oracle Database 10g (10.2.0.2) to upgrade your database software.
  3. Create a new Oracle Database 10g database instance for OLAP and OLTP to migrate your databases. Follow the procedures in this guide to create a new instance for both OLAP and OLTP.
  4. Create tablespaces and a user in the new OLAP and OLTP databases. Follow the steps in this guide to create tablespaces and users in the new OLAP and OLTP databases.
  5. Create the database link (TAM_LINK) in the OLTP schema if it was not successfully created during the import:
    1. Log on to the OLTP instance as SYSDBA and run the following command. In this command, OLTP_Schema is the name of the OLTP schema.

    SQL> GRANT CREATE DATABASE LINK TO OLTP_Schema;

    1. Go to the following directory:
      • UNIX. EDX_HOME\db\ebilling\oracle
      • Windows. EDX_HOME/db/ebilling/oracle

        In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.

    2. Log on to the OLTP schema, using SQL*Plus, not as SYSDBA, and run the following script, providing the three input parameters:

    SQL> DROP DATABASE LINK TAM_LINK;

    SQL>@ crt_db_link.sql OLAP_User OLAP_Password OLAP_TNS_Name

    where:

    • OLAP_User is the name of the OLAP schema user.
    • OLAP_Password is the OLAP schema user's password.
    • OLAP_TNS_Name is the name of the OLAP instance.
  6. Import your Oracle9i database into the new database:

    imp system/manager@olap_sid fromuser=olap touser=olap file=olap_export.dmp

    imp system/manager@oltp_sid fromuser=oltp touser=oltp file=olap_export.dmp

Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.