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 Database from Oracle9i to Oracle Database 10g (UNIX and Windows)
This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 database from Oracle9i to Oracle Database 10g (10.2.0.2) on UNIX or Windows. 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 QF2 database from Oracle9i to Oracle Database 10g (10.2.0.2) on UNIX and Windows
- On UNIX, log in as the ORACLE user for migration activity. Export your existing Oracle Communications Billing Analytics version 5.1.1 OLAP and OLTP databases from Oracle9i:
exp system/manager@olap_sid file=olap_export.dmp FULL=Y
exp system/manager@oltp_sid file=oltp_export.dmp FULL=Y
- Install Oracle Database 10
g (10.2.0.2) to upgrade your database software.
- Create a new Oracle Database 10
g database instance for OLAP and OLTP to migrate your databases. Follow the procedures in this guide to create a new instance for both OLAP and OLTP.
- Create tablespaces and a user in the new OLAP and OLTP databases. Follow the steps in this guide to create tablespaces and users in the new OLAP and OLTP databases.
- Create the database link (TAM_LINK) in the OLTP schema if it was not successfully created during the import:
- Log on to the OLTP instance as SYSDBA and run the following command. In this command, OLTP_Schema is the name of the OLTP schema.
SQL> GRANT CREATE DATABASE LINK TO OLTP_Schema;
- Go to the following directory:
- Log on to the OLTP schema, using SQL*Plus, not as SYSDBA, and run the following script, providing the three input parameters:
SQL> DROP DATABASE LINK TAM_LINK;
SQL>@ crt_db_link.sql OLAP_User OLAP_Password OLAP_TNS_Name
where:
- OLAP_User
is the name of the OLAP schema user.
- OLAP_Password is the OLAP schema user's password.
- OLAP_TNS_Name is the name of the OLAP instance.
- Import your Oracle9i database into the new database:
imp system/manager@olap_sid fromuser=olap touser=olap file=olap_export.dmp
imp system/manager@oltp_sid fromuser=oltp touser=oltp file=olap_export.dmp
|