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 UNIX

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

1. On UNIX, log in as the ORACLE user for migration activity. Run the following commands from SQL*Plus:

   bash$ export ORACLE_SID=oltp

   bash$ 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.
2. Go to the EDX_HOME/db/ebilling/oracle/oltp/migration/ebilling_6.0.1_to_6.0.2 directory.
3. 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
4. Run the following commands at the shell prompt:

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

   Bash$ . migrate_oltp_6.0.1_to_6.0.2.sh

5. Provide the correct values for your environment.

   Field	What to Enter
   OLTP Database SID	OLTP instance name
   OLTP Database Username	OLTP schema name
   OLTP Database Password	OLTP schema password
   OLTP SYS Password	Password of SYS

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