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 eStatement Component to Oracle Self-Service E-Billing Version 6.0 on UNIX and Windows

This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 eStatement component to Oracle Self-Service E-Billing version 6.0 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 eStatement Component to Oracle Self-Service E-Billing version 6.0 on UNIX and Windows

1. On UNIX, log in as the ORACLE user for migration activity.
2. Go to the following directory. In the path, 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
3. 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.

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

   ant migrate

   The script 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)

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