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 Oracle Self-Service E-Billing Version 6.0.1 OLAP to Version 6.0.2 on Microsoft Windows

Follow these steps to migrate Oracle Self-Service E-Billing version 6.0.1 OLAP to version 6.0.2 on Microsoft Windows.

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 version 6.0.1 OLAP to version 6.0.2 on Microsoft Windows

1. Go to the EDX_HOME\db\ebilling\oracle\olap\migration\ebilling_6.0.1_to_6.0.2 directory. In the directory, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
2. Verify that the following files exist:
   • migrate_olap_6.0.1_to_6.0.2.sh
   • migrate_olap_6.0.1_to_6.0.2.sql
   • Create_Procedure.sql
   • Version.sql
3. Run the following commands from SQL*Plus:

   C:\set ORACLE_SID=olap

   C:\sqlplus olap/olap

   SQL> @ migrate_olap_6.0.1_to_6.0.2.sql

   SQL> exit;

4. Check the migrate_olap_6.0.1_to_6.0.2.log file for Oracle errors.
5. If you are migrating to Oracle Database 11g, then follow these steps:
   1. Run the acl.sql script, located in EDX_HOME\db\ebilling\oracle\olap\etl\packages directory, as follows:

   set ORACLE_SID=olap

   Sqlplus olap/olap

   SQL>acl.sql Mail_Server_Name Lower_Port_of_Mail_Server Upper_Port_of_Mail_Server

   SQL>exit

   where:

   • Mail_Server_Name is the name of your mail server.
   • Lower_Port_of_Mail_Server is the lower port number of your mail server.
   • Upper_Port_of_Mail_Server is the upper port number of your mail server.
   2. Check acl.log for errors. Ignore ORA-31003 and ORA-06512.