Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 > Process of Migrating Oracle Self-Service E-Billing Version 6.0.2 to Version 6.1.1 >

Migrating Oracle Self-Service E-Billing Version 6.0.2 OLTP to Version 6.1.1

Follow these steps to migrate Oracle Self-Service E-Billing version 6.0.2 OLTP to version 6.1.1 for both UNIX and Windows.

This task is a step in Process of Migrating Oracle Self-Service E-Billing Version 6.0.2 to Version 6.1.1.

To migrate Oracle Self-Service E-Billing version 6.0.2 OLTP to version 6.1.1

1. On UNIX, log in as the ORACLE user for migration activity.
2. Download the hibernate-3.1.3.jar file from the following Web site:

   http://search.maven.org/remotecontent?filepath=org/hibernate/hibernate/3.1.3/hibernate-3.1.3.jar

3. Place the hibernate-3.1.3.jar file in the following directory:
   • UNIX: EDX_HOME/db/oracle/oltp/migration/ebilling6.0.2_to_6.1.1/lib/lib
   • Windows: EDX_HOME\db\oracle\oltp\migration\ebilling6.0.2_to_6.1.1\lib\lib
4. Open the migrate_oltp_6.0.2_to_6.1.1.properties file found in the following directory:
   • UNIX: EDX_HOME/db/oracle/oltp/migration/ebilling6.0.2_to_6.1.1
   • Windows: EDX_HOME\db\oracle\oltp\migration\ebilling6.0.2_to_6.1.1
5. Set the correct value for each property in the file.

   Property	Value
   ORACLE_HOME	ORACLE HOME directory
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   OLTP_SID	OLTP instance name
   LISTEN_PORT	The listening port for the new EBILL SID
   OLTP_HOST	OLTP database host name or IP address (to be used for the new EBILL database)
   OLTP_SYS_PASSWD	OLTP sys user password
   OLAP_USER	OLAP schema user name
   OLAP_PASSWD	OLAP schema password
   EBILL_SID	Your existing OLAP SID (instance name), to be used for the new EBILL database.
   OLAP_SYS_PASSWD	OLAP sys user password
   L_DB_EDX_DATA_TB_FILE_LOC	The folder location where the installation script creates the L_DB_EDX_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_EDX_INDX_TB_FILE_LOC	The folder location where the installation script creates the L_DB_EDX_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_APP_DATA_TB_FILE_LOC	The folder location where the installation script creates the L_DB_APP_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_APP_INDX_TB_FILE_LOC	The folder location where the installation script creates the L_DB_APP_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_LOAD_DATA_TB_FILE_ LOC	The folder location where the installation script creates the L_DB_LOAD_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_LOAD_INDX_TB_FILE_ LOC	The folder location where the installation script creates the L_DB_LOAD_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_FS_DATA_TB_FILE_ LOC	The folder location where the installation script creates the L_DB_FS_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_FS_INDX_TB_FILE_ LOC	The folder location where the installation script creates the L_DB_FS_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_STG_DATA_TB_FILE_LOC	The folder location where the installation script creates the L_DB_STG_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   L_DB_STG_INDX_TB_FILE_LOC	The folder location where the installation script creates the L_DB_STG_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   LARGE_DB_EDX_DATA_TB_ FILE_LOC	The folder location where the installation script creates the LARGE_DB_EDX_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   LARGE_DB_EDX_INDX_TB_ FILE_LOC	The folder location where the installation script creates the LARGE_DB_EDX_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   MEDIUM_DB_EDX_DATA_TB_ FILE_LOC	The folder location where the installation script creates the MEDIUM_DB_EDX_DATA_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.
   MEDIUM_DB_EDX_INDX_TB_ FILE_LOC	The folder location where the installation script creates the MEDIUM_DB_EDX_INDX_TB_FILE_LOC OLTP schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

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

6. Save and close the migrate_oltp_6.0.2_to_6.1.1.properties file.
7. Run the following command:

   ant -f migrate_oltp_6.0.2_to_6.1.1.xml

8. Select Option 1, Export OLTP schema.
9. Select Option 2, Create OLTP tablespaces and OLTP user.
10. Select Option 3, Import OLTP schema into OLAP instance.
11. Select Option 4, Prepare E-Billing 6.0.2 OLTP db.
12. Select Option 5, Data Reencryption.
13. Select Option 6, Post Reencryption cleanup.
14. Select Option 7, Migrate OLTP schema.
15. Select Option 8, Migrate OLTP data.

    BUILD SUCCESSFUL displays on the console screen if migration is successful.

16. Review all log files for possible errors.