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

1. 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.
2. 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
3. Log in to the database as SYSDBA:

   export ORACLE_SID=myolap

   sqlplus "/as sysdba"

4. 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;

5. Replace the following parameters in the dblink.sql file with the values appropriate for your installation.

   Parameter	Value
   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.

6. 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

7. Execute the following commands at the shell prompt:

   chmod 777 migrate_oltp_511_to_6.0.sh

   ./migrate_oltp_511_to_6.0.sh

8. Provide the correct values for your environment.

   Field	What to Enter
   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

9. Check for errors in the following log files:
   • db_olap_migrate_511_6.0.log
   • migrate_olap_511_to_6.0.log