Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 > Process of Migrating Oracle Self-Service E-Billing 6.0.1 to 6.0.2 >

Migrating to Oracle Database 11g

If you are migrating Oracle Self-Service E-Billing from Oracle Database 10g to Oracle Database 11g, you must follow these procedures. These steps are for both UNIX and Windows environments.

CAUTION:  This procedure is not required if your Oracle Self-Service E-Billing installation is on Oracle Database 10g.

This task is a step in Process of Migrating Oracle Self-Service E-Billing 6.0.1 to 6.0.2.

To migrate Oracle Self-Service E-Billing from Oracle Database 10g to Oracle Database 11g

1. On UNIX, log in as the ORACLE user for migration activity. Export your OLAP and OLTP Oracle Self-Service E-Billing 6.0.1 databases.
2. Create a new database instance, tablespaces, and user for the new OLAP and OLTP databases. For complete instructions on running the Ant script, see Creating the Oracle Self-Service E-Billing Database Using Ant. Do not use the automated Ant target.
3. Create the database link (TAM_LINK) in the OLTP schema:
   1. Log on to the OLTP instance as SYSDBA, and run the following command, where OLTP_Schema is the name of the OLTP schema:

   GRANT CREATE DATABASE LINK TO OLTP_Schema;

   2. Go to the EDX_HOME/db/ebilling/oracle directory. Log on to the OLTP schema using SQL*Plus (not as SYSDBA), and run the following command:

   DROP DATABASE LINK TAM_LINK;

   3. Run the following script at SQL prompt:

   SQL>@ crt_db_link.sql OLAP_User OLAP_Password OLAP_TNS_Name

   SQL>exit

   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.
4. Create the database link (OLTP_LINK) in the OLAP schema:
   1. Log on to the OLAP instance as SYSDBA, and run the following command, where OLAP_Schema is the name of the OLAP schema:

   GRANT CREATE DATABASE LINK TO OLAP_Schema;

   2. Log on to the OLAP schema using SQL*Plus (not as SYSDBA), and run the following commands:

   SQL> DROP DATABASE LINK OLTP_LINK;

   SQL>CREATE DATABASE LINK OLTP_LINK CONNECT TO OLTP_USER IDENTIFIED BY OLTP_ Password USING 'OLTP_TNS_Name';

   SQL>exit

   where:

   • OLTP_User is the name of the OLTP schema user.
   • OLTP_Password is the OLTP schema user's password.
   • OLTP_TNS_Name is the name of the OLTP instance.
5. Import the OLAP and OLTP schemas for Oracle Self-Service E-Billing 6.0.1 into the new database.