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.1 to Version 6.2 >

Migrating Oracle Self-Service E-Billing Version 6.1 OLTP to Version 6.2

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

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

To migrate Oracle Self-Service E-Billing version 6.1 OLTP to version 6.2

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_6.2
   • Windows. EDX_HOME\db\ebilling\oracle\oltp\migration\ebilling6.1_to_6.2

     In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.

3. Open the migrate_oltp_6.1_to_6.2.properties file, and set the correct value for each property in this file.

   Property	Value
   OLTP_USER	OLTP schema user name
   OLTP_PASSWD	OLTP schema password
   OLTP_SID	OLTP instance name
   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.

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

   ant -f migrate_oltp_6.1_to_6.2.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. Select Option 6, Drop redundant objects.

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

12. Review all log files for possible errors.