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 UNIX

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

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 UNIX

1. On UNIX, log in as the ORACLE user for migration activity. Go to the EDX_HOME/db/ebilling/oracle/olap/migration/ebilling_6.0.1_to_6.0.2 directory. In the path, 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 at the shell prompt:

   Bash$ chmod 777 migrate_olap_6.0.1_to_6.0.2.sh

   Bash$ . migrate_olap_6.0.1_to_6.0.2.sh

4. Provide the correct values for your environment.

   Field	What to Enter
   OLAP Database SID	OLAP instance name
   OLAP Database Username	OLAP schema name
   OLAP Database Password	OLAP schema password
   OLAP SYS Password	Password of SYS
   Mail server name. Appears only if you are migrating to Oracle Database 11g.	Mail server name
   Lower Port. Appears only if you are migrating to Oracle Database 11g.	Lower port number of the mail server
   Upper Port. Appears only if you are migrating to Oracle Database 11g.	Upper port number of the mail server

5. Check the db_olap_migrate_6.0.1_6.0.2.log, and migrate_olap_6.0.1_to_6.0.2.log files for errors.