Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 > Process of Migrating Oracle Self-Service E-Billing Version 6.0.1 to Version 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, then you must follow these procedures. These steps are for both UNIX and Windows environments.

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 Version 6.0.1 to Version 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 version 6.0.1 databases.
2. Create a new database instance, tablespaces, and user for the new OLAP and OLTP databases. Do not use the automated Ant target.

   For complete instructions on running the Ant script, see Creating the Oracle Self-Service E-Billing Database Using Ant (Single Node).

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. In this command, OLTP_Schema is the name of the OLTP schema.

   GRANT CREATE DATABASE LINK TO OLTP_Schema;

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

   DROP DATABASE LINK TAM_LINK;

   4. 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. In this command, 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 version 6.0.1 into the new database.