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

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 steps outlined in Roadmap for Migrating Oracle eStatement Manager Version 4.7 to Oracle Self-Service E-Billing Version 6.0.4 before migrating Oracle eStatement Manager 4.7 to Oracle Self-Service E-Billing 6.0.3.

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

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. Go to the EDX_HOME/db/ebilling/oracle/oltp/migration/eaSuite47Fix Pack 1_to_603 directory. You must run the migration process on the Oracle Self-Service E-Billing database server.
2. 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.

3. Save and close the migrate_easuite47_to_603.properties file.
4. Set the Java environment variable (JRE 1.5 is required), where JDK150_11 is your JDK version. For example:
   • UNIX:

   export JAVA_HOME=/usr/local/bea10/jdk150_11

   export PATH=$JAVA_HOME/bin:$PATH

   • WINDOWS:

   set JAVA_HOME=d:\beak\jdk150_11

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

5. Run the following command to start migration:

   ant

6. Select Option 1 to install the migration-related objects.
7. Select Option 2 to migrate Oracle eStatement Manager data to the Oracle Self-Service E-Billing 6.0.3 database.
8. Review all log files for possible errors. If there were no errors, select Option 3, Post Migration Cleanup.
9. 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.