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 OLTP to Oracle Billing Insight Version 7.1

Follow these steps to migrate Oracle Billing Insight 7.0 OLTP to Oracle Billing Insight version 7.1.

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 OLTP to Oracle Billing Insight 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/oltp/migration/billinginsight7.0_to_7.1
   • Windows. EDX_HOME\db\oracle\oltp\migration\billinginsight7.0_to_7.1

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

3. Download required files from third-party Web sites:
   1. Download the hibernate-core-3.6.0.Final.jar file from the following site, and place it in the EDX_HOME/lib directory:

      http://mvnrepository.com/artifact/org.hibernate/hibernate-core/3.6.0.Final

   2. Download the hibernate-commons-annotations-3.2.0.Final.jar file from the following site, and place it in the EDX_HOME/db/oracle/oltp/migration/billinginsight7.0_to_7.1/lib/lib directory:

      https://mvnrepository.com/artifact/org.hibernate/hibernate-commons-annotations/3.2.0.Final

   3. Download the hibernate-jpa-2.0-api-1.0.0.Final.jar file from the following site, and place it in the EDX_HOME/db/oracle/oltp/migration/billinginsight7.0_to_7.1/lib/lib directory:

      https://mvnrepository.com/artifact/org.hibernate.javax.persistence/hibernate-jpa-2.0-api/1.0.0.Final

   4. Download the chasepaymentech_orbital_java_7.2.1.jar file from the following site, and place it in the EDX_HOME/db/oracle/oltp/migration/billinginsight7.0_to_7.1/lib/lib directory:
      
      https://secure.paymentech.com/developercenter/catalog/pages/orbital/sdks

      Extract the PaymentechSDK.jar file from the chasepaymentech_orbital_java_7.2.1.jar file.

4. Open the migrate_oltp_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
   OLTP_HOST	OLTP scheme host name
   LISTEN_PORT	OLTP scheme listen port
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   SYS_PASSWD	sys password
   ORACLE_HOME	Oracle installation directory
   EDX_HOME	Oracle Billing Insight product installation directory

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

   ant -f migrate_oltp_7.0_to_7.1.xml

7. To migrate the OLTP schema, select Option 1, Migrate OLTP schema.
8. To migrate the OLTP data, select Select Option 2, Migrate OLTP data.
9. Review all log files for possible errors.
10. (Do not run Options 3 and 4 until you have recreated the payment gateway in Step 18 in Process of Migrating Oracle Billing Insight Version 7.0 to Version 7.1. See that topic for details.)