Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 from Other Products > Roadmap for Migrating Oracle eStatement Manager Version 4.7 to Oracle Self-Service E-Billing Version 6.2 >

Migrating Oracle eStatement Manager Version 4.7 to Oracle Self-Service E-Billing 6.0.3

Follow these steps to migrate Oracle eStatement Manager 4.7 to Oracle Self-Service E-Billing 6.0.3 for both UNIX and Windows.

CAUTION:  You must complete the previous steps outlined in Roadmap for Migrating Oracle eStatement Manager Version 4.7 to Oracle Self-Service E-Billing Version 6.2 before migrating Oracle eStatement Manager 4.7 to Oracle Self-Service E-Billing 6.0.3, or the migration will fail.

This task is a step in Roadmap for Migrating Oracle eStatement Manager Version 4.7 to Oracle Self-Service E-Billing Version 6.2.

To migrate Oracle eStatement Manager 4.7 to Oracle Self-Service E-Billing 6.0.3

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/eaSuite47Fix Pack 1_to_603
   • Windows. EDX_HOME\db\ebilling\oracle\oltp\migration\eaSuite47Fix Pack 1_to_603

     You must run the migration process on the Oracle Self-Service E-Billing server.

3. Open the migrate_easuite47_to_603.properties file, and set the correct value for each property in the file.

   Property	Value
   ORACLE_HOME	ORACLE HOME directory
   ebilling_oltp_tnsname	OLTP tnsname
   ebilling_oltp_user	OLTP schema user name
   ebilling_oltp_paswd	OLTP schema password
   ebilling_oltp_sid	OLTP instance name
   ebilling_oltp_LISTEN_PORT	OLTP database listen port
   ebilling_oltp_hostname	OLTP database host name or IP address
   EBILLING_EAR_DIR	Directory containing the ebilling-weblogic-10-6.0.3.ear file after packaging LGPL libraries
   easuite_hostname	Host name or IP address of the Oracle eStatement Manager database
   easuite_db_port	Oracle eStatement Manager database listen port
   easuite_sid	Oracle eStatement Manager instance name
   easuite_user	Oracle eStatement Manager database schema name
   easuite_paswd	Oracle eStatement Manager database schema password

   NOTE:  Use a backslash (\) as the path separation character on Windows.

4. Save and close the migrate_easuite47_to_603.properties file.
5. Set the Java environment variable (JRE 1.6 is required), as shown in the following examples. In the variable, JDK150_11 is your JDK version.
   • UNIX. Run the following commands:

   export JAVA_HOME=/usr/local/bea10/jdk150_11

   export PATH=$JAVA_HOME/bin:$PATH

   • Windows. Run the following commands:

   set JAVA_HOME=d:\beak\jdk150_11

   set PATH=%JAVA_HOME%\bin;%PATH%

6. Run the following command to start migration:

   ant

7. Select Option 1 to install the migration-related objects.
8. Select Option 2 to prepare the Oracle Self-Service E-Billing 6.0.3 database.
9. Review all log files for possible errors. If there were no errors, then select Option 3, Post Migration Cleanup.
10. After migrating to Oracle Self-Service E-Billing 6.0.3, you must create a new Command Center administrator user; the old user ID and password will not work.

    For details on creating a new administrator user in the Command Center, see Administration Guide for Oracle Self-Service E-Billing.