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

Migrating Oracle Self-Service E-Billing Version 6.1 OLTP to Oracle Billing Insight Version 7.0

Follow these steps to migrate Oracle Self-Service E-Billing version 6.1 OLTP to Oracle Billing Insight version 7.0.

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

To migrate Oracle Self-Service E-Billing version 6.1 OLTP to Oracle Billing Insight 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/ebilling/oracle/oltp/migration/ebilling6.1_to_7.0
   • Windows. EDX_HOME\db\ebilling\oracle\oltp\migration\ebilling6.1_to_7.0

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

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

   Property	What to Set
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   OLTP_SID	OLTP SID (system identifier)
   OLTP_SYS_PASSWD	OLTP SYS password
   OLAP_USER	OLAP schema user name
   OLAP_PASSWD	OLAP schema password
   EBILL_SID	Your existing EBILL SID (instance name)
   SYS_PASSWD	sys password

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

   ant -f migrate_oltp_6.1_to_7.0.xml

6. Select Option 1, Export OLTP schema.
7. Select Option 2, Create OLTP tablespaces and OLTP user.
8. Select Option 3, Import OLTP schema into OLAP instance.
9. Select Option 4, Migrate OLTP schema.
10. Select Option 5, Migrate OLTP data.
11. Review all log files for possible errors.