Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 > Process of Migrating Oracle Self-Service E-Billing 6.0 to 6.0.1 >

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

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

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

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

1. Go to the EDX_HOME\eBilling\db\ebilling\oracle\oltp\migration\Ebilling_6.0_to_6.0.1 directory, where 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. Execute the userlock.sql script from the SQL*Plus prompt, where 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 as shown, where 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.