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 to Version 6.0.1 >

Migrating Oracle Self-Service E-Billing Version 6.0 OLTP to Version 6.0.1 OLTP on Windows

If you are migrating from Oracle Self-Service E-Billing version 6.0 to version 6.0.1 on Windows, then follow these steps to migrate your OLTP database.

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

To migrate your Oracle Self-Service E-Billing version 6.0 OLTP database to version 6.0.1

1. Go to the EDX_HOME\eBilling\db\ebilling\oracle\oltp\migration\Ebilling_6.0_to_6.0.1 directory. In the directory, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
2. Verify that the migrate_oltp_6.0_to_6.0.1.sql file exists.
3. Run the userlock.sql script from the SQL*Plus prompt. In the script, sys_password is the password of the sys user.

   C:\set ORACLE_SID=oltp

   C:\sqlplus sys/sys_password as sysdba

4. Run the userlock.sql script as shown. In this script, ORACLE_HOME is the directory where the Oracle database software is installed.

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

   SQL> exit;

5. Run the migration script as follows:

   C:\set ORACLE_SID=oltp

   C:\sqlplus oltp/oltp

   SQL> @ migrate_oltp_6.0_to_6.0.1.sql

   SQL> exit;

6. Check the db_oltp_migrate_6.0_6.0.1.log and migrate_oltp_6.0_to_6.0.1.log files for errors.