Installation Guide for Oracle Billing Insight > Migrating to Oracle Billing Insight 7.1 > Process of Migrating Oracle Billing Insight Version 7.0 to Version 7.1 >

Migrating Oracle Billing Insight Version 7.0 OLAP to Oracle Billing Insight Version 7.1

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

This task is a step in Process of Migrating Oracle Billing Insight Version 7.0 to Version 7.1.

To migrate Oracle Billing Insight version 7.0 OLAP to version 7.1

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/billinginsight7.0_to_7.1
   • Windows. EDX_HOME\db\oracle\olap\migration\billinginsight7.0_to_7.1

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

3. Open the migrate_olap_7.0_to_7.1.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). If you are using a pluggable database, then enter the pluggable SID.
   EBILL_TNS_NAME	EBILL TNS (Transparent Network Substrate) Name
   TOPX_REC_CAP	The cap on the number of records to be calculated for Top Usage tables. The default is 51. Changing this value impacts the processing time for the data load process (post load process). Do Not Exceed 100.
   EBILL_APPLICATION	The application you are migrating, either TELCO or UTILITY, selected during installation. (Do not change this value.)
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   SYS_PASSWD	sys password

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

   ant -f migrate_olap_7.0_to_7.1.xml

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