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 OLTP to Version 6.0.2 on Microsoft Windows

Follow these steps to migrate Oracle Self-Service E-Billing version 6.0.1 OLTP 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 OLTP to version 6.0.2 on Microsoft Windows

1. Go to the EDX_HOME\db\ebilling\oracle\oltp\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_oltp_6.0.1_to_6.0.2.sh
   • migrate_oltp_6.0.1_to_6.0.2.sql
   • Create_Procedure.sql
3. Run the following commands from SQL*Plus:

   C:\set ORACLE_SID=oltp

   C:\sqlplus sys/sys_password as sysdba

   SQL> @ Oracle_Home\rdbms\admin\userlock.sql

   SQL> exit;

   where:

   • sys_password is the password of the sys user.
   • Oracle_Home is the exact path where Oracle database is installed.
4. Run the following commands from SQL*Plus:

   C:\set ORACLE_SID=oltp

   C:\sqlplus oltp/oltp

   SQL> @ migrate_oltp_6.0.1_to_6.0.2.sql

   SQL> exit;

5. Check the migrate_oltp_6.0.1_to_6.0.2.log, and db_oltp_migrate_6.0.1_to_6.0.2.log files for errors.