Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 >

Process of Migrating Oracle Self-Service E-Billing Version 6.0.2 to Version 6.1.1

This topic describes the process required to migrate Oracle Self-Service E-Billing version 6.0.2 to version 6.1.1. Run the migration process on the Oracle Self-Service E-Billing database server only.

This process is a step in the following roadmaps:

• Roadmap for Migrating Oracle Self-Service E-Billing Version 6.0.x to Version 6.2
• Roadmap for Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.2

To migrate from Oracle Self-Service E-Billing version 6.0.2 directly to version 6.1.1, perform the following tasks:

1. Make sure that your installation of Oracle Self-Service E-Billing version 6.0.2 is at patch 9.
2. Write down your payment gateway and job configuration settings as shown in the Command Center. You must reenter the settings after migrating.
3. Back up your existing OLTP and OLAP Oracle Self-Service E-Billing databases.

   For additional information, see Oracle Database 11g documentation on Oracle Technology Network.

   Run the Notifier job to process all pending notifications

   For details on how to run the Notifier job, see Administration Guide for Oracle Self-Service E-Billing.

4. Process all pending batch reports in Oracle Self-Service E-Billing version 6.0.2 before migrating Oracle Self-Service E-Billing version 6.0.2 to version 6.1.1.

   For details on how to run batch report jobs, see Administration Guide for Oracle Self-Service E-Billing.

5. Upgrade your Oracle Database 11g to version 11.2.0.3.

   For additional information, see Oracle Database 11g documentation on Oracle Technology Network.

6. Update your Oracle Warehouse Builder (OWB) repository to version 11.2.0.3.
7. Perform the following installation tasks:
   1. Checking the Integrity of the Oracle Self-Service E-Billing Installer Package
   2. Installing the Oracle Self-Service E-Billing Software Using InstallAnywhere. Select Option 2, Oracle E-Billing and Migration Tools on the Product Features Screen.
   3. Configuring Log File Paths for Log4j
8. Perform the following migration tasks:
   1. Migrating Oracle Self-Service E-Billing Version 6.0.2 OLTP to Version 6.1.1
   2. Migrating Oracle Self-Service E-Billing Version 6.0.2 OLAP to Version 6.1.1
   3. Migrating Batch Reports from Oracle Self-Service E-Billing Version 6.0.2 to Version 6.1.1

      NOTE:  Some errors will occur when migrating the OLTP and OLAP databases because some database objects reference each other. Do not take any actions when the errors occur.

9. Run the following command on both the OLTP and OLAP schemas to verify that all objects are valid. The correct result is zero. Connect as the OLTP and OLAP schema owner.

   select count(*) from user_objects where status ='INVALID';

10. Configure your application server for Oracle Self-Service E-Billing version 6.1.1.

    Follow Roadmap for Configuring Oracle WebLogic for Oracle Self-Service E-Billing.

11. Follow the tasks and processes in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing. (Be sure to register the OLTP user in the Oracle Warehouse Builder, and verify that the OLTP location points to the OLAP instance.)
12. Uninstall Oracle Self-Service E-Billing version 6.0.2.

    For information about uninstalling, see Uninstalling Oracle Self-Service E-Billing.

13. Follow the steps in Creating a Bootstrap Administrator User for Oracle Self-Service E-Billing to create the bootstrap, or default, Oracle Self-Service E-Billing administrative user.
14. Recreate the payment gateway and jobs, using the Command Center.

    For details, see Administration Guide for Oracle Self-Service E-Billing.