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 OLAP to Version 6.1.1
Follow these steps to migrate Oracle Self-Service E-Billing version 6.0.2 OLAP 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 OLAP to version 6.1.1
- On UNIX, log in as the ORACLE user for migration activity.
- Open the migrate_olap_6.0.2_to_6.1.1.properties file found in the following directory:
- UNIX:
EDX_HOME /db/oracle/olap/migration/ebilling6.0.2_to_6.1.1
- Windows:
EDX_HOME \db\oracle\olap\migration\ebilling6.0.2_to_6.1.1
- Set the correct value for each property in the file.
|
|
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. |
OLTP_USER |
OLTP schema user name |
OLTP_PASSWD |
OLTP schema password |
SYS_PASSWD |
OLAP SYS user password |
L_DB_EDX_DATA_TB_FILE_LOC |
Data tablespace file location, for example: /export/home/oracle/oradata |
GRP_MOVE_INDIR |
The input directory path to use when moving ETL groups, for example: /export/home/oracle/testdata/GRPMV_INDATA |
GRP_MOVE_OUTDIR |
The output directory path to use when moving ETL groups, for example: /export/home/oracle/testdata/GRPMV_OUTDATA |
- Save and close the migrate_oltp_6.0.2_to_6.1.1.properties file.
- Run the following command:
ant -f migrate_olap_6.0.2_to_6.1.1.xml
- Select Option 1, Create New Staging Tablespaces for OLAP schema.
- Select Option 2, Migrate OLAP Schema.
- Select Option 3, Drop redundant object.
- Select Option 4, Migrate OLAP data.
BUILD SUCCESSFUL displays on the console screen if migration is successful.
- Review all log files for possible errors.
|