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

Migrating the Oracle Communications Billing Analytics 5.1.1 eStatement Component to Oracle Self-Service E-Billing 6.0 on UNIX and Windows

This topic describes how to migrate the Oracle Communications Billing Analytics 5.1.1 eStatement component to Oracle Self-Service E-Billing 6.0 on UNIX or Windows.

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

To migrate the Oracle Communications Billing Analytics 5.1.1 eStatement Component to Oracle Self-Service E-Billing 6.0 on UNIX and Windows

1. On UNIX, log in as the ORACLE user for migration activity. Go to the following directory, where EDX_HOME is the location where Oracle Communications Billing Analytics is installed:
   • UNIX. EDX_HOME/db/eStatement/oracle/migration
   • Windows. EDX_HOME\db\eStatement\oracle\migration
2. Edit the migrate.properties file, and modify the parameters in the following statements for your OLTP database environment.

   This file controls the eStatement database migration.

   Property	Value
   DB_SID=EDX44	Change the OLTP instance name.
   DB_USERNAME=edx_dba	Change the OLTP schema user name.
   DB_PASSWORD=edx	Change the OLTP schema password.

3. Also in the migrate.properties file, edit the following statements to specify the appropriate file location:
   • Large data tablespace file location: LARGE_DB_EDX_DATA_TB_FILE_LOC=/export/home/oracle/oradata
   • Large index tablespace file location: LARGE_DB_EDX_INDX_TB_FILE_LOC=/export/home/oracle/oradata
   • Medium data tablespace file location: MEDIUM_DB_EDX_DATA_TB_FILE_LOC=/export/home/oracle/oradata
   • Medium index tablespace file location: MEDIUM_DB_EDX_INDX_TB_FILE_LOC=/export/home/oracle/oradata
4. Go to your eStatement database home directory, for example:
   • UNIX. EDX_HOME/db/eStatement/oracle
   • Windows. EDX_HOME\db\eStatement\oracle
5. Run the following Ant target to migrate.

   ant migrate

   The install-migrate target migrates eStatement instances with the SIDs specified in the properties file. The following message appears:

   get_backup_confirm:

   **Warning** We strongly advise a full backup of your existing database before applying the migration. Do you have a backup (Y,y,N,n)

6. Enter Y if you have a backup, or N if you do not.
7. Enter Y to continue the migration process.
8. Select Option 1, Migrate from 4.3.0.0 Migrate to 4.7.0.0.