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.
Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.