Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 From Other Products > Process of Migrating the Oracle Communications Billing Analytics 5.1.1 Database to Oracle Self-Service E-Billing 6.0. >
Migrating the Oracle Communications Billing Analytics 5.1.1 OLAP Schema to Oracle Self-Service E-Billing 6.0 on UNIX
These instructions describe how to migrate the Oracle Communications Billing Analytics 5.1.1 OLAP schema to Oracle Self-Service E-Billing 6.0 on UNIX. This task is a step in Process of Migrating the Oracle Communications Billing Analytics 5.1.1 Database to Oracle Self-Service E-Billing 6.0.. To migrate the Oracle Communications Billing Analytics 5.1.1 OLAP schema to Oracle Self-Service E-Billing 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, where 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, such as OLAP |
OLAP SYS Password |
Password of the SYSDBA, such as change_on_install |
OLTP TNS Name |
Enter the TNS name for OLTP, such as OLTP |
OLTP Database Username |
OLTP schema name, such as OLTP |
OLTP Database Password |
OLTP schema password, such as OLTP |
- Check for errors in the following log files:
db_olap_migrate_511_6.0.log
migrate_olap_511_to_6.0.log
|