Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 from Other Products > Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0 >
Migrating the Oracle Communications Billing Analytics Version 5.1.1 OLAP Schema to Oracle Self-Service E-Billing Version 6.0 on UNIX
This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 OLAP schema to Oracle Self-Service E-Billing version 6.0 on UNIX. This task is a step in Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0. To migrate the Oracle Communications Billing Analytics version 5.1.1 OLAP schema to Oracle Self-Service E-Billing version 6.0 on UNIX
- Log in as the ORACLE user for migration activity on UNIX. Go to the
EDX_HOME \db\oracle\olap\migration\511_to_6.0 directory. In the path, EDX_HOME is the Oracle Self-Service E-Billing installation directory.
- Verify that the following files exist:
migrate_olap_511_to_6.0.sh
migrate_olap_511_to_6.0.sql
Create_Tables.sql
Load_Data.sql
Create_Sequences.sql
Create_Procedure.sql
Create_Views.sql
Create_Indexes.sql
Create_Constraints.sql
dblink.sql
- Log in to the database as SYSDBA:
export ORACLE_SID=myolap
sqlplus "/as sysdba"
- Grant the create materialized view privilege to the user you are migrating. In the command, User Name is the name of the user.
SQL> grant create materialized view to User Name ;
- Replace the following parameters in the dblink.sql file with the values appropriate for your installation.
|
|
OLTP_USERNAME |
The name of the OLTP schema user. |
OLTP_PASSWORD |
The password of the OLTP schema user. |
OLTP_SID |
The name of the OLTPinstance. |
- Log in to the OLAP database as the user who you are migrating, Run the following script to create the database link name OLTP_LINK. Do not run the dblink.sql script as SYSDBA:
dblink.sql
- Execute the following commands at the shell prompt:
chmod 777 migrate_oltp_511_to_6.0.sh
./migrate_oltp_511_to_6.0.sh
- Provide the correct values for your environment.
|
|
OLAP Database SID |
OLAP instance name, such as OLAP |
OLAP Database Username |
OLAP schema name, such as OLAP |
OLAP Database Password |
OLAP schema password |
OLAP SYS Password |
Password of the SYSDBA |
OLTP TNS Name |
The TNS name for OLTP, such as OLTP |
OLTP Database Username |
OLTP schema name, such as OLTP |
OLTP Database Password |
OLTP schema password |
- Check for errors in the following log files:
db_olap_migrate_511_6.0.log
migrate_olap_511_to_6.0.log
|