Installation Guide for Oracle Billing Insight > Migrating to Oracle Billing Insight 7.0 > Process of Migrating Oracle Self-Service E-Billing Version 6.2 to Oracle Billing Insight Version 7.0 >

Migrating Oracle Self-Service E-Billing Version 6.2 OLAP to Oracle Billing Insight Version 7.0

Follow these steps to migrate Oracle Billing Insight version 6.2 OLAP to version 7.0 for both UNIX and Windows.

This task is a step in Process of Migrating Oracle Self-Service E-Billing Version 6.2 to Oracle Billing Insight Version 7.0.

To migrate Oracle Billing Insight version 6.2 OLAP to version 7.0

1. On UNIX, log in as the ORACLE user for migration activity.
2. Go to the following directory:
   • UNIX. EDX_HOME/db/oracle/olap/migration/ebilling6.2_to_7.0
   • Windows. EDX_HOME\db\oracle\olap\migration\ebilling6.2_to_7.0

     In the path, EDX_HOME is the location where Oracle Billing Insight is installed.

3. Open the migrate_olap_6.2_to_7.0.properties file, and set the correct value for each property in the file.

   Property	What to Set
   OLAP_USER	OLAP schema user name
   OLAP_PASSWD	OLAP schema password
   EBILL_SID	Your existing EBILL SID (instance name)
   TOPX_REC_CAP	The cap on the number of records to be calculated for TopX tables. The default is 51. Changing this value impacts the processing time for the data load process (post load process). Do Not Exceed 100.
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   SYS_PASSWD	sys password

4. Save and close the migrate_olap_6.2_to_7.0.properties file.
5. Run the following command to start the migration:

   ant -f migrate_olap_6.2_to_7.0.xml

6. Select Option 1, Migrate OLAP Schema.
7. Select Option 2, Migrate OLAP data.
8. Review all log files for possible errors.